View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Nigel[_2_] Nigel[_2_] is offline
external usenet poster
 
Posts: 735
Default I don't know how to write a macro that would update the workbook

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).