how can create a formula to add data from 1 worksheet to another?

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Linnie
You can use VLOOKUP, if it is based on info on the destination sheet. Would
need more info to help you there.

You can also reference the cell in the source sheet, by inserting a formula
in the destination cell. Say you want to put the data in Sheet1, cell A3,
and you want to read the data from Sheet2, Cell F8, then in Sheet1, cell A3,
enter the following formula: =Sheet2!F8.

HTH
 
This helps a lot thanks, but what if you want to reference information from
another excel file. Is that possible?
 
You must log in or register to reply here.

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

VBA - retrieve data on last create named range from previous inserted named range 0
Excel Moving data to sheet2 from sheet1 0
Copy data from once worksheet to another using formula 2
Fill Data across multiple Worksheets - Formulas 1
Formula from consecutive rows to alternate rows? 2
Data table with inputs from a differente worksheet 1
Refreshing formulas automatically 3
Copying template from one worksheet to another 2

Back
Top