Originally Posted by
georgiboy
How will you know where to place table2 if you don't know how large table one is?
Where you say the formula is going on column K, will this always be K?
Could you calculate the Average formula with VBA and place the result at the end of the table?
Are we dealing primarily with amending historic data or are we creating a process that creates the correct format going forwards? These are very different things.
If you see my first post, I have mentioned that i will be using below code to place table2.
Set table2top = Range("A1").End(xlToRight).Offset(0, 1)
Set table2bot = Range("A1").End(xlToRight).End(xlDown).Offset(0, 1)
It wont be always K. It will be based on the code above, like
Set table2value = Range("A1").End(xlToRight).Offset(1, 1)
Now i have to enter the average formula in the cell selected using above code and autofill for the entire table.
Reply With Quote
