Can an expert help me out with this please. I need VBA code that will copy data from each of the sheets into the summary sheet.
The criteria is, Data from the individual sheets needs to be copied to the summary sheet.
On the individual sheets In cell A8 is the name which needs to be copied into the summary sheet followed by the heading [Row 10] [See summary sheet example]
Under each heading in the summary sheet I need to copy the data from the individual sheets. [again see summary sheet example]
The headings on the summary sheet are:
Type of CCY Amount Product Reason Categorization Raised on DES Ageing Site Issue Owner In Ops Categorization