copy from many sheets to one sheet

[garyfahy]

please help! I have a spreadsheet with data for 15 minute intervals over one day, and each day is in a separate sheet. I want to copy from these daily sheets to one sheet so that all the information is in a consecutive format. Can someone help with this.

[arlu1201]

Do you want the sheetname to appear along side each row that has been copied, so you know from which sheet the data has come?

In which sheet should the data be consolidated?

After running the macro once, what if you want to run the macro again? Should the data in the consolidated sheet be cleared and re-input?

[garyfahy]

thanks for the quick reply.

Yes, if i could have the sheet name that woudl be helpful. but not esssential. I just want each days data in one column so that I can copy it all and paste it in another sheet to make charts. it doesnt matter where or shich sheet this consolidated data goes to, as long as I can copy it.
No, I will only run it once per workbook. I am just trying to extract the data.

thank you so much

[arlu1201]

So which columns do you want copied?

[garyfahy]

i need both column A and B copied. Ideally i need continuous data, i.e. the time in column A with the data in Column B and the date in another column. i just want one sheet with the data in, not each day on a separate sheet. I hope this make sense. thanks again for helping me

[arlu1201]

Try this code

Please Login or Register  to view this content.

Copy the Excel VBA code
Select the workbook in which you want to store the Excel VBA code
Hold the Alt key, and press the F11 key, to open the Visual Basic Editor
Choose Insert | Module
Where the cursor is flashing, choose Edit | Paste

To run the Excel VBA code:
Choose View | Macros
Select a macro in the list, and click the Run button.

[garyfahy]

Hi Arlette - WOW! that works perfectly. Thank you very much. I really appreciate the help. i was about to pull my hair out doing this all manually.