dear all friends, good morning.
I have an invoice template in a worksheet in excel 2007.. By clicking two buttons ,I will be able to 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 and contributors.
great 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 request you to help me in "automatically undo/release 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 released before running the macros. hope I have conveyed my problem correctly...
your help will be greatly appreciated... thanks in advance