How to auto data from one work to another worksheet.

G

Guest

I am trying to auto fill information from one worksheet to another worksheet
(only select item to this worksheet). Please advice any good solution.
 
D

David Biddulph

Click in the destination cell on the destination worksheet. Type an = sign.
Go to the source worksheet, and click in the source cell. This will put the
reference of the source worksheet and cell in the formula bar of the
destination cell after the = sign. (Something like =Sheet1!A5, or ='Sheet
2'!J6 with quote marks if the worksheet name includes spaces.) Tick to
accept.
 

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

data fill question 3
Copyingfunctions from one worksheet to another 1
How can I link a cell in one worksheet to a cell in another works. 3
MATCH - Not Auto Filter 1
How can I turn auto correct on or off for one column only? 3
pasting from one excel workbook to another 1
How do I auto-filter multiple ranges on one worksheet? 3
Database Information 1

Top