Can someone please help with this senario?
I have data in columns A, B and C. First row is a header.
The data in A and B does vary from week to week. But the two columns are always the same range.
The data in C is only takes one cell which is a date in C2.
I would like to copy C2 and paste it starting at C3 and end at the last row that A and B data ends. For example the last row for A and B data is A500 and B500 then copy C2 and paste from C3 to C500.
Remember A and B can be 500 rows one week or can be 557 the next week as this range varies.
I cannot use a fixed range of which I have already figure out how to accomplish.
I do need a solution to paste to a number of rows dependent on the range of A and B.
Thanks in advanced for your assistance
I have data in columns A, B and C. First row is a header.
The data in A and B does vary from week to week. But the two columns are always the same range.
The data in C is only takes one cell which is a date in C2.
I would like to copy C2 and paste it starting at C3 and end at the last row that A and B data ends. For example the last row for A and B data is A500 and B500 then copy C2 and paste from C3 to C500.
Remember A and B can be 500 rows one week or can be 557 the next week as this range varies.
I cannot use a fixed range of which I have already figure out how to accomplish.
I do need a solution to paste to a number of rows dependent on the range of A and B.
Thanks in advanced for your assistance