View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
TheBuckStoppedHere TheBuckStoppedHere is offline
external usenet poster
 
Posts: 2
Default Maintaining integrity while referencing data

I have a spreadsheet which references sequential entries from sheet 2
into a pre-arragned repeating row grouping in sheet 1. I have been asked to
alter
sheet 1 by inserting a new row into grouping. Is there an easy way to
perform this?
(There are thousands of line entries.)

a
b
=Sheet2!C1
a
b
=sheet2!C2

---------------- to ------------------------------

a
b
c
=Sheet2!C1
a
b
c
=sheet2!C2

Thanks in advance,
--
Buck Stop