Hello,
I am new to this site and to VBA, so please bare with me.
I need a macro for work to import data from an Excel file into a "Master"-Excel and sort it in a table. The task is to list occured events based on calendar weeks (CW).
The input (separate Excel file) is the frequency of events in the CW and the result (master list) should look something like this:
Event CW30 CW31 CW32
A ....... 3 ................. 4
B ....... 2 ....... 5 ....... 2
C .................. 7 ...... 1
D ............................ 1
If the event is present in the master-list, then add a column with the frequency for that CW.
If the event was not present before, then add a row with that event at the end and a column with the frequency.
I hope this is possible.
Thank you.
Best regards,
mood66
I am new to this site and to VBA, so please bare with me.
I need a macro for work to import data from an Excel file into a "Master"-Excel and sort it in a table. The task is to list occured events based on calendar weeks (CW).
The input (separate Excel file) is the frequency of events in the CW and the result (master list) should look something like this:
Event CW30 CW31 CW32
A ....... 3 ................. 4
B ....... 2 ....... 5 ....... 2
C .................. 7 ...... 1
D ............................ 1
If the event is present in the master-list, then add a column with the frequency for that CW.
If the event was not present before, then add a row with that event at the end and a column with the frequency.
I hope this is possible.
Thank you.
Best regards,
mood66
