Consolidate client data from monthwise to new sheet

Consolidate client data from monthwise to new sheet

attached sample file

Try this:-

Please Login or Register  to view this content.

Regards Mick

compile error

end with

compile error

end with

Put in

Please Login or Register  to view this content.

In between Next k and end sub

Thank You, "AB33"

thank u all, i need a particular client ("A") only has to be copied from all sheet and put in a new sheet

The first code is as per the Original but with "Header" Names in Results sheets.
The Second code Creates a new sheet with results for "A" only.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Regards Mick

THANKS IT WORKS PERFECTLY

this is a sample file only. I have the file has 16 headers and 12 months. Pl help like that

Please provide example file with "Before " and "After"

Attached here

forum experts pls help

Try this:-
NB:- Change/Increase Months in Array to suit

Please Login or Register  to view this content.

Regards Mick