Copying Cells from one worksheet to another automaticly

L

loc

I have a document with 5 worksheets. When I update say worksheet one in a
certain cell, I want it to update worksheet 5 in certain cell. Can this be
done?
 
G

Gord Dibben

In any cell on Sheet5 enter =IF(Sheet1!A1="","",Sheet1!A1)

When you change the data in Sheet1!A1, the formula on Sheet5 will return that
value.


Gord Dibben MS Excel MVP
 

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

Embed the same Excel multiple times 0
VBA Coding Help for Beginner 0
Consolidation Table from Different Excel Tabs with Different Format 1
Using VBA to copy data into another worksheet ??? 2
Pasting a cell into bookmarked table from excel vba 1
Duplicating a cell from one worksheet to another worksheet 1
Turning off automatic calculation 0
Drop down list control value in vba 2

Top