Combining data from multiple worksheets and separate spreadsheets

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

Guest

How do I take data from one worksheet and perform formulas with data on
another worksheet? How do I do this with separate spreadsheets? Mahalo.
Karen
 
In the resulting worksheet insert an equal sign and select another
worksheet, it will provide a formula similar to:
=Sheet2!D4
 

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

How to use multiple command button to copy user form data to multiple worksheet 0
how can I combine multiple worksheets into a single workbook? 5
How do I combine data (not consolidate) from separate tabs to one? 2
Linking multiple worksheets in one workbook 2
Merge data from different worksheets 3
Combining data from multiple worksheets into one 4
multiple worksheets 1
How do I call VBA subs from different spreadsheet from code behind form? 1

Back
Top