I created a macro that ends by creating a subtotal for some data. What I then want is to add a vlookup function for each subtotal "Total" in column L, I want the vlookup in column H. So it will go something like this, =vlookup(L7,GLNumber,2,false). How do I get the formula in column H and have it align right?
Please Help Thanks
Please Help Thanks