It seems to be working, with only two problems for one i cannot find a pattern.
One is that the range in column W is not the same as range in column E when formulas are copied. (which is important). because with the second macro i want to be able to return the copied formulas to original cells if needed. And if formulas are copied into the column W without the blanks in between ranges this would be harder to do.
Something like this i suppose but what i wrote dosent work :D
Second one is when it copies the values back to original range i get a #N/A as a result in some cells. From D29:E29 and also in D67:E70, D80:E84 , D100:D101. The formulas are the same in all cells but only in this cells the values come as N/A. Is it possible that this two problems are corelated?
If u need workbook let me know.
Bookmarks