Consolidation of Data from Multiple Sheets

Hi

I am new to the forum so firstly hello and secondly apologies if this is a common request!

I have some code which I have tried to butcher to perform a consolidation, but it doesn't seem to be collecting all data (or deleting some mid process).

I'm fairly new to VBA and although tend to be able to bodge things cant see where this ones going wrong.

What i'm trying to achieve is:

I have multiple sheets in a workbook which are labelled as per days of the month (1st, 2nd, 3rd, 4th, 5th...up to 31st).

Within each sheet are two tables which are fixed in terms of the rows they take up. I am trying to consolidate the data from Rows 39-86.

In column F of each of these are specific text ("TO DO", "RESOLVED", etc).

I would like to take each row which contains (for example) "TO DO" and put these rows into a summary sheet (called "ACCRUALS"). If possible it would be even better if i could use the search box to input the text searched for as per the example code below.

Current Code:

The current code i am using is below, this seems to be working, but deleting some values for some reason:

Please Login or Register  to view this content.

Any help would be much appreciated. Many thanks.

Doesn't sound overly complex. Can lease provide a sample workbook I could test my suggestions on?

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.