help with copy sheets of data

[CC_mfc]

Hi,

I'm looking for some help with a 'growing' excel workbook.

What happens is, everyday i run a report and ad a new sheet to a monthly workbook. I manually rename each sheet in the following format, dd.mm.yy.

This means that i have all the data for the month in one workbook but on variuos sheets.

Is there a way I can have the information from the daily sheets automatically added to a monthly sheet within the same workbook, but underneath their own date heading (ie from the title of the sheet)? the problem I am having is I don't know where to start with this. I think I might have to use macros but i'm not sure.

Each daily sheet is copied into the workbook from my downloaded sheet, however, there is no guarantee of how many rows would be in this sheet but the amount of columns would be the same.

Also, is there a way that I can save a format to be applied to each sheet once it has been added and before the information has been copied, ie for each daily sheet i need to increase the column width of some columns, sort by total cost and put a 'freeze pane' in. (the freeze pane option is not totally necassary, i could add that in myseld, but formatting the sheets everyday is a nightmare, especially when there are more than one type of report I do this for so the copying and pasting of information is becoming a nightmare too.

I hope I have explained this ok.

thanks,

CC

[VBA Noob]

Hi,

See if this helps

http://www.rondebruin.nl/summary.htm

VBA Noob

[CC_mfc]

Thanks for the reply, but i'm a bit stuck as to where to start with this. where do i copy and paste the macro into and will it work with each new sheet of data i add daily?

thanks for your patience i am quite new to this.

CC

[VBA Noob]

Hi,

Link below shows how to get started.

It won't update automatically. You would run it as and when you want and it deletes the old sheet for you

VBA Noob