Hi,
Hoping you can help me with the attached file. I need the data in the import subtab to be displayed in the way its shown in the clean data tab.
Context: We have a booking system for vulnerable adults whom we make appointments with.
Periodcally we need to extract the data from the system, when we do it provides us the data in the way shown on the import tab (for each client the work shop number is incremented, so workshop 1 is the records for client 1 and workshop 2 is the records for the second client and so on).
The end user then finds it difficult to sift through the data. For the purposes of this example file, I have enclosed 3 'workshops', but in a typical month we could have several hundred.
I need a macro to take the data in the firsttab and display it as shown in the second tab.
Im not an excel expert and have scoured the web looking for pointers - to no joy.
Thanks in advance for any support you can give us.
Regards,
EJ.
Hoping you can help me with the attached file. I need the data in the import subtab to be displayed in the way its shown in the clean data tab.
Context: We have a booking system for vulnerable adults whom we make appointments with.
Periodcally we need to extract the data from the system, when we do it provides us the data in the way shown on the import tab (for each client the work shop number is incremented, so workshop 1 is the records for client 1 and workshop 2 is the records for the second client and so on).
The end user then finds it difficult to sift through the data. For the purposes of this example file, I have enclosed 3 'workshops', but in a typical month we could have several hundred.
I need a macro to take the data in the firsttab and display it as shown in the second tab.
Im not an excel expert and have scoured the web looking for pointers - to no joy.
Thanks in advance for any support you can give us.
Regards,
EJ.