Linking within a workbook

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

Guest

I have a 45 sheet workbook where I want 44 of them to summarize to Sheet 1.
I use "paste special, link" for row #1 of each sheet to transfer to the
summary. However, when I come in the next week and add a row above #1, the
link adjusts to row #2. Is there a way for the summary to always pick up row
1, even though I add a row?
 
Thank you, but it didn't work. When I typed it in, it changed to "text" and
showed in the cell as =INDIRECT("Sheet1!A1")
When I try copying the cell from the data source, the then go to the summary
collecter and use "Paste Special" and click on "Paste Link". What I get is :
='Staff Inspec'!$F$4. But if then in the data source I add a row above row
4 to push the previous information down out of the way, the formula adjusts
to ='Staff Inspec'!$F$5. What I want is for the summary collecter to alway
select row 4, no matter how many rows I add above it. I appreciate your help.
 
I'd check this setting:
Tools|Options|View tab|make sure Formulas isn't checked

If it's not checked
select that cell
format|cells|Number tab
make it General (or anything but text)
and ok your way out.

Now with that cell selected, hit F2, then enter.
 
Ooops, I was wrong - didn't work - the "formula" adjusted to the 5th row
instead of staying constant on the 4th row. Is there a way to turn off the
"recalculation" feature when adding or deleting a row?
 
What formula did you use?

This is what it should look like:

=INDIRECT("'Staff Inspec'!$F$4")
 
It worked! The first time I tried it after your first answer, I must have
entered it wrong. Thank you for your patience!
 
Excel likes to help and may have changed the format to Text--or you could have
formatted the cell as text in error.

But you probably didn't do anything wrong (and got two answers to two different
questions!)
It worked! The first time I tried it after your first answer, I must have
entered it wrong. Thank you for your patience!
Click to expand...
 
Thank you! You answered a question for me some months back. This is a great
forum for questions.
 

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

Similar Threads

Figuring out a lengthy formula. Probably quite simple... 3
Excel lookup across entire workbook 1
Linking Cell based on Date 8
Copy certain rows to new worksheet 1
Wrapping sheets within a workbook 2
transferring data to new multiple spreadsheets 1
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
Remove workbook reference but keep worksheet references 2

Back
Top