Conditional Copy, and Paste

[Peter Muller]

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.

• 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

 

[Peter Muller]

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.

• 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

I re-posted this on 06 May with a new thread title