Hello,
I need help with Excel. I have a sheet where I paste data that includes dates and the amount of weight (in kilograms).
In the data I paste, there are 30 entries for 30 days, or 31 entries if it's a 31-day month.
I've created another sheet for Monday to Friday, essentially a "calendar" with 31 days. In the data I'm pasting, let's assume there are 30 days.
Now, I want each day from the data I'm pasting to populate on the second sheet. I want the sheet to allow me to select a year and a month, and then it should fetch the data for that chosen month. Specifically, it should display the kilograms for each Monday through Friday.
Could you assist me with this?
How can i by the data that i paste populate the table with Monday to Friday?
So for each date if its a monday it should be put in monday and etc.
I need help with Excel. I have a sheet where I paste data that includes dates and the amount of weight (in kilograms).
In the data I paste, there are 30 entries for 30 days, or 31 entries if it's a 31-day month.
I've created another sheet for Monday to Friday, essentially a "calendar" with 31 days. In the data I'm pasting, let's assume there are 30 days.
Now, I want each day from the data I'm pasting to populate on the second sheet. I want the sheet to allow me to select a year and a month, and then it should fetch the data for that chosen month. Specifically, it should display the kilograms for each Monday through Friday.
Could you assist me with this?
| Date | Fakturanr | Kvantitet | Enhet | Summa kg | Kontamination | År | Månad | Dag | WeekDay | |
| 2023-08-31 | 90646661 | 3 760 | Kg | 3 760 | 2023 | 8 | 31 | 4 | ||
| 2023-08-30 | 90646661 | 3 100 | Kg | 3 100,00 | 2023 | 8 | 30 | 3 | ||
| 2023-08-29 | 90646661 | 4 360 | Kg | 4 360 | 2023 | 8 | 29 | 2 | ||
| 2023-08-28 | 90646661 | 6 520 | Kg | 6 520 | 2023 | 8 | 28 | 1 | ||
| 2023-08-25 | 90646661 | 2 520 | Kg | 2 520 | 2023 | 8 | 25 | 5 | ||
| 2023-08-24 | 90646661 | 2 840 | Kg | 2 840 | 2023 | 8 | 24 | 4 | ||
| 2023-08-23 | 90646661 | 4 320 | Kg | 4 320 | 2023 | 8 | 23 | 3 | ||
2021-09-22 | 90646661 | 3 740 | Kg | 3 740,00 | 2021 | 9 | 22 | 3 | ||
| 2023-08-21 | 90646661 | 7 080 | Kg | 7 080 | 2023 | 8 | 21 | 1 | ||
| 2023-08-18 | 90646661 | 8 180 | Kg | 8 180,00 | 2023 | 8 | 18 | 5 | ||
| 2023-08-17 | 90646661 | 6 940 | Kg | 6 940 | 2023 | 8 | 17 | 4 | ||
| 2023-08-16 | 90646661 | 4 800 | Kg | 4 800 | 2023 | 8 | 16 | 3 | ||
| 2023-08-15 | 90646661 | 3 500 | Kg | 3 500 | 2023 | 8 | 15 | 2 | ||
| 2023-08-14 | 90646661 | 8 220 | Kg | 8 220 | 2023 | 8 | 14 | 1 | ||
| 2023-08-11 | 90646661 | 4 020 | Kg | 4 020 | 2023 | 8 | 11 | 5 | ||
| 2023-08-10 | 90646661 | 6 160 | Kg | 6 160 | 2023 | 8 | 10 | 4 | ||
| 2023-08-09 | 90646661 | 6 980 | Kg | 6 980 | 2023 | 8 | 9 | 3 | ||
| 2023-08-08 | 90646661 | 3 220 | Kg | 3 220 | 2023 | 8 | 8 | 2 | ||
| 2023-08-07 | 90646661 | 7 420 | Kg | 7 420,00 | 2023 | 8 | 7 | 1 | ||
| 2023-08-07 | 90646661 | 4 060 | Kg | 4 060,00 | 2023 | 8 | 7 | 1 | ||
| 2023-08-04 | 90646661 | 4 260 | Kg | 4 260 | 2023 | 8 | 4 | 5 | ||
| 2023-08-03 | 90646661 | 5 760 | Kg | 5 760 | 2023 | 8 | 3 | 4 | ||
| 2023-08-02 | 90646661 | 5 360 | Kg | 5 360 | 2023 | 8 | 2 | 3 | ||
| 2023-08-01 | 90646661 | 4 160 | Kg | 4 160 | 2023 | 8 | 1 | 2 |
How can i by the data that i paste populate the table with Monday to Friday?
So for each date if its a monday it should be put in monday and etc.
| Monday | Tuesday | Wednesday | Thursday | Friday |
