I am trying to copy a range form an excel worksheet to another worksheet (same workbook). Currently I have a worksheet with a date in each column and data underneath them.
I search for the date, offset the row down one so the active cell is the first cell of data. What I wish to do now is have code that can select down several cells, probably a fixed number eg. 6 cells down, and copy them.
I have tried to record a macro in excel but it sheds no light on the issue.
Any ideas/code would be helpful.
Thanks!