The attached spreadsheet is an inventory list. Each tab is a different category of parts and supplies and the first tab, called "All Parts Catalog Only" is the main page. I am having a problem with people adding new parts and pictures to the individual tabs but not adding them to the "All Parts Catalog Only" tab.
I know this can be done but I have no clue how to do it. I would like a macro or code that can be run so when someone adds a part to any of the individual tabs, Excel takes all the parts on each individual tab and moves them to one single sheet, my "All Parts Catalog Only" tab so everything on each tab is listed there on one tab.
How do I do this?
https://app.box.com/s/keu72r0ytkenuzw109m9ju1xgmpl39lo
I know this can be done but I have no clue how to do it. I would like a macro or code that can be run so when someone adds a part to any of the individual tabs, Excel takes all the parts on each individual tab and moves them to one single sheet, my "All Parts Catalog Only" tab so everything on each tab is listed there on one tab.
How do I do this?
https://app.box.com/s/keu72r0ytkenuzw109m9ju1xgmpl39lo
