change validation list value and copy and paste from dependent cells

hi j.farr3ll, option without using formulas, press "Run" button

hi there,

thanks for this, works great on the dummy sheet. I'm struggling to move it across to my main workbook though.

The code breaks at the following line:

Please Login or Register  to view this content.

with a run-time error '9' Subscript out of range.

What is the vl?

Thanks,
James

vl is a cell from validation list range. I've updated the code with sheet reference for the code to run correctly either from button or code start from anywhere. Try it if that helps.

If it does not help can you post a real world workbook stripped of any confidential data if any?

Hi Watersev,

This still isn't working... stripping out the confidential data might not be an option it's a pretty big workbook. The only differences between this and dummy is that the data in range a11:B28 (dummy) is in B5:C1071, the validation list is in A5:A129 and the sheets are called "Summary2" and "trust Summary".

I've tried to adapt the code as follows: Can you see anywhere obvious where I've gone wrong?

Please Login or Register  to view this content.

hi James, what's the problem to make a mock up file with a list and data table of the same layout?

Please check attachment, I've deleted validation range search, the code just takes values from A5 and down till empty cell

optimized code for large data set in B:C, please check attachment

that's great. Thanks for your help and patience