Updating links between 2 sheets in the same workbook

  • Thread starter Thread starter alewine
  • Start date Start date
A

alewine

I have a workbook where in Sheet 1 column A is a list of names and in
Column B is their address. In sheet 2 Column A is their name and in
Column B the amount of their donation. I have tried copying column A
from sheet 1 and pasting the link in sheet 2 for the names. My
problem is I can't figure out how to make Column A in sheet 2 update
automatically if I make an addition or deletion of a row in sheet 1.
The first question that pops in my head (and others that I've talked
to about this) is why to do it this way and not add another column in
Sheet 1. I don't have a good answer other than the boss wants it this
way. Thanks for any help you may provide.

Mark
 
Tim, Thanks very much. I new it had to be something simple that I was
missing. You were right =sheet1 !A1 didn't work because that is what
I had been trying. Again thanks vey much.

Mark
 
Back
Top