VBA Macro - Copy and paste data match by column headings
For the VBA code in the attachment below, if let's say i wanted to only copy and paste data matched by column headings, how can that be done?
What i'm trying to do is to copy all data under the specific column headings listed in MasterData sheet from the source file where the column headings match.
Can i also ask if how could the code be modified such that instead of column F "Copy to Sheet", i would like to copy to a new excel workbook instead with the spreadsheet named with variable "Item No"?
Could someone please help? Many many thanks.
|Addendum B - Xichlo Mobile NETWORK INFORMATION SHEET 288 2015-02-26.xls||144 KB|