Worksheet referencing

K

Katie

Hi!
I have a problem with referencing cells from one
worksheet to another. I have a complicated spreadsheet,
which has about 12 worksheets in it. 11 are referenced
to the single master one (the master price list). What
has somehow happened (maybe I did a weird sort or
something on the master?) is that only the bottom 5
percent of my master list is referncing back to the other
worksheets correctly. The 95 percent above it are ONE
ROW OFF. Meaning that if the item on the master sheet is
say cell I40, the cell the other worksheet is referencing
is I41. When I originally did all this is worked
splendidly and then something went awry. I can re-
reference everything but don't feel like taking the 6
hours or so to do it.
This may not be as clear as I intended- could someone
with more knowledge than me contact me PLEASE. Please
also use my email address above, as just navigating my
way through the help website was challenging enough and
may never return to this message! : )
Thnak you in advance-
Katie
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top