|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.
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
Any help on this would be much appreciated