I'm a relative newbie at vba coding and am finding this problem to be beyond my skill set, so any help would be much appreciated:
I have a hundred or so excel workbooks labelled as a unique identifier with exactly the same columns filled with data, the data is always on the 1st sheet but the number of rows filled does change however (as they were all built from a template but no more than a 100 rows). I am trying to create a master workbook to access the data in each of these files quickly and efficiently. The columns of the data are years and each row has a variable name with some blank rows before the end of the data as it made for easier reading.
What i am essentially hoping to do is to be able to enter the unique identifier into cell B1 or wherever, and a macro to copy and paste the data for the 6 years for each of the variables given in column A. I guess a bit like a lookup function but in the workbook given by the unique identifier.
Many thanks for any help you can offer, i have been working at this for faaaar too long now.
I have a hundred or so excel workbooks labelled as a unique identifier with exactly the same columns filled with data, the data is always on the 1st sheet but the number of rows filled does change however (as they were all built from a template but no more than a 100 rows). I am trying to create a master workbook to access the data in each of these files quickly and efficiently. The columns of the data are years and each row has a variable name with some blank rows before the end of the data as it made for easier reading.
What i am essentially hoping to do is to be able to enter the unique identifier into cell B1 or wherever, and a macro to copy and paste the data for the 6 years for each of the variables given in column A. I guess a bit like a lookup function but in the workbook given by the unique identifier.
Many thanks for any help you can offer, i have been working at this for faaaar too long now.