So I have a worksheet that has entry's for data for every day of the month. The layout repeats every 6 rows for the entire month. My goal is that when a value is entered into the last formatted cell in column E for a day then a row would be inserted below it copying the formatting of the row that just had data entered and adding the value "N" to column b of the new row and a formula adding column h and j to column k.
So for example if i entered a value in cell E5 then a row would be inserted below it copying the formatting of row 5 and including the value and formula I specified in columns b and k. Then if a value was added to E6 it would do the same thing and so on and do this for every day.
I have attempted using ChatGPT to help me as I have very limited VBA knowledge and have not been getting anything to work. After allowing it to try multiple things I tried steering it in the direction of creating an inital list of cell references that starts at cell e5 and contains the reference for every 6 rows on until row 1000. Then if a value was input into column e anywhere it would check if that cell reference matched anything on the list and then would insert the row and then add 1 to the row value of the matched reference and every value that followed it on the list. I am unsure if this is the optimal way to go about solving this but any help at all would be greatly appreciated. I'll gladly answer any questions to clear up my objective or anything else you need.
So for example if i entered a value in cell E5 then a row would be inserted below it copying the formatting of row 5 and including the value and formula I specified in columns b and k. Then if a value was added to E6 it would do the same thing and so on and do this for every day.
I have attempted using ChatGPT to help me as I have very limited VBA knowledge and have not been getting anything to work. After allowing it to try multiple things I tried steering it in the direction of creating an inital list of cell references that starts at cell e5 and contains the reference for every 6 rows on until row 1000. Then if a value was input into column e anywhere it would check if that cell reference matched anything on the list and then would insert the row and then add 1 to the row value of the matched reference and every value that followed it on the list. I am unsure if this is the optimal way to go about solving this but any help at all would be greatly appreciated. I'll gladly answer any questions to clear up my objective or anything else you need.