How do I automatically transfer data to a 2nd worksheet page?

B

BarrelRacer

I am needing to learn how to do the following in excel:

When data is entered into an excel worksheet, I need some of that data to
automatically go into another worksheet.
 
G

Gord Dibben

Define "some".

Give us a sample(not a file) of your data and what you want to go to the other
sheet.

You can always "link" cells from one sheet to another.

i.e. on Sheet2 in A1 enter =Sheet1!A1 to get value from Sheet1 A1.


Gord Dibben 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
Turning off automatic calculation 0
Syncing between source worksheet and dependent worksheets 0
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
VBA to do a mailmerge from a Specific Excel worksheet 0
Changing margins on 2nd page of letterhead template 4
Paste to excel from word - auto format problem 1
looking for a function that will populate opening a worksheet or t 2

Top