lets say you have 1 column (A) of data and it goes to row 5, You insert a new Column A and shift everything to the right. So now you have a blank Column A and a Column B that has 5 rows of data.

How do I find the cell in Column A that would match the last row of data in Column B which would be 5, So that i can fill Column A with data

I was thinking i can find the last cell of data in Column B. could i than move the cell selector over to the left by 1 and fill up? And if so how do i do that?

Thanks in advance. I hope it is clear

Oh i'm using Excel Xp

Thanks
Keith