Related:
- Autopopulating multiple sheets from main sheet by date
- Google sheet right to left - Guide
- Windows network commands cheat sheet - Guide
- Little alchemy cheat sheet - Guide
- Mark sheet in excel - Guide
- How to open excel sheet in notepad++ - Guide
2 responses
So are you in an analyst role at work? Ask for a more defined report. Or ask for about 5 different reports. If we build the easy button for you, what does it leave for you to do?
Hello
Thank you for taking the time to answer.
Not sure if I should laugh or be mad.
No, I am not an analyst. I coordonate 6 people and part of our daily job is to go by the date on those sheets. I know there is a VBA code. I asked for help to simplify our job because there are lots of other tasks we need to perform and for me as a coordinator I defenetly have more duties, not just this one.
Thank you for taking the time to answer.
Not sure if I should laugh or be mad.
No, I am not an analyst. I coordonate 6 people and part of our daily job is to go by the date on those sheets. I know there is a VBA code. I asked for help to simplify our job because there are lots of other tasks we need to perform and for me as a coordinator I defenetly have more duties, not just this one.
Hi.
The list is actually a report that we get daily. And so every day we pull it for the previous day and we have to subtract the rows that contain the same date (witch we find in colomn H in a text among other info) and from there past it in other sheet with same date. Next day we pull the report again and keep adding to the date sheet.
For example I have 200 rows today with text on column H dat has 50 rows date 11.12, 50 11.13, 5 rows 11.14, 6 rows 11.15 and so on till we get to 200
Tomorrow I have 300 rows with dates that vary from 11.13 to 11.20. The splitting is done by date and paste in the sheet with that date.
The list is actually a report that we get daily. And so every day we pull it for the previous day and we have to subtract the rows that contain the same date (witch we find in colomn H in a text among other info) and from there past it in other sheet with same date. Next day we pull the report again and keep adding to the date sheet.
For example I have 200 rows today with text on column H dat has 50 rows date 11.12, 50 11.13, 5 rows 11.14, 6 rows 11.15 and so on till we get to 200
Tomorrow I have 300 rows with dates that vary from 11.13 to 11.20. The splitting is done by date and paste in the sheet with that date.
