View Single Post
  #1   Report Post  
Ruth J
 
Posts: n/a
Default Global way to set absolute links...

Hi,
I am working in one workbook:

Sheet1 is the Master of approx 50 columns by 1400 rows. That data is
refreshed daily from a .txt file. The sheet normally increases in the number
of rows by anywhere from 1 to 100+ rows per day. The columns do not change.

Sheet2 is approx 15 columns linked from the Master plus three additional
columns containing formulas.

Sheet3 is a copy & special paste of 'values and numbers format' of Sheet2.
(this is the page that is used for our data manipulating - sorting, filters,
etc.)

Problem: Sheet2 links sometimes change due to the way the Master is
refreshed. I need to make the links absolute in all 1400 rows. Is there an
easy way to do this other than cell by cell (shiver...smile)?

This is my first time working with links - any help is appreciated!

Thanks,
Ruth J