When I add a row to my source sheet, it doesn't update my linked .

  • Thread starter Thread starter WorkingGirl4774
  • Start date Start date
W

WorkingGirl4774

I have a main source sheet that I have linked to other sheets (the same info,
only broken down by city). When I add a row to the main page, it doesn't
update the linked pages. It updates the cells that were already there, but
won't insert new rows when I do on the source sheet. I'd appreciate any
help. Thanks!
 
Hi,

Excel never put formula in cell just because. If you want to do this you
can consider 1. Putting formulas in place which are "ready" for new data, 2.
Write VBA code to respond to a change event in the source sheet.

For example if your current linked formulas read

=Sheet1!A1
you could change it to read

=IF(Sheet1!A1="","",Sheet1!A1)

You can copy this type of formula anywhere in the target sheet and it will
be ready for new rows of data and it won't show anything until those source
cells are populated.

If this helps, please click the Yes button

Cheers,
Shane Devenshire
 
Back
Top