ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do I replicate information from one worksheet to another? (https://www.excelbanter.com/excel-discussion-misc-queries/54076-how-do-i-replicate-information-one-worksheet-another.html)

Jeff

How do I replicate information from one worksheet to another?
 
How do I replicate information that I entered on cell A2 in worksheet 1 to be
entered automatically on cell A2 in worksheet 2 and worksheet 3?

Otto Moehrbach

How do I replicate information from one worksheet to another?
 
If you want the same entry in the same cells of other sheets, just group the
sheets before you enter the data. To do this, first select Worksheet 1,
then hold down the Ctrl key and select the other sheets. HTH Otto
"Jeff" wrote in message
...
How do I replicate information that I entered on cell A2 in worksheet 1 to
be
entered automatically on cell A2 in worksheet 2 and worksheet 3?




Jeff

How do I replicate information from one worksheet to another?
 
Thanks Otto

I tried that but how do I keep the worksheets grouped if I later want to
edit a cell(s) on worksheet 1 - it keeps reverting back to Ungrouped sheets.

Thanks again
Jeff


All times are GMT +1. The time now is 04:42 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com