combining tabs in one master tab

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

Guest

How can I combine two tabs in one master tab. I need to combine two columns?
 
I'm assuming you mean you have a column on sheet1 and a column on sheet2 that
you want to total on sheet3. If that's the case to add cell A2 from Sheet1
and A2 from Sheet2 enter the following formula on Sheet3:
=Sheet1!A2+Sheet2!A2
Substituting proper sheet names, of course.
Good luck!
 
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

Macro: finding a cell on one worksheet and copying to another worksheet 0
How many rows are available from a tab in Excel 2003? 1
Formula's in linking spreadsheets 1
VB Solution for a INDEX Array Problem 1
Joining only certain columns to a spreadsheet. 1
Tab text in cell 2
Insert row in Master worksheet that auto inserts in other workshee 2
How do I combine data (not consolidate) from separate tabs to one? 2

Back
Top