E
eric.fader
Hi:
I am consolidating data from multiple spreadsheets into one. I have
successfully done this for fixed cells from each of the individual
sheets.
I am having trouble doing this for another set of sheets where the
data that I want to consolidate is not similarly structured across the
sheets.
For example the row that the data starts on varies by sheet. So I am
wondering how can I set the starting cell/row and iterate through the
columns within that row to copy the data to a consolidated worksheet?
In each of the sheets I have a starting row, and how many rows of data
for that particular data.
Thanks,
Eric
I am consolidating data from multiple spreadsheets into one. I have
successfully done this for fixed cells from each of the individual
sheets.
I am having trouble doing this for another set of sheets where the
data that I want to consolidate is not similarly structured across the
sheets.
For example the row that the data starts on varies by sheet. So I am
wondering how can I set the starting cell/row and iterate through the
columns within that row to copy the data to a consolidated worksheet?
In each of the sheets I have a starting row, and how many rows of data
for that particular data.
Thanks,
Eric