Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I automatically transfer data to a 2nd worksheet page?
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. |
#2
|
|||
|
|||
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 On Tue, 15 Mar 2005 11:47:07 -0800, "BarrelRacer" wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I automatically update chart source data links for moved fi | Charts and Charting in Excel | |||
incorporating live data from external source to work book | Excel Discussion (Misc queries) | |||
Transfer data from sheet to sheet | Excel Discussion (Misc queries) | |||
transfer an excel work sheet to Paint | Excel Discussion (Misc queries) | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |