| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Finding and Replacing Data in a Header Row
I download an excel file from an outside source (which I have no control over the what columns, rows that are or, are not included)... raw data. There can be 60-120 columns of data. Row 1 Contains the Headers.
The raw data is on Sheet 3, row 1... EXAMPLE: Column AM, the project name is; "D26B Faucets (Rollout) [000000419]", There can be anywhere from 10-30 projects listed in Row 1 I have a Project List on Sheet 4 Column N which will contain "D26B Faucets" and as many as 10-30 projects WHAT I NEED: is the most efficient and effective way to replace the Project Names on Sheet3 with those names on Sheet4. Any ideas would be appreciated! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| finding and replacing | Excel Worksheet Functions | |||
| Finding & Replacing a list of Data in Multiple Columns | Excel Worksheet Functions | |||
| Finding and Replacing | Excel Discussion (Misc queries) | |||
| Finding, Replacing and Cut & Paste | Excel Worksheet Functions | |||
| Finding and Replacing a "?" | Excel Discussion (Misc queries) | |||
Hybrid Mode
