how to make a VBN to automatically move a row to the bottom of the screen when conditions are met

[Pali12345]

Hey there!
I am attempting to jazz up some of my inventory tracking sheets and I am struggling to understand how to create a VBN code.
I have a set of data from A1 - G1 that goes down to A1203 - G1203. I would like to format them so that when "Y" is entered into a cell in column G It will turn the row fill to green and move the entire row to the bottom of the table.
I have seen a few threads with similar problems but I am not versed enough in the excel world to convert the formula to work with my specific data.
Any help is greatly appreciated.
(I hope I gave enough info)

 

[Pali12345]

Hey there!
I am attempting to jazz up some of my inventory tracking sheets and I am struggling to understand how to create a VBN code.
I have a set of data from A1 - G1 that goes down to A1203 - G1203. I would like to format them so that when "Y" is entered into a cell in column G It will turn the row fill to green and move the entire row to the bottom of the table.
I have seen a few threads with similar problems but I am not versed enough in the excel world to convert the formula to work with my specific data.
Any help is greatly appreciated.
(I hope I gave enough info)

Edit: Just goes to show how much I dont know about excel I meant to write VBA lol

 

[Joe4]

If your data in an actual "Excel Data Table", or is it just in a data list?
It is important to note the difference, as Excel Data Tables have their own properties and behaviors that data lists do not have.
So your answer to that question will determine how the VBA code needs to be written.

Also, are the "Y"'s being entered into column G being entered manually or by formula?

 

[Pali12345]

If your data in an actual "Excel Data Table", or is it just in a data list?
It is important to note the difference, as Excel Data Tables have their own properties and behaviors that data lists do not have.
So your answer to that question will determine how the VBA code needs to be written.

Also, are the "Y"'s being entered into column G being entered manually or by formula?

Hey I have it formatted as an excel table and we will be manually entering the "Y" into he last column

 

[Joe4]

Take a look here at this post, which shows you how to move a table row to the bottom of a table based on its value:

VBA to Move row to bottom in table depending on cell value

hello i’m new at work and i need help with a very easy task but i dont know how to do it with tables just with ranges in VBA, but its important to keep it as a table to my boss, what i need is a row goes to the bottom depending on the cell value on column O when it says “ DONE” and i prefer not...

www.mrexcel.com

Coloring the row should be a pretty trivial add-on to that.
You can get the color code you need by turning on your Macro Recorder, and recording yourself manually coloring a row to your preferred color.