Best Approach for Data Collection on Weekly Basis

[misiek5510]

Hi all,

I'd like to collect some information on weekly basis. It would be something like below:

Place	Week	Date	Submitted on time (YES/NO)
London	1	01.01.2022	Yes
Paris	1	01.01.2022	Yes
Berlin	1	01.01.2022	No
Warsaw	1	01.01.2022	Yes

London	2	08.01.2022	No
Paris	2	08.01.2022	No
Berlin	2	08.01.2022	Yes
Warsaw	2	08.01.2022	Yes

So all the Entries in Place column will always be the same, however the other cells will change accordingly. Now instead of adding to this table every week I wanted to have two tabs: one with current week data and the other one to all historical ones. Now I wanted to add a macro that copies the data from the current week tab into the historical table however people were clicking twice on a button, which was duplicating the historical data for a given week, but also I was advised that we should have this file stored on Microsoft team which does not allow VB at all, so I'm not sure to to go about this. Ideally a pre-populated form that would put this data into excel file etc. Does anyone have any solutions in mind?

 

[QuestionBaker]

I have a macro file sitting in a Teams folder.
You can run the code if you open it as an app not in teams.

 

[misiek5510]

The problem with the app is the fact we are using office 2016 and the teams is 365, if I open via excel 2016 some new functions are not available.