Importing data.
I have an excelworkbook with data-output.
1st row are headers 1st collumn holds a previously assign id I need to import the data from 1 workbook into another workbook per assigned ID (preferably the data from each ID directly into predetermend cells in the new workbook). ID's are numbers: 1 to 50. however, one ID number can be on several rows with different data in the collumns behind it. eg: 1 2 2 2 3 4 Not every collumn holds data for every ID and no empty cells should be imported yet headers of colloms holding data should. e.g. collomn 1 through 8 and collomn 34 through 47 hold data for ID 1- 4through 7 and 22. Can anybody tell me how to do this..? And is it possible to automate this with a macro and if so how..? any help would be much appreciated. |
All times are GMT +1. The time now is 11:10 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com