Hello All,
I have attached a sample worksheet . I will have 15 worksheets inside a workbook ( 12 sheets for each month ) another separate 3 sheets. I have a sheet called "Receivables". I want that particular sheet to auto populate data from the remaining worksheets. It should pull data only from the rows which have "Debtors" and "Debtors Received" . Every time i run the macro it should clear the existing receivables sheet (Except Headers). and repopulate it . Hope i was clear enough. Thanks for trying to help me out.
Bookmarks