Seamus2626
asked on
Code to delete rows, add date and loop
Hi, i have attached a ss where i need some code to do the following with the three tabs highlighted green
(1) delete the first 3/4 rows so my headings are on the row 1
(2) Add a column named "Date" in Col AO and put in the current month in format mmm-yy
Loop through the three tabs highlightyed green doing the same
Thanks
LoopingSheetsCode.xlsx
(1) delete the first 3/4 rows so my headings are on the row 1
(2) Add a column named "Date" in Col AO and put in the current month in format mmm-yy
Loop through the three tabs highlightyed green doing the same
Thanks
LoopingSheetsCode.xlsx
ASKER
Rgonzo, that looks great but i must note that i only coloured the sheets green, going forward they would have to referred to explicitly by their name!
Thanks
Thanks
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Hey Rgonzo,
The code is jumping straigh to Case Else?
Is that running fine for you?
Thanks
The code is jumping straigh to Case Else?
Is that running fine for you?
Thanks
Running fine by me
Let's try
on your example I've inserted the code
Regards
Let's try
on your example I've inserted the code
Regards
ASKER
Thanks!
pls try
Open in new window
Regards