Referencing A Cell in Another Worksheet Within the Same Workbook

  • Thread starter Thread starter chickalina
  • Start date Start date
C

chickalina

I have a workbook with contact names, numbers, and a combination of both. I
have a landscape version and a portrait version. I want to only update one
and the other automatically updates. I used the "=" sign. When I first
created the workbook, everything worked fine. I've since made some changes by
deleting and adding. Now some cells don't work. I've tried using the "="
sign again, changing the format to General and Number, but some cells refuse
to work.
Please help....
Thanks so much.
 
Hi,

Clear the formulas on the second sheet.

Select all the data on the first sheet and choose Copy, switch to the other
worksheet and choose Edit, Paste Special, Paste Link.
 
You must log in or register to reply here.

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

Referending Another Worksheet in the Same Workbook 3
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
How to create absolute link to cell in another workbook (Excel 2003) 1
copying a style from one worksheet to another in the same workbook 1
Excel lookup across entire workbook 1
Copy a worksheet to a new workbook 6
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Referencing cells 4

Back
Top