How to auto data from one work to another worksheet.

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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

Auto fill not working 2
Excel Highlighting duplicates 0
Excel Copy cells from one worksheet to another workseet - increment row & do again 0
Auto-fill 3
Basic Question on autocomplete function 2
Countif Formulas 2
How do I auto complete a cell with text from another worksheet? 3
Duplicating/Mirror Data into another worksheet within same workboo 1

Back
Top