linking cells

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

Guest

How can I have link two cells from different woksheets to change together?
 
Biovin said:
How can I have link two cells from
different woksheets to change together?
Click to expand...

In Sheet2,

Put in A1: =IF(Sheet1!A1="","",Sheet1!A1)

Copy across & fill down to cover the
expected used range in Sheet1

Sheet2 will reflect the values within Sheet1

For formats, just do an entire sheet:
Copy > paste special > check "Formats" > OK
(copy from Sheet1, paste in Sheet2)

Formulas can return only values, not formats

---
 
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

autofilter linked in different worksheets 2
Make all values of a 3D named range appear on summary sheet 1
linking cells 1
Reference using worksheet name 4
Worksheet (tab names) in cells 3
SOS-Accounting & Spreadsheets-SOS 1
Cell in new sheet should always refer to defined cell in another s 8
Setting Margins 4

Back
Top