Hi all,
I need a help regarding the below problem which i'm facing.
I work for a warehousing company where in we maintain the stock details in Excel. There would be columns stating the stock type, code, opening stock, closing stock and approved stock count for a particular stock type. The opening stock of the current month would be the closing stock of previous month. It would be entered manually in the beginning of every month and this is taking a lot of time.
I'm trying to automate the same through Macros by creating a table in the same sheet and using the drop down to select a month. The closing stock of the current month should go into the respective month depending on the stock type and should be the opening stock for the next month.
I tried a few ways but i couldn't get the desired results.
Can some one help on this.
Please see the attached file for easy understanding of the problem.
Thanks in advance.
Bookmarks