kcallahan1
New Member
- Joined
- Dec 7, 2016
- Messages
- 1
Hello All,
I am looking to create a macro which will allow me to save a product order into a folder and then the separate summary workbook will automatically pull in that orders information.
I am fairly inexperienced with using Macros but here is my thought process of what I would like to be able to do. I can create the master summary page which will include every single order. I would need the date pulled into the next column to the right every time a new workbook is saved. I would then need a vlookup by each UPC. Not every order contains every item and the items not being ordered are simply excluded and that row is deleted so simply returning the column will not work.
I am looking for a way to receive the new order, save it in a certain place, and then go to my master workbook and hit refresh or run macro. This would be much better than creating new v lookups every time I get an order. The purpose of this will be to create charts, find trends and calculate average order sizes for each product over specific time periods to help with forecasting.
Any help would be greatly appreciated!
I am looking to create a macro which will allow me to save a product order into a folder and then the separate summary workbook will automatically pull in that orders information.
I am fairly inexperienced with using Macros but here is my thought process of what I would like to be able to do. I can create the master summary page which will include every single order. I would need the date pulled into the next column to the right every time a new workbook is saved. I would then need a vlookup by each UPC. Not every order contains every item and the items not being ordered are simply excluded and that row is deleted so simply returning the column will not work.
I am looking for a way to receive the new order, save it in a certain place, and then go to my master workbook and hit refresh or run macro. This would be much better than creating new v lookups every time I get an order. The purpose of this will be to create charts, find trends and calculate average order sizes for each product over specific time periods to help with forecasting.
Any help would be greatly appreciated!