Pivot Table Macro Help

[Emb21]

Hello everyone,

Using Excel 2010 and I am trying to create a macro to:

Pull data from "Sheet1" all rows that have no data in column G starting starting in row 23 and on (data resides in 16 columns E thru T) and create a pivot table from this data. Sometimes the data might be longer or shorter so I cannot hardcode the cells which the record macro is making me do and I don't want the blank rows as well.

I just need to get pass this part and I can record macro the rest. Any help would be appreciated.

Thanks,
Eric in PA