Multi Cell update from REPORT to DB Worksheet

[sorensjp]

Hi,

UPDATED: PLEASE LOOK AT POST #2. I made changes to the worksheets.

I need to update a number a cells on the worksheet 'FIXED SPOT CKS DB' after running the on sheet Code below for the 'REPORTS' Worksheet:

The Range "E26,E27:E36,E46:E57,E62:E63,J26:J33,J38:J40,J46:J49" (framed in red) the 'REPORT' Sheet are being adjusted each time the 'SptCkNameUpDate' is run. The user is able to adjust the names applied to each cell based on any change in Cell E26. The idea being the as each week passes the Spot Checker being assigned is rotated based on the list of names in Cell Q6.

Thank you for your time and effort in advance.

V/r,
Jim

[sorensjp]

Hello,

I remapped the 'FIXED SPOT CKS DB' Sheet so the copy to ranges are next to each other. I would like assistance with the SUB copy and loop the sets of cells such as:
- 'REPORT' Wksht "AL26:AL36" to 'FIXED SPOT CKS DB' Wksht "AP26:AZ36"
- 'REPORT' Wksht "AL46:AL57" to 'FIXED SPOT CKS DB' Wksht "DN26:DY36"
and so on and to copy only the Values to the corresponding cells on the 'FIXED SPOT CKS DB'.

I attempted to write the MACRO below is located in the FILTERS Module.

I'm unsure how to make CBSRows a variable in this MACRO:

Please Login or Register  to view this content.

If some could assist on this I would be grateful. Again Thank you all for looking.

V/r,
Jim