At the attached images you see three books. I use subtract in Book3 Book2 from Book1, column per column. The first column is the y coordinate. These column I just copy.
Until now I copy the formula of column B(Y) into every following column and change the column character manually.
My questions ist, if there is a possiblity to use a counting variable for the characters of the columns.
Like: range rNe = [Book1]Sheet1!Col(n) n = column book1 and book2
Please use “wcol(j)”. For example, highlight multiple columns, right click and select “Set Multiple Columns Values”. Define such in the “Before Formula Script”
range nB1=[book1]Sheet1!wcol(j); range nB2 = [book2]Sheet1!wcol(j);
automated counting columns
Posted - 01/06/2019 : 07:12:49 AM
