Update sheets

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Greetings. Quick question (I think). Sheet 2 receives its data from Sheet1A (Formula below). The formula is relative
so it is autofilled down. The problem is when I insert a row in Sheet1A, I have to manually autofill the formula agai
on Sheet 2. The data on Sheet2 begins on row A4 and the data on Sheet1A begins on row A15.

=IF('1A'!A15=0,"",'1A'!A15
=IF('1A'!A16=0,"",'1A'!A16
etc

Apologies if this question has been posted and answered already. My searching has not yielded results :

Robbyn
 
Oops! Helps if I ask the question :). Is there a way Sheet 2 can automatically update when I insert or delet
a row in Sheet1A?

Robbyn
 
Try this.

I followed you row references, so enter this in A4 on Sheet2 and copy down
as needed:

=IF(INDIRECT("1A!A"&ROW()+11)=0,"",INDIRECT("1A!A"&ROW()+11))
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


Oops! Helps if I ask the question :). Is there a way Sheet 2 can
automatically update when I insert or delete
a row in Sheet1A?

Robbyn
 
Back
Top