|Thank you both! This worked really well. I am only adding 5-10 rows per click so the calculation time is not a big issues. So my next step for the program after adding the new rows at row y is to:|
1) Drag down cells for columns A-L from row y into the newly added rows, copy cells do not fill series so Column B stays constant. I am trying to keep the formulas that are in the cells but not the values. The formulas are vlookup formulas pulling data from a separate tab. Column C contains the unique value that is user input. Columns A, E, F, G, H, I, K calculate based off value in Column C. Columns L, and J are user entered commentary for the rows. Its a production schedule. Column B is a constant.
2) After dragging down the cells then I would like to delete the values in Columns C, L, and J. The format calculated columns will update automatically when Column C is changed.
3) The third step is to assign a lot number in Column J to each row which consists of DDMMYYAAABB incrementing BB five values up starting at 01, 05, 10, 15 etc. to keep unique values for each row. AAA is a three digit constant. This may be tricky and I may have to leave it as manual entry.
Let me know if any ideas on what type of code might work for this.