data entry on multiple worksheets
I have a book with one master worksheet and then several other worksheets
with data from the master. Is it possible to have the data I enter or update on the master to automatically populate the correct information into the other worksheets, even though the other worksheets store the data on different rows than the master? |
Hi
you could use cell links such as ='master sheet'!A1 in your target cells -- Regards Frank Kabel Frankfurt, Germany "diosdias" schrieb im Newsbeitrag ... I have a book with one master worksheet and then several other worksheets with data from the master. Is it possible to have the data I enter or update on the master to automatically populate the correct information into the other worksheets, even though the other worksheets store the data on different rows than the master? |
All times are GMT +1. The time now is 02:51 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com