Hi,
I have already created a few macros to format the data that I'm working with. I just need one more step that I can't figure out.
I'd like to create a summary at the bottom of all the data - originally, I did this with the following code:
Sub Summary()
Range("J60").Select
ActiveCell.FormulaR1C1 = "TABLE TITLE"
Range("J61").Select
ActiveCell.FormulaR1C1 = "No"
Range("J62").Select
ActiveCell.FormulaR1C1 = "Yes"
Range("J63").Select
ActiveCell.FormulaR1C1 = "Total"
Range("K61").Select
ActiveCell.FormulaR1C1 = _
"=SUMIF(R[-56]C[-4]:R[494]C[-4],""No"",R[-56]C[-2]:R[494]C[-2])"
Range("K62").Select
ActiveCell.FormulaR1C1 = _
"=SUMIF(R[-57]C[-4]:R[493]C[-4],""Yes"",R[-57]C[-2]:R[493]C[-2])"
Range("K63").Select
ActiveCell.FormulaR1C1 = "=SUM(R[-2]C:R[-1]C)"
End Sub
However, since the data I'm working with gets exported around every week, and every week the data changes (i.e. the # could increase or decrease), I realize I can't use absolute cells in case they overlap with the data. I was hoping to create a Macro that would prompt the user to select where they want the table placed, and then have the macro do the rest of the work summing and such, but I'm not sure how to do this. Any help is much appreciated.
Thanks in advance!
Bookmarks