Help needed please! New in Excel VBA.
I would like to search client lastname and firstname from multiple sheets and display the heading and records of matched client’s name, service date and payment. These fields are not necessary in the same column in each sheets, ie. lastname and firstname, service date, payment might be in column C, D, F, H in Sheet A, but in A,B, F & G in sheet B, so the way to identify these fields are from the sheet heading (1st row). Is this possible to do in VBA?
Thank you.
Ying-Ling Wang
