Copy paste Macro overlapping values due to constraint of range

[HINAUROOJ]

Hi everybody, i am here again with the same file fixed the other problems and managed to achieve the output . Right now i am facing problem in check box macros. I have 17 checkbox on one sheet and every checkbox have one macro associated with that. Macro stating to copy the certain vital for the respective product which is being checked and paste in the other small table on the same sheet . And i need to compare 2 products at a time for 6 different vitals. So i have only 2 rows available to manage between these 17 checkboxes output. Meanwhile I have assigned every even checkbox a range in row 39 and every odd checkbox a range in row 38 . Problem occurs in the case when user wants to compare 2 even or odd positioned products. Kindly help because i totally messed up all this and stuck on this for last 2 days. I appreciate your responses on my previous threads and it really helped me.

Thanks in an anticipation !

[Greg M]

Hi there,

Thanks for the Private Message and email you sent me regarding the above.

See if the attached version of your workbook does what you need.

The amount of code required has been significantly reduced, and there is no longer duplicated code for processing each of the CCH and ICP worksheets. The DO_NOT_DELETE worksheet is no longer required.

As you requested, I've added the Invest Cost and Invest Offer data in Columns V and W respectively on the ICP worksheet so that it is consistent with the CCH worksheet.

Hope this helps - please let me know how you get on.

Regards,

Greg M

[HINAUROOJ]

Thank you so much . It is perfectly working the way I want to .

[Greg M]

Hi again,

Many thanks for your prompt feedback and also for the Reputation increase - much appreciated

Glad I was able to help.

Best regards,

Greg M