Vba code to loop thru worksheets based on criteria

**Godlovesmeplenty** · 06-04-2015, 01:24 PM

Hi all, I am looking for help on a spreadsheet I have. I want a macro to loop thru my worksheets based on the a criteria and produce the result on another worksheet. In the workbook attached, I want Excel to loop through sheets purchase, sale and refinance based on a date greater than today and give me the result on closing list. Any help will be greatly appreciated.FOR EXCEL FORUM.xlsm

**daffodil11** · 06-04-2015, 02:05 PM

Please Login or Register  to view this content.

**JOHN H. DAVIS** · 06-04-2015, 02:19 PM

Maybe:

Please Login or Register  to view this content.

**daffodil11** · 06-05-2015, 10:28 AM

Following up with your PM: I have the distinct feeling that the example you posted and your actual source data are not the same.

My procedure includes branching decision making because the REFINANCE includes data from A:I while the other two worksheets include data from A:D.

Can you confirm that your original data has a consistent layout, or does it actually differ?

**Godlovesmeplenty** · 06-05-2015, 04:05 PM

Yes it has a consistent layout. The code works just great but what I did was I deleted the columns to a column to the left of the spreadsheet and some columns to the right. Once I use my actual spreadsheet then the code does not work. Copy belowFOR EXCEL FORUM.xlsm.xlsx Thanks a billion.

**daffodil11** · 06-05-2015, 04:30 PM

A number of things are different in this new workbook you've provided.

ClosingList vs 'Closing List'
A number of hidden worksheets
The source data is in B:E vs A:D
Original workbook had hidden columns on Refinance
New workbook has hidden columns on Closing List

Please Login or Register  to view this content.

**Godlovesmeplenty** · 06-08-2015, 01:59 PM

Thanks so much again for your help. This code works great, but what if I don't want it to be all visible sheets and just sheets that I specified. Any further help will be greatly appreciated.

**daffodil11** · 06-08-2015, 09:44 PM

Sorry for the delay, I'm away from the office on a business trip.

You can absolutely customize the code to fit any number of possibilities. If you want to make it trigger only on sheets you list, you can declare them.

Please Login or Register  to view this content.

**Godlovesmeplenty** · 06-09-2015, 12:26 PM

Thank you very plenty! It worked like a charm. I can't thank you enough.

Vba code to loop thru worksheets based on criteria

LinkBack

Thread Tools

Rate This Thread

Display

Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Re: Vba code to loop thru worksheets based on criteria

Thread Information

Users Browsing this Thread

Similar Threads

VBA Code that Sums on a Loop Based on Criteria and Linked to Calender

Loop code for certain worksheets in workbook

Loop code for selected worksheets

Need to loop code for certain worksheets in workbook

[SOLVED] Advancing outer Loop Based on criteria of inner loop

Bookmarks

Bookmarks

Posting Permissions