Combining VBA Subs

Hi All,

I have a VBA code (created by Bernie) which works great but I want to have the same code to feed into a different sheet, using a slightly different criteria. I assume you cant have two subs in one worksheet but is there a way I can combine these two?

Please Login or Register  to view this content.

Moderator's note: Please take the time to review our rules. There aren't many, and they are all important. Rule #2 requires code tags. I have added them for you this time because you are a new member. --6StringJazzer
Thank you,

Haider

Your two procedures each have this line

Please Login or Register  to view this content.

If you combine the two procedures, what database sheet do you want to copy to for "CAL"? Or how would you distinguish between the two "CAL" s?

Or does the source sheet differ for the two databases? If yes, what are the names of the source sheets?