I have a data sheet with Tue, Fri, Sat, Sun.
I want to copy rows Labeled Tues. into another worksheet using a Macro
I want to know is a way I can go to one cell and copy
Then go the next cell four cells down and copy. sheet
I can make the macro work by doing that but is there away to automate going four cells down
What my macro does now is it goes from a worksheet labeled Tues and goes to a worksheet name data. I use the = sign to copy a cell from the data worksheet.
I then use that cell to scoll the rest of that information in my Tues Work sheet. I then repeat the process but only four rows down. Is there a way to automate going 4 cells down