Hello, I need some help with my workbook

[eqeafarms]

I am trying to learn as I go here and I'm slow but steady. I want to have my workbook create a new row when certain info is entered into a cell. I am trying to track test results, and don't want a workbook a mile long so I want to start new rows after a certain point when we need to continue the testing process. Can someone help me with a code to make that happen? I'm learning and I am getting comfortable with functions but it is slow going, and I could really use some help. Thank you so much to anyone who might be able to help me!

 

[skillilea]

Can you put your data in an actual Excel table?

Highlight the data and hit CTRL+T, give it a name

The table will hold all your data validation and formatting.

It automatically does what you are wanting.

 

[eqeafarms]

I understand that, I mean to say these are ongoing investigations so there will be times where we may need a new row in the middle of the other rows, if that makes sense? Maybe I'm not asking the right question, sorry.

 

[skillilea]

You absolutely can add rows wherever you want. But what is the rule? Is it fine the last ID or order number or date or case number? How are you gonna tell Excel where to put the row?

Also, can you post your worksheet using XL2BB?

 

[eqeafarms]

I want to know how to make it start a new row under the current row if the cell in column 'T' displays the text "More Revision Needed"

I know I can add rows and stuff, I think I'm not being clear. Thanks for trying to help me.

 

[eqeafarms]

I want to know how to make it start a new row under the current row if the cell in column 'T' displays the text "More Revision Needed"

I know I can add rows and stuff, I think I'm not being clear. Thanks for trying to help . I will download that program and upload my workbook when I have more time, sorry!

 

[skillilea]

Welcome to the board by the way
So to be clear. A button on the top that looks at the active cell ./ active row and if column T has the correct value, insert row, else don't?

 

[eqeafarms]

Welcome to the board by the way
So to be clear. A button on the top that looks at the active cell ./ active row and if column T has the correct value, insert row, else don't?

Thank you for the welcome! Honestly, I am just gonna delete this post bc I think it is not a good question, I am studying up on macros and stuff and if I want to try this again, I am going to repost with a better and more specific question. I really appreciate your time and attempts to help me!

 

[skillilea]

No worries! Keep it up

 

[skillilea]

PS. If you right mouse click on your table on the active cell you can insert rows right there.