I am doing a Current Store Inventory Where i have items in multiple areas

I have a seperate sheet devoted to each area and the first sheet culminates
the overall stock

When i recieve new stock that is not already in my workbook i have to insert
a new row in each sheet and copy the info and write a new equasion etc...
What i need is a macro that will allow me to add new items in my main
inventory sheet that would update data throughout the rest of the worksheet

for instance I recieve new items and place some in the back store room and
some on my redemption wall (archade) I insert the row in the appropriate
place and i want it to update the rest of the workbook in the same
appropriate place and write an equasion that totals the quantity from each
area. i'm not worried about extra stuff ending up on my printoff because of
the filters i have already in place, but if i move an item i would like to
not have to add it to that sheet before i can fix the numbers (and equasions).

From a data management perspective it would be more efficient and less
problematic if you stored the item just once and used that entry to produce
your reports etc. I think you might like to re-evaluate your approach
before writing macros to duplicate data?

--

Regards,
Nigel




"Franky_D" wrote in message
...
I am doing a Current Store Inventory Where i have items in multiple areas

I have a seperate sheet devoted to each area and the first sheet
culminates
the overall stock

When i recieve new stock that is not already in my workbook i have to
insert
a new row in each sheet and copy the info and write a new equasion etc...
What i need is a macro that will allow me to add new items in my main
inventory sheet that would update data throughout the rest of the
worksheet

for instance I recieve new items and place some in the back store room and
some on my redemption wall (archade) I insert the row in the appropriate
place and i want it to update the rest of the workbook in the same
appropriate place and write an equasion that totals the quantity from each
area. i'm not worried about extra stuff ending up on my printoff because
of
the filters i have already in place, but if i move an item i would like to
not have to add it to that sheet before i can fix the numbers (and
equasions).

Franky D,

Group your sheets. Select the first sheet tab and then the shift key +
click the next one (sheet1 and sheet2). Make your modification on the first
sheet and the second will do the same.

"Franky_D" wrote:

I am doing a Current Store Inventory Where i have items in multiple areas

I have a seperate sheet devoted to each area and the first sheet culminates
the overall stock

When i recieve new stock that is not already in my workbook i have to insert
a new row in each sheet and copy the info and write a new equasion etc...
What i need is a macro that will allow me to add new items in my main
inventory sheet that would update data throughout the rest of the worksheet

for instance I recieve new items and place some in the back store room and
some on my redemption wall (archade) I insert the row in the appropriate
place and i want it to update the rest of the workbook in the same
appropriate place and write an equasion that totals the quantity from each
area. i'm not worried about extra stuff ending up on my printoff because of
the filters i have already in place, but if i move an item i would like to
not have to add it to that sheet before i can fix the numbers (and equasions).