Excel VBA macro to import and sort data from one file into another

[mood66]

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

[Kaper]

Yes, It's possible.

Will you please attach a SMALL sample Excel workbooks (10-20 rows of data is usually enough) - both input file and master workbook? Please don't attach a picture of one (no-one will want to re-type all your stuff before starting).

1. Make sure that your sample data are truly REPRESENTATIVE of your real data. (If trere are typical cases like: all unique values/duplicates could occur, day/night, nobody present/several persons at once, before/on/past due, etc. - please show them all or at least indicate in text) The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

2. Make sure that your desired solution(s) is/are also shown (mock up the results manually).

3. Make sure that all confidential/restricted information (either personal or business) like real e-mails, social security numbers, bank accounts, etc. is removed first!!

To attach an Excel file you have to do the following: Just before posting, scroll down and press Go Advanced button and then scroll down and press Manage Attachments link. Now follow the instructions at the top of that pop-up screen.

[mood66]

Hello Kaper,

thank you for the quick answer.

I attached some example workbooks, but had to rename much of the data because of restricted information.
The input is basically a simple report generated by an external program. The columns are fixed. Unfortunately there is no timestamp in the report, but one report = one day.
The idea was to import such a report with the help of a button (macro), thus adding the data in the correct order in the master table.

Thanks again and have a nice day.