I have an existing excel document that has a header with formulas and footer with formulas, mostly summing the information above.
How do I use automation to insert data into the middle section without knowing how many rows there will be? For example I have one customer with only 5 records and another with 100. I could not figure out how to insert rows through automation. In addition when I insert a row how do I keep the formatting of the source row?
Thanks in advance