Hi I'm new to VBA and I'm having trouble with the code I'm attempting to report the change made to each part of inventory within excel.
The three things I'd like this macro to perform is
1. Report the current date in the Sheet "Orders" in Column "B" when a cell in column "E" of sheet "Current inventory" is changed.
2. Report the actual change that was made to the cell in column E. (So if we've already ordered 5 units of a part and then we order 3 more I'd like the 3 to be reported with the date that it is changed)
3. Report the name of the part that was ordered from sheet "current inventory" -Column "A" to sheet "Orders" column "C".
Here's the code that I'm attempted to give you an idea of where I was headed (This could be drastically off since I don't have a lot of experience with VBA which is why I'm here!)
Thanks a lot for all of your help! I've attached a sample excel file with the appropriate data needed to complete the macro (ignore columns B:D on the first sheet since they are irrelevant). Let me know if you need any more information.Please Login or Register to view this content.
Bookmarks