Copy paste values to another workbook based on multiple cell values

[Bazinga]

Hi All,

I have some basic understanding of VBA, but I cannot find a proper solution for the following:

I have a dataset with a lot of entries, which is still growing. In order to have a better overview of several specific items, I would like to export (copy paste values) the information of each row to another sheet when it matches multiple cell values. The cell values are the date, a category and a specification.

In the attachment I included a sample workbook.

Hope you guys can help me with this problem.

Thanks in advance!

[Bazinga]

anyone?

[jaslake]

Hi Bazinga

Try this Code in the attached. There are two Buttons, "1 Create Lists" and "2 Extract Stuff".

"1 Create Lists" needs clicked initially. It will then need be clicked any time you add Data to the Worksheet.

"2 Extract Stuff" does all of this

I would like to export (copy paste values) the information of each row to another sheet when it matches multiple cell values. The cell values are the date, a category and a specification.

Please Login or Register  to view this content.

[Bazinga]

Thanks! Works great

[jaslake]

You're welcome...glad I could help. Thanks for the Rep.