Macro to export specific data only....

**BAWILS** · 04-03-2013, 11:01 PM

I want to export all rows (into a new Workbook) if they have numbers in the "Inv. Qtty" column? I would also like to maintain all headers & formats. Can anyone help me do this?

KegForumHelp.xlsx

**protonLeah** · 04-04-2013, 12:43 AM

self deleted

**BAWILS** · 04-04-2013, 02:32 PM

That kinda worked but not really. I don't know where to begin to describe what it is doing.

Here is another option and probably the simplest: Can you create a macro that will simply "hide" the rows in which there are no variables/numbers in the "Inv. Qtty" column?

**protonLeah** · 04-04-2013, 04:14 PM

self deleted

**BAWILS** · 04-04-2013, 04:51 PM

After messing with this more over the past 24hrs I would like to change to the alternative thought. can we create a macro that will simply "hide" the rows in which there are no variables/numbers in the "Inv. Qtty" column?