Need to modify code to skip blank rows and headings

**missit** · 02-01-2015, 06:31 PM

Hi,

I need to modify this code so that it will skip the headings as well as the blank rows below the headings.

Please Login or Register  to view this content.

I have attached a workbook Working copy of Billing Summary.xlsmto show how the data is setup. Currently it includes the headings (Office/Outpatient, Hospital and Re-Audit) with all the data below those headings for each of the physicians, however, I need it to skip those headings and the blank rows below them and only extract actual data.

thanks for the help

Missit

**berlan** · 02-01-2015, 07:23 PM

Hi Missit,

try if this works for you:

Please Login or Register  to view this content.

Best,
Johan

**skywriter** · 02-02-2015, 02:22 AM

Rather than mess with your code why not just clean up the billing summary sheet.
I wrote this sub and it tested okay. Since you have that cool button where you can repopulate the billing summary sheet you can test it out for yourself.

Good Luck!

Please Login or Register  to view this content.

**AB33** · 02-02-2015, 05:26 AM

For skipping the heading, change this line

Please Login or Register  to view this content.

**missit** · 02-05-2015, 08:18 PM

Originally Posted by berlan

Hi Missit,

try if this works for you:

Please Login or Register  to view this content.

Best,
Johan

Hi, I tried sending you an answer on this, but I don't know where it went. It works fine, except that I forgot to mention that some of the pages may be blank. When that happens, the code breaks. Is there a way we can skip those pages that don't have any data in them?

Thanks so much for all your help.

Carole

Need to modify code to skip blank rows and headings

LinkBack

Thread Tools

Rate This Thread

Display

Need to modify code to skip blank rows and headings

Re: Need to modify code to skip blank rows and headings

Re: Need to modify code to skip blank rows and headings

Re: Need to modify code to skip blank rows and headings

Re: Need to modify code to skip blank rows and headings

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Need to add skip blank cells to my code

Need help to make VBA to skip rows that are blank

[SOLVED] Skip Section of Code if Filter Returns a Blank

Skip Blank rows

skip blank rows when pasting formulas

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions