Forum Discussion

Copper Contributor

Dec 02, 2020

Don't want cell references to update to another worksheet.

Hi, I have worksheet B that copies cell data from worksheet A. Every time I insert a row in sheet A, sheet B is updated and then the data from the newly inserted row in sheet A doesn't show up in s...

Formulas and Functions

MVP

Dec 02, 2020

can you please attach sample file?

Regards, Faraz Shaikh

Mrmusick
Copper Contributor
Dec 03, 2020
ExcelExciting Thanks for looking into this. I attached the sheet. Maybe another way of looking at it is to insert a row in the 'contact history' sheet whenever I add a new contact in 'person data'.

The problem is that when I add a new person (row) in 'person data' , I need to manually insert a row and update the 'contact history' sheet to include that person. How can I make this happen automatically?

Thanks for your help.
Contact Nov 27.xlsx30 KB
- JMB17
  Bronze Contributor
  Dec 03, 2020
  In contact history, cell A2, try:
  
  =INDEX('Person Data'!$F$2:$F$68,ROWS(A$2:A2))
  
  Then, copy/paste special - formula down your column.
  - Mrmusick
    Copper Contributor
    Dec 03, 2020
    JMB17 Thanks. That works for the cells where data is being directly copied over.
    
    But somehow I would like to insert the row all across the 'contact history' sheet. Is it possible to insert a row on the second sheet when a row is inserted on the first sheet?
    
    Thanks alot.

Resources