record a macro,
filter your data on an invoice
save the macro.
edit the macro
then add at the end
ActiveSheet.Range("a1").CurrentRegion.Select
Selection.Copy
Worksheets.Add
ActiveSheet.Paste
record a macro,
filter your data on an invoice
save the macro.
edit the macro
then add at the end
ActiveSheet.Range("a1").CurrentRegion.Select
Selection.Copy
Worksheets.Add
ActiveSheet.Paste
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks