Home |
Search |
Today's Posts |
#1
|
|||
|
|||
using data from one worksheet into another
I currently have a excell file that has multiple worksheets. I would like to
add a worksheet that would allow for data entry. Once the data is entered into this first page, i would like it to automatically fill in the same information into the other worksheets. ie customers name would be entered onto the first worksheet and then excell would put the customers name on all the other sheets. how can i migrate this data from sheet to sheet? |
#2
|
|||
|
|||
try this
using shift or control key click all the worksheet tabs. all tabs will be in whilte(i.e. all are active sheets) now if you type something on A1 of first sheet the same will be entered in all the sheets once your action is over click any sheet, this operation of highlighting all sheets will be removed. try one or two experiments mower man <mower wrote in message ... I currently have a excell file that has multiple worksheets. I would like to add a worksheet that would allow for data entry. Once the data is entered into this first page, i would like it to automatically fill in the same information into the other worksheets. ie customers name would be entered onto the first worksheet and then excell would put the customers name on all the other sheets. how can i migrate this data from sheet to sheet? |
#3
|
|||
|
|||
Thank You for your response. This works nicely. However, it brings up two
other questions. 1) Can i make this happen automatically? 2) what if i want the data to be put into diferent cells? "R.VENKATARAMAN" wrote: try this using shift or control key click all the worksheet tabs. all tabs will be in whilte(i.e. all are active sheets) now if you type something on A1 of first sheet the same will be entered in all the sheets once your action is over click any sheet, this operation of highlighting all sheets will be removed. try one or two experiments mower man <mower wrote in message ... I currently have a excell file that has multiple worksheets. I would like to add a worksheet that would allow for data entry. Once the data is entered into this first page, i would like it to automatically fill in the same information into the other worksheets. ie customers name would be entered onto the first worksheet and then excell would put the customers name on all the other sheets. how can i migrate this data from sheet to sheet? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
Linking multiple data into one worksheet. | Excel Worksheet Functions | |||
Macro to search for and display data in another worksheet | Excel Worksheet Functions | |||
How to..use worksheet form and save data to an Excel list | Excel Discussion (Misc queries) | |||
URGENT Please... new worksheet with copied formats but no data. | Excel Worksheet Functions |