Originally Posted by
rkg
hello gurus!
i have a simple excel sheet containing sales data. each row has 3 columns- product cost, number sold and a total currency value column(col 1 & 2 multiplied). at the end of the report is a summation field of column 3, showing grand total sales.
now, i want to write a macro that will insert 5 lines at the end of the report (immediately after the last sale line item entry and before the grand total row.
now, since the last row of the report will keep changing, how can i automate the process? can i save a global variable that will maintain how many data rows have been entered? i tried recording a macro but the position of the insertion becomes static then.
please guide!
Bookmarks