agcd name month invno inv date invamt
monthwise bill details to be filtered a particular client and paste and merge all month in a single sheet
agcd name month invno inv date invamt
monthwise bill details to be filtered a particular client and paste and merge all month in a single sheet
Please attach a sample file with desired output.
Thanks
Attachment
Hello CP,
I have made little modification on your database to solve the task
Just copy all data in "All" sheet rather than different sheet for different month and then if you run this code then this will filter data basis on name, find the sheet with that name and if found paste the data.
[/CODE]Please Login or Register to view this content.
Let me know if this helps.
Regards
i am using it presently. (copy clienwise to sheetwise). My question is
I have monthwise bill apr,may,jun (sheetwise)
client name A (billed all three months)
I want to copy from all the month of the CLIENT (A) into a single (consolidated) sheet
I want to copy from all the month of the CLIENT (A) into a single (consolidated) sheet
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks