I'm new to using VBA, and am trying to create some code to run a daily macro.
The element of the code I'm stuck on is this: I import a daily excel sheet
where I need to have a simple formula that is:

=G1-Sum of "Range"+G2

The "Range" I need to define always starts with cell F11, and runs down the
F Column a variable number of cells. If I do this manually, I choose F11,
then hit Ctrl+shift+down arrow to select the range to the end of the data,
then apply the SUM function to that range:

So 2 questions:

1.what is the code the define the Range from F11 to the end of the data,
2. What is the construct of the formula (above) to include the SUM of that
Range?

Thanks for any help you can provide!