the attached is a copy of a spreadsheet that we use to balance/reconcile items. this is the first of a 3 stage process so on day one this form is completed. When opened the inputter may find they need more than the number of rows in the form so they will Press the Insert Rows button and insert rows in the appropriate section. This is fine on Day one as the formulas are already in place in the cells in columns 'N' and 'P' However, at the end of the process all of the details from Sheet1 are copied to Sheet 2 and my concern is the formulas may be lost or someone may add more rows etc. As a matter of control I would like to be able to insert the formulas again but now the 'Totals' rows may well be on different row.
Can an expert provide vba code that will be able to find the appropriate row and insert the formulas in 'N' and 'P' I am guessing the way to do it is find Book on row 19 and work from there, the last one being Balance which is the total of all the totals above . !
Experts Exchange is the only place where you can interact directly with leading experts in the technology field. Become a member today and access the collective knowledge of thousands of technology experts.