| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Need data from one worksheet to be in a list in another worksheet.
Worksheet 1
A B C D 12956-01 A 5 9 94539-03B D 3 7 45567-02 A 20 8 12956-02B B 12 2 947345-05 Q 2 3 Worksheet 2 A B C 12956 12956-01 5 12956-02B 12 Is there a formula where I can take everything starting with 12956 in Col A and its value in Col C from Worksheet 1 and put it in Worksheet 2? In worksheet 2 I have the 6 digit number I am looking for located in A1 because I will need to change it often, but in worksheet 1 that number has an hyphen with up 3 characters behind it. My worksheet 1 has a few thousand rows and I just can't seem to find the right formula. Can anyone help? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro | Excel Discussion (Misc queries) | |||
| Populating worksheet via a drop down list ! | Excel Worksheet Functions | |||
| Using a data validation list to look up a defined named range in another worksheet | Charts and Charting in Excel | |||
| Comparing a list to a Calendar worksheet. | Excel Worksheet Functions | |||
| Convert PivotTable data into a worksheet list | Excel Worksheet Functions | |||
Threaded Mode
