Storing and and later analyzing data

magrim

New Member
Joined
Sep 4, 2017
Messages
2
My knowledge of excel is rather limited as you can read from the request below, however I would appreciate any assistance or advise on the matter.
I work in admissions and we are inputting weekly group bookings for one year in advance. We are taking bookings for every week in July and August.
Bookings keep changing, we are deleting and adding as we go along. We are 3 working on the same document. However, we would like to keep all the records to be able to analyze them without storing every single version when we amend the document. What would be the best way to do so.
We basically have vertically week, 1, week 2,.... until week 8 and horizontally names of groups and we write number of people in respective weeks
Thanks in advance for any advice , Magrim
 

oldbrewer

Board Regular
Joined
Apr 11, 2010
Messages
10,985
week1week2week3week4week5week6week7week8
location1354 3344
location2 444 344
location3686 8888
is it like above if so have a log under it
locationweekchanged fromchanged towho bydatewhoever makes a change
2324fred01/08/2017saves the workbook
3768bill03/08/2017so you keep a record of the amendments

<colgroup><col span="5"><col><col span="7"></colgroup><tbody>
</tbody>
 

magrim

New Member
Joined
Sep 4, 2017
Messages
2
week1week2week3week4week5week6week7week8
location13543344
location2444344
location36868888
is it like above if so have a log under it
locationweekchanged fromchanged towho bydatewhoever makes a change
2324fred01/08/2017saves the workbook
3768bill03/08/2017so you keep a record of the amendments

<tbody>
</tbody>
Thanks. It is actually the other way around, it is something like the table below:
group 1group 2group 3group 4
week 1711
week 222811
week 3118
week 421934
week 5912
week 6
week 7

<tbody>
</tbody>

However your suggestion would still work.Thanks,M
 

Forum statistics

Threads
1,085,255
Messages
5,382,600
Members
401,797
Latest member
meloanthony

Some videos you may like

This Week's Hot Topics

Top