ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   data entry on multiple worksheets (https://www.excelbanter.com/excel-discussion-misc-queries/1420-data-entry-multiple-worksheets.html)

diosdias

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?

Frank Kabel

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