Text from one sheet to another

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel, assign cells in multiple worksheets from one sheet 1
Look up & auto populate between sheets 7
Enter date, then pull data from another sheet 2
stop a cell from repeating its value continually across the page 1
Excel Move or Copy Stopped Working? 0
Reference to sheet name in another workbook 3
Formula Audit mode active in one column only; cannot kill. 2
Need to merge worksheets - Excel 2003 0

Back
Top