Do until isEmpty and isBold - working 75%

[DadaaP]

So here is my code:

Please Login or Register  to view this content.

The goal is for it to continue to copy NON-BLANK cells until it hits another bold item. Bold items are the Businesses I am working with and underneath each bold section is a list of rows with various numbers, however some rows are blank and I want it to skip these rows and go onto the next to copy until it hits the bold title of the next business.

So far this is doing something it can void blanks if it is only 1 blank in a row between two values, however when multiple blanks are present it still copies and pastes blank values.

Help, I need it to not paste blanks into the list on Sheet1.

[Norie]

Can you upload an example workbook?

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[DadaaP]

Please Login or Register  to view this content.

[DadaaP]

That seemed to fix it. Never mind solved