Excel Macro question - ASAP
bhihu45excel.docx
1. Write code in VBA to determine the row number of the last row with data. Are there any precautions/edge cases to be aware of for that code?
Please see EXCEL Attached file with two sheets:
1. "Base", which has data from 7/13-7/26
2. "Addition", which has data from 7/20-8/02.
Write a function in VBA to refresh the data in "Base" with that in "Addition". In other words:
1. Remove records in "Base" if they fall within the date range of records in "Addition"
2. Append the records from "Addition" to "Base". Do not include the Grand Total row
when appending