Hi folks,
Is the following possible.....
In a workbook I would like one worksheet to be a "LOG" that is populated with some data taken from the other worksheets (Customer Complaints in this instance)
Basically if we recieve a complaint..... The user will copy a master template in the workbook and rename the sheet tab with a sequential reference CC1...CC2
As new sheets are added I would like the log sheet to be automatically populated with selective data from CC1....CC2 (Date Customer Product...etc)
Hope I have explained adequately
Any help would be greatly appreciated
Kind Regards
Stephen
Is the following possible.....
In a workbook I would like one worksheet to be a "LOG" that is populated with some data taken from the other worksheets (Customer Complaints in this instance)
Basically if we recieve a complaint..... The user will copy a master template in the workbook and rename the sheet tab with a sequential reference CC1...CC2
As new sheets are added I would like the log sheet to be automatically populated with selective data from CC1....CC2 (Date Customer Product...etc)
Hope I have explained adequately
Any help would be greatly appreciated
Kind Regards
Stephen