Copy Paste based on Specific Criteria

Hi all,

I need help regarding the below problem. We use an excel to track opening and closing stock details month wise in an excel sheet. There would be columns stating the stock type, code, opening stock, closing stock and approved stock count for a particular stock type

We'll enter the opening details only for the starting month of the year (i.E for Jan). For Rest all months the opening stock details should be pulled from the second table only (which would be the closing stock of prior month). We will not enter any other month's opening stock details manually.

The stock type Stock code and approved stock remains same for every month unless if there is any addition of new stock type. The opening details should be pulled from the 2nd table based on the month chosen from the drop down. and closing details would be calculated based on the formula and other data.

Previous month's details in the 2nd table won't change. The closing count remains same as once the month ends we'll close the books. The details in the 1st table keeps changing depending on the month selected from the drop down.

Thank you

The fact that your tables are one beneath the other will create problems dealing with the addition of new stock type because as you add or remove stock type, the location of the second table will keep changing. I have moved the second table to a new sheet to accommodate for this. Click on this link to download a sample file: https://app.box.com/s/rmus4h1x5yrg0uadehd1wwtcxed7exw8
Hopefully, I have interpreted correctly what you want to do. Choose a month from the drop down list in B4.

Hi Mumps1

Thank u for your time and providing me with the solution.

I want to know if the same is possible to assign to a button and do the same operation on the click of button rather than using worksheet change event.

Thanks

Assign this macro to your button.

Please Login or Register  to view this content.

Thanks Mumps1.

Rep Added.

My pleasure.