dimanche 31 janvier 2016

Excel Checkbox/Checklist-Copy and Paste to specific range based on Date

I am new to VBA and Macros.

I have created a Spreadsheet for generating Service Reports. In that, I have a checklist of tasks that need to be completed. So far when a checkbox/task is checked as complete, it will highlight that item green.

The checkboxes are Form Control. They are in Column AD starting with Row 56. The Tasks are listed in Column AE starting with Row 56... and on down. AD57-AE57...

I have a range of cells (A56:A80, A83:A107...) These are for Techs to enter in completed tasks for that day. There is a date (IE- Cell B55,B82..) for each range that is set when the Report is generated.

Here's what I am having trouble with: For Example,

If Checkbox AD56 = True and Cell B55, B82, etc = Today's Date then Copy and Paste the Value of Cell AE56 to Cell A56 or A83... or in the next available cell down in that range based on the date condition.

See pictures for reference to the list and completed task range.

Thanks,

STG

Checklist

Completed Tasks




Aucun commentaire:

Enregistrer un commentaire