| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
return data to specific columns?
Hi- Workbook1 contains the source data: Column A (ID)/column B (authorName)/column C (title)/... 2/John Doe/Gardening 3/Jane Doe/Plants 3/M. Smith/Trees ... The data needs to be returned to workbook2 and placed in *specific* columns depending on the ID value. The 'authorName' should always be returned to column 1; but the location of 'title' varies depending on the ID: So, if the ID in book1 is 3, then in book2 place 'authorName' in column 1 and 'title' in column 3; if the ID is 2, return data to columns 1 and 5. Is there a macro that will do this? Thanks! -- marlea ------------------------------------------------------------------------ marlea's Profile: http://www.excelforum.com/member.php...o&userid=26209 View this thread: http://www.excelforum.com/showthread...hreadid=465944 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do you use sumproduct to return specific cell data? | Excel Worksheet Functions | |||
| Search for a number in a table and return data of a specific cell | Excel Discussion (Misc queries) | |||
| How to return a specific data point from a large array if I don't know the exact location? | Excel Discussion (Misc queries) | |||
| search multiple sheets for specific date, return data in cell to r | Excel Discussion (Misc queries) | |||
| import data to specific columns | Excel Discussion (Misc queries) | |||
Threaded Mode
