I'm currently using excel 2003 and am trying to figure out how to update
multiple worksheets within the same workbook by just inputting data into one
sheet. Ex: I have four sheets in the workbook. One is an overall tracking
sheet and the other three are tracking by specific area. I would like to fill
out the main sheet and then have that information automatically updated inot
one of the other three sheets based on certain criteria. Please give any
input.

Can you provide more information? Are you using formulas in the other
worksheets in order to populate the data? Are you summing the data,
counting, etc?


"jrrock26" wrote:

I'm currently using excel 2003 and am trying to figure out how to update
multiple worksheets within the same workbook by just inputting data into one
sheet. Ex: I have four sheets in the workbook. One is an overall tracking
sheet and the other three are tracking by specific area. I would like to fill
out the main sheet and then have that information automatically updated inot
one of the other three sheets based on certain criteria. Please give any
input.

Actually it doesn't involve any numerical calculations. I have a report out
sheet for tracking different work areas in 1 sheet. Then I have seperate work
sheets to break it down to individual work areas. I record all data into the
main work sheet and then copy and paste entire lines into other work sheets
based on the department that line pertains to. So what i would like to do is
say work area a,b, and c have information stored on 1 sheet together. I want
to keep track of that info together, but at the same time I want to copy and
paste all criteria for "a" to the sheet for area "a" and then the same for b
and c.

"Nadine" wrote:

Can you provide more information? Are you using formulas in the other
worksheets in order to populate the data? Are you summing the data,
counting, etc?


"jrrock26" wrote:

I'm currently using excel 2003 and am trying to figure out how to update
multiple worksheets within the same workbook by just inputting data into one
sheet. Ex: I have four sheets in the workbook. One is an overall tracking
sheet and the other three are tracking by specific area. I would like to fill
out the main sheet and then have that information automatically updated inot
one of the other three sheets based on certain criteria. Please give any
input.