Collect matching data from all sheets.

Dear folks,

I urgently need to get this Excel file going as I have burned almost a week with no luck.. Please help.

I have attached the Excel 2003 file - "Customer Data" for your viewing and assistance.

Basically, what I need is a VBA code that would copy a row of data if column "J" value = "TRUE".

All 37 Sheets that has the value "TRUE" shoud be copied into sheet "DUE".

Preferably, a single button operation that runs the code which resides in sheet "DUE" will be of great help.

To sum up I have got a total of 38 sheets in this excel file of which the code should look for the value "TRUE" in all 37 sheets and furnish final results in sheet named "DUE" with single button operation.

Please help..

Welcome to the forum, Dingobat. Be sure to read through the Forum Rules so you can use and follow them effectively. They benefit you (and the rest of us) greatly so they are enforced.

You will need to EDIT the post above, GO ADVANCED and correct your title. It should appropriately depict the topic, like a Google Search, and shouldn't refer to yourself (or us) directly. Maybe: "Collect matching data from all sheets"

I've got a quick little macro ready that will do what you want automatically. I'll post the macro as soon as you correct the thread title in the post above. Thanks.

Here it is. It's an automatic macro residing in the DUE sheet module itself. Each time you bring that sheet onscreen it will collect all the data from all the other sheets automatically. It will only collect data from sheets that have a column called "DUE" like on sheet "0" currently.

Please Login or Register  to view this content.