Hi there, first post, rather complicated (at least for me) problem. Is this possible the way I want?
I've got a sheet with ranges of numbers for each calendar week, I then have seperate sheets for every calendar week (week1, 2, 3 and so fort). Is it possible to automate filling in these numbers from my source sheet to the individual weekly sheets? At the moment this would be a rather tedious copy and paste marathon.
I've copy pasted the numbers for the example now.
I'll be happy to provide additional information if needed.
I've got a sheet with ranges of numbers for each calendar week, I then have seperate sheets for every calendar week (week1, 2, 3 and so fort). Is it possible to automate filling in these numbers from my source sheet to the individual weekly sheets? At the moment this would be a rather tedious copy and paste marathon.
Mappe2 | ||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | L | M | N | |||
1 | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | ||
2 | 04.01.2020 | 05.01.2020 | 06.01.2020 | 07.01.2020 | 08.01.2020 | 09.01.2020 | 10.01.2020 | 11.01.2020 | 12.01.2020 | 13.01.2020 | 14.01.2020 | 15.01.2020 | 16.01.2020 | 17.01.2020 | ||
3 | 3'155 | 3'563 | 1'443 | 2'446 | 2'285 | 2'845 | 3'868 | 4'185 | 4'506 | 2'316 | 2'204 | 2'858 | 2'859 | 4'431 | ||
4 | Week 1 | Week 2 | ||||||||||||||
Sheet1 |
I've copy pasted the numbers for the example now.
Mappe2 | |||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | J | K | |||
1 | WEEK | 1 | YEAR | 2021 | |||||||||
2 | DATE | 04.01.2021 | 05.01.2021 | 06.01.2021 | 07.01.2021 | 08.01.2021 | 09.01.2021 | 10.01.2021 | Total | ||||
3 | DAY | Monday | Tuesday | Wednesday | Thursday | Friday | Saturday | Sunday | |||||
4 | 3'155 | 3'563 | 1'443 | 2'446 | 2'285 | 2'845 | 3'868 | ||||||
Week 1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
D2 | D2 | =DATE(J1, 1, -2) - WEEKDAY(DATE(J1, 1, 3)) + F1 * 7 |
E2 | E2 | =D2+1 |
F2 | F2 | =D2+2 |
G2 | G2 | =D2+3 |
H2 | H2 | =D2+4 |
I2 | I2 | =D2+5 |
J2 | J2 | =D2+6 |
Cells with Data Validation | ||
---|---|---|
Cell | Allow | Criteria |
D4:K4 | Whole number | between 0 and 10000000 |
I'll be happy to provide additional information if needed.