ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   moving data (https://www.excelbanter.com/excel-discussion-misc-queries/63361-moving-data.html)

warrior26

moving data
 
How do I have data in one worksheet show up in another worksheet?

Stephen

moving data
 
"warrior26" wrote in message
...
How do I have data in one worksheet show up in another worksheet?


Suppose you have data in A1 of Sheet1. On the other worksheet where you want
this to show, put the formula
=Sheet1!A1



warrior26

moving data
 


"Stephen" wrote:

"warrior26" wrote in message
...
How do I have data in one worksheet show up in another worksheet?


Suppose you have data in A1 of Sheet1. On the other worksheet where you want
this to show, put the formula
=Sheet1!A1

Thank you Steve this solved my problem



All times are GMT +1. The time now is 05:17 AM.

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