dear all, I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will store some cell contents of the invoice template in a work sheet "invoices-list" and some other cell contents in another work sheet "credit-list". I got macros to get this done through our forum friends.thanks to all of them.
Now my problem is :
suppose I have filter on a particular item in some column either in invoices-list or in credit-list. or both.....by not noticing that if I run the macros in my invoices template...then the newly copied rows are replacing the existing data in the filter range (over writing)...this should not happen...
so I want your help in "automatically undo all filters, if any" in all sheets before running the macros. I mean ..suppose there is filter by item say "ram"...then it should be all names in that column before running the macros. hope I have conveyed my problem correctly...bye suryam