Hi there, i am new to VBA and have been learning recently. need some help with running something for my sch proj.
I need to copy data from all the sheets labelled "monday", "tuesday", to ... "friday" to my main sheet , "Data sheet". Is there a way to copy the data from respective day sheets, based on the day of the week and paste it in the "data sheet"?
My data in my day sheets are from "AB1: AG9" and i would like to copy them and paste them (as values) to the "B1:G9" of my main sheet.
Any help on this is greatly appreciated. THank you.
JB.
Bookmarks