Copying formula to top of a table which varies in size
Posted by Ben on October 26, 2000 12:16 PM
How can I use a macro to copy a formula in the last row of column G in a table, all the way up the table to the first row in column G, so the entire column in the table contains the same formula, but for the specific row.
e.g. =D7+D7 with the row above reading =C7+C8
But the catch is that the table varies in size from the first macro that will be run.
There are also more columns after column G!