ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Text from one sheet to another (https://www.excelbanter.com/excel-discussion-misc-queries/73547-text-one-sheet-another.html)

TonyB

Text from one sheet to another
 
I have a workbook set up with several sheets that have repetive information
in different cells of each sheet. Is there any way to autopopulate from the
one cell?

Elkar

Text from one sheet to another
 
Just use the following formula:

=Sheet1!A1

This pulls the contents from cell A1 on worksheet "Sheet1".

You could also type = in a cell, then move to the desired worksheet and
click on the cell you want to reference. Then hit Enter.

HTH,
Elkar


"TonyB" wrote:

I have a workbook set up with several sheets that have repetive information
in different cells of each sheet. Is there any way to autopopulate from the
one cell?



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

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