automatic save cell to different cell

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

Guest

I have two worksheet in my excel file. I would like to save data to specific
cell in worksheet 2 when I enter data in worksheet 1. Could anyone help?
 
james

In the cell on sheet2 enter this formula =sheet1!A1

Note the exclamation mark(!) must be entered.

When you change sheet1A1 then sheet2 cell will change also.

This process is called "linking".

For more, see Help on "linking".

Gord Dibben Excel MVP
 
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

Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Excel Highlighting duplicates 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Password Protect Specific Range Of Cells 6
Excel opening cell 2
"save as" 0
autocalculate doesn't work even with formula . 1
Excel VBA 1

Back
Top