Combine data from multiple sheets with conditions

Originally Posted by stnkynts

Attachment 202592

The reason no one has replied is probably due to the amount of work that is required to solve your problem. I have attached an updated copy of your workbook. Rather than trying to figure out what you had going on with the command buttons in your userform I just created a new button called test. I think I have it doing what you want it to. If it does then you can add it to where you need it.

I just realised, if there is a way to modify your code to delete the unwanted records created on Excel SheetPage:1,2&3. Some records are created where the only information they have patient name & patient ID under columns 1 &2, and a default date in column 11, while the remaining cells in that row are blank. This happens on all sheets ( I know why it happens, that's why I want something that deletes this from all sheets or at least the 'Consolidated' sheet)