Select from this cell. UP to A2.

[Graham Pall]

I have been working on a sheet that is updated daily. The macro starts by copying the previous days info to a different sheet, and then bringing in the current days info.

I am trying to copy a "Comments" column across from the previous day. I usually select the cell with the look up formula, copy, select the cell to the left (as that column is always full), Ctrl + Down, then use Activecell.Offset (0, 1), and then Ctrl + Shift + Up, paste to populate all the empty cells in the column.

Only this time, the CTRL + Shift + Up is stopping at the first cell with an entry, and not going up to the top.

Is there a way of telling it to go from the cell selected in the 'Activecell.Offset (0, 1)' line (which can vary greatly), up to cell A2, or A3 no matter what data is entered or not in the cells inbetween?

Thanks.

[TMS]

Assuming cell A17 is selected:

Please Login or Register  to view this content.

If B17 is selected:

Please Login or Register  to view this content.

Regards, TMS

[Graham Pall]

Thanks for the reply. Not sure how I would incorporate that into the code I already have. Might have helped if I had put that up to start with

Please Login or Register  to view this content.

So it's the xlUp bit that I need to modify, so it goes to A2 instead of stopping at the first cell with data.

[TMS]

Suggest you post a small sample workbook with a description of what you are trying to achieve ... not how you are trying to do it with code, just the end result. That is, this formula in these cells because ...

[TMS]

Or try this:

Please Login or Register  to view this content.

Regards, TMS

[Graham Pall]

Please see file attached. I have deleted out all of the sensitive information. Hope it helps.

[TMS]

Did you see post #5?

[Graham Pall]

Err, no, didn't refresh the page before replying. Will have a look now.