I am very new to vba and I'm trying to write a marco to sort out data. However, when it finishes with calculating the previous, it kept on showing me the runtime error. Also, I am sure there is a way to loop this instead of me just simply copy and past the command.
What it does is to change range A2 to S7, S8, S9... then calculate the sheet and copy and paste the data into a different sheet renamed after what is specified in cell A2. This process then go back to the lookup sheet and repeat the same for s8 etc...
Can someone give me some advices please?? Thanks!!
See below for the code:
Bookmarks