Dynamic Range Update Problem After Adding Records to Sheet in Excel 2007
I have had a brief look around the knowledge section but cannot seem to locate anything that matches my needs here.
I have a simple workbook with two sheets in it named "InvoiceHeader" and "Ledger".
In the sheet named "Ledger", I have added a button to add a set of predefined records to quickly assist whoever can help me with solving this problem.
Now there are two items I need to resolve here.
1. Each time I add a new row of records to either of the sheets, I need the ranges for each of them to grow automatically immediately after the addition has been completed;
After adding a row of data, I should be able to query the newly resized range to check the specific record that was just added. I am using forms to do this and in the Sheet named Ledger, I am most interested in the field NDate in column(a).
2. I want to do this in the most efficinet manner to avoid slowing the workbook down as it will grow quite large over time; i.e. Index, Match, Offset...