Combining spreadsheets

**homer** · 12-20-2006, 02:57 PM

Hi, I have 2 spreadsheets I want to combine into a 3rd master spreadsheet (same catagories and functions). But I wanted it to be configured so that if I add any information to the first 2 they will automatically be entered into the master. I'd hightly prefer not to use macros as well. thanks

**swatsp0p** · 12-20-2006, 05:27 PM

Your information is sparse, so a sparse reply:

use the formula "=Sheet1!A1" or "=Sheet2!B1" Modify the cell references as needed to bring data from sheets 1 and 2 into a 3rd sheet.

Good Luck!

Bruce

**homer** · 12-21-2006, 12:22 PM

I'll try to add more info. I didnt want to make my question too confusing

say in spreadsheet 1 I have
stuff number
x 1
y 2
z 3

spreadsheet 2 I have
stuff number
a 7
b 8
c 9

spreadsheet 3 I want

stuff number
x 1
y 2
z 3
a 7
b 8
c 9

and I also want it so that if I add to spreadsheet 1
stuff number
v 5

I want that tacked onto spreadsheet 3 automatically

thanks

**swatsp0p** · 12-22-2006, 04:46 PM

Without using VB code in a WorkbookChange event macro, what you ask is pretty difficult, as the formulas I listed will only look for data added to specified cells on a single sheet.

You could use separate columns for Sheet 1 data and other columns for Sheet 2 data.

Maybe others have a different <non-macro> approach to this task.

Good Luck.

**starguy** · 12-23-2006, 06:11 AM

Originally Posted by homer

I'll try to add more info. I didnt want to make my question too confusing

say in spreadsheet 1 I have
stuff number
x 1
y 2
z 3

spreadsheet 2 I have
stuff number
a 7
b 8
c 9

spreadsheet 3 I want

stuff number
x 1
y 2
z 3
a 7
b 8
c 9

and I also want it so that if I add to spreadsheet 1
stuff number
v 5

I want that tacked onto spreadsheet 3 automatically

thanks

Hi

it would be better if you attach a sample workbook.

Regards.