Evening all,
I am hoping someone can help please. I have 12 workbooks (one for each month of a year), ie Jan09, Feb09 etc. Within each workbook I have 10 tabs (one for each datalogger), ie dat1, dat2, dat3. In these tabs/worksheets contains one month of data (approximately 100 rows of data recordings).
I have created another workbook which just has the 10 tabs/worksheets (named dat1, dat2,etc) and what I wish to do is run a macro from this 'active workbook' which will open each of the Jan09, Feb09 workbooks and copy the data from each tab in turn to the similarly named tab in the active book, adding it to the next free row. Therfore I'll end up with the single active book which has 10 tabs (dat1, dat2, etc) with the entire years data in it.
hope that makes sense. I would much appreciate the help as I've only made really basic macros before now.
thanks in advance
david
I am hoping someone can help please. I have 12 workbooks (one for each month of a year), ie Jan09, Feb09 etc. Within each workbook I have 10 tabs (one for each datalogger), ie dat1, dat2, dat3. In these tabs/worksheets contains one month of data (approximately 100 rows of data recordings).
I have created another workbook which just has the 10 tabs/worksheets (named dat1, dat2,etc) and what I wish to do is run a macro from this 'active workbook' which will open each of the Jan09, Feb09 workbooks and copy the data from each tab in turn to the similarly named tab in the active book, adding it to the next free row. Therfore I'll end up with the single active book which has 10 tabs (dat1, dat2, etc) with the entire years data in it.
hope that makes sense. I would much appreciate the help as I've only made really basic macros before now.
thanks in advance
david