Peter Muller
Board Regular
- Joined
- Oct 15, 2018
- Messages
- 133
- Office Version
- 365
- Platform
- Windows
Hello Experts,
I please need your assistance again. I have a problem, and have absolutely no idea how to go about resolving it. Please help.
I please need your assistance again. I have a problem, and have absolutely no idea how to go about resolving it. Please help.
- Each task in the "Task_Table" is either required on a specific day (Mon-Fri), or every day.
- When I activate the macro, today's day / the current day is used to identify which tasks must be copied and pasted in the input document which is linked to the pivot, with the daily tasks also copied from the 'Task_Table and pasted into the same input document.
- If there are 10 daily tasks, and 5 for a Mon, then running the macro and selecting "Mon", 15 tasks must be copied from the Tasks_Table and pasted into the input doc, and if 3 tasks on a Tue, then 13 tasks to be pasted into the input doc when "Tue" is selected.
- Each Day's tasks must be pasted below the last task of the 'previous day'.
- The input doc is in columns B:M, and the copied info is to be pasted into col D. The cell address where I select the relevant day for the macro is in "O2"
Task_Table | Input doc linked to Pivot - Columns B-M | ||||
Task | Frequency | Description 'Column D' | Mon | ||
Reconcilliation | Daily | Reconcilliation | |||
Replenish cash | Wed | Age Analysis - A-F | |||
Age Analysis - A-F | Mon | Bank Recons | |||
Age Analysis - G-L | Tue | Updated Skills Matrix | |||
Age Analysis - M-Q | Wed | TNA, submitted | |||
Age Analysis - R-Z | Thu | T scheduled & Monitored | |||
Supplier Recons - A-F | Tue | Registers monitored | |||
Supplier Recons - G-L | Wed | Late & Absent actioned | |||
Supplier Recons - M-Q | Thu | ||||
Supplier Recons - R-Z | Fri | ||||
Bank Recons | Daily | ||||
Updated Skills Matrix | Daily | ||||
TNA, submitted | Mon | ||||
T scheduled & Monitored | Daily | ||||
Registers monitored | Daily | ||||
Late & Absent actioned | Daily |