VBA copy/insert with closed workbook

[tf2722]

I have the attached #3 Inventory Sheet designed to track inventory. I've coded the add inventory button to copy relevant information and add it to the section below but need to now copy that row and insert into a master inventory file where multiple people are dumping data from identical sheets to this one. Thoughts?

[Doc.AElstein]

Hi,
. You have explained quite well what you want, and I think i get the general idea. I do not think a code would be too difficult to do for you..
. But I need some test data to work with and It would be much easier if you give a clear picture ( Not IMAGES ) of what you have before and after with reduced test data.


. So simply provide clear before and after ... ( For example a "Before" and "After" sheet in an Excel File )

To summarise.

. The Before or Befores, should look just as it / they does before running of any macro.
.
. The After or Afters, should be hand filled by you so that it / they looks exactly as you want it to After running of any macro, based on the actual sample data in the Before / or Befores
. Make sure there is just enough data to demonstrate your need. Remember to desensitize the data if necessary, but use the typical Format type and choose your data carefully so that it can be used to test all possible scenarios.
...

Alan