![]() |
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! |
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! |
All times are GMT +1. The time now is 01:36 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com