Hi,
I dont have any programming skills or how to use macros, so here I am.
I have around 300 excel files, each of while have around 30 sheets. The only relevant sheet for me is a sheet called "Summary" in each file.
1. So I have to manually imported all the "Summary" sheets in to a new sheet and now the sheets are called "Summary", "Summary (2)".. and so on.. here is where I need help with the macro
2. In cell B3 I have the dates for each of the sheets, which are in text format. So I basically want the macro to make a cell B2 in each of the sheet with the formula B2=LEFT(B3,2)&"."&MID(B3,4,2)&"."&RIGHT(B3,2), so that I have the date in cell B2 in MM.DD.YY format
3. Then I want the sheets to be renamed to the value in the cell B2, i.e the date in MM.DD.YY format
Can someone please help me with this ? I basically need a macro for point 2. and point 3.
Also, is there a way to copy all the 300 "Summary" sheets from the to the new excel sheet using a macro if there saved in the same folder.
Thanks for you help.. This is an office project so I cant install any third party extensions on my office laptop unfortunately.
Bookmarks