ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   MultipleText entry (https://www.excelbanter.com/excel-programming/344244-multipletext-entry.html)

fishface

MultipleText entry
 
I am trying to set up two worksheets in the same workbook, as I enter text in
a specified cell on worksheet 1, I want it to also enter into a different
specified cell on worksheet 2. Is this possible and if so how? thanks.

Fishface

Harald Staff

MultipleText entry
 
Hi

In Sheet2 cell D4 enter this:

=Sheet1!C2

Now sheet2 D4 will always reflect the content of sheet1 C2.

HTH. Best wishes Harald

"fishface" skrev i melding
...
I am trying to set up two worksheets in the same workbook, as I enter text
in
a specified cell on worksheet 1, I want it to also enter into a different
specified cell on worksheet 2. Is this possible and if so how? thanks.

Fishface





All times are GMT +1. The time now is 10:03 PM.

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