Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Auto FILLING/UPDATE
I am building a spread sheet where the first sheet has thousands of names and
other details. The names column needs to be automatically fills (along with other details) on other tabs on the same spreadsheets. how can I do this? Do I use a macro? Or a simple formula? So i want the second tab on the sp/sheet to mirror some of the data put in on the first tab on the same sheet. I want to do this to save time for data input... Please help! |
#2
|
|||
|
|||
Auto FILLING/UPDATE
by second tab I think you mean another spreadsheet in the same workbook. If
for example you want the contents of cell a1 in sheet1 to also show in cell a1 in sheet2 use this formula in cell a1 of sheet2 =sheet1!a1 "Sonnnn" wrote: I am building a spread sheet where the first sheet has thousands of names and other details. The names column needs to be automatically fills (along with other details) on other tabs on the same spreadsheets. how can I do this? Do I use a macro? Or a simple formula? So i want the second tab on the sp/sheet to mirror some of the data put in on the first tab on the same sheet. I want to do this to save time for data input... Please help! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Averaging Values in Auto Filter | Excel Worksheet Functions | |||
How can I turn auto correct on or off for one column only? | Excel Worksheet Functions | |||
Chart Axis Scale Auto Values | Charts and Charting in Excel | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions | |||
Why can't my macro use Auto Filter when I told the Sheet Protecti. | Excel Worksheet Functions |