how can i automatically copy the information in one cell on a she.

D

Dan

i have work on 3 different sheets in the same workbook, the first page
contains information that I would like to automatically fall into certain
cells on the 2 & 3 sheet, how can this be done.
 
L

LanceB

You can reference information on another page. As an example the formula

=Sheet1!A1

is on sheet2 and references the value in sheet1 A1

Lance
 

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

Visio: copy text of a master shape to User-define Cells (Variable) 0
Request Form - Alert Team Member 0
Mail Merge Directory Conditional Page Break 0
Combining two sheets of data into one and sorting by value - using macros 5
Page numbering with Merged Document and IF statements 1
copy specific cells from sheets if the information is correct 3
Images are pixelated when saving to PDF 0
Need Help with a VBA subroutine 0

Top