Combine 2 sheets into 1 that will update w/new data
 

I have two worksheets that data is enterd onto twice a month each wprksheet
has a set of columns that summaraizes and performs calculations on the data
enterd. I would like to combine the summarized columns into one master sheet
and have them be updated when data is enterd bi-monthly onto the primary
sheets.

Combine 2 sheets into 1 that will update w/new data
 

I think this will work for you:
http://office.microsoft.com/en-us/ex...548301033.aspx

"Ms. Von" wrote:

I have two worksheets that data is enterd onto twice a month each wprksheet
has a set of columns that summaraizes and performs calculations on the data
enterd. I would like to combine the summarized columns into one master sheet
and have them be updated when data is enterd bi-monthly onto the primary
sheets.

Combine 2 sheets into 1 that will update w/new data
 

Nate, I do not want to combine them to print them i think you mis-read my
question i want to combine the data from two separate worksheets in the same
workbook INTO 1 WORKSHEET -- THAT WILL UPDATE ITSELF -- WHEN NEW DATA IS
ENTERED ONTO EACH OF THE INDIVIDUAL WORKSHEETS!!

"Nate" wrote:

I think this will work for you:
http://office.microsoft.com/en-us/ex...548301033.aspx

"Ms. Von" wrote:

I have two worksheets that data is enterd onto twice a month each wprksheet
has a set of columns that summaraizes and performs calculations on the data
enterd. I would like to combine the summarized columns into one master sheet
and have them be updated when data is enterd bi-monthly onto the primary
sheets.