Quote Originally Posted by snb View Post
Did you overlook #5 ?
Yes,

with the same format of Sheet 1 along with the formulas in cell( instead of value format) like "=149/6" will solve the purpose.

also the row and column are flexible number of row used to change every time.

the solution provide by the admin is working for the 1st line only and then "Dest.Resize(UBound(d, 1), UBound(d, 2)).Value2 = d" code highlighted as error.

if you help to resolve the error also fine for me.

Thanks for the support.