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

You need to use offset to go another cells down
Sheets("Sheet1).Select
Selection.Offset(Rows,Columns).Select
Selection.Copy
Sheets("Sheet2").Select
Selection.Offset(Rows,Columns).Select
ActiveSheet.Paste
Application.CutCopyMode=False

------------
Raju Singh