Adding a new row to a Filtered Sheet

June 29, 2010 at 01:56:38
Specs: Windows XP, 2GB
Hi All

Im looking to add a new row to a filtered spreasheet. The macro below will add the new row to spreadsheet on the next available blank line however I have several different categories which I can view individually by filtereing on column C and once filtered on a particular category I would like to be able to add the new row to that particular category and not just the next blank row on the spreadsheet.

Sub A_CARS()
Worksheets("Sheet1").Range("G" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteFormats
Worksheets("Sheet1").Range("G" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteFormulas
Application.CutCopyMode = False
End Sub

Any help on this would be much appreciated


See More: Adding a new row to a Filtered Sheet

Report •

June 29, 2010 at 12:24:33
I don't do a lot with filtering, so maybe I'm misunderstanding your goal.

If you add the row to the bottom of the spreadsheet, wouldn't you still be able to filter the sheet on Column C?

Doesn't each "added" row contain the filter criteria in Column C?

Report •

June 30, 2010 at 01:23:13
Thanks for the reply and Yes your exactly right!.....I just figured it out last night!! that does the trick alright...thanks again for reading my questions and replying anyway :)

Report •

Related Solutions

Ask Question