How do I intergrate lines added so they follow in descending order

[Cal0210]

I am adding style nos with descriptions and prices and want to be able to
have them update and intergrate with existing ones already on my spreadsheet.
How do I format the rows, columns or cells so that all the information will
move and not just the style nos?

 

[Spiky]

I am adding style nos with descriptions and prices and want to be able to
have them update and intergrate with existing ones already on my spreadsheet.
How do I format the rows, columns or cells so that all the information will
move and not just the style nos?

Not sure what you mean by "move", that means to actually drag a cell
to another place, people almost never do that.

It sounds like you have a sorted database that you add lines to. You
simply have to re-Sort, I think.

If you mean something else, post with more description of your needs.

 

[ryguy7272]

Turn on the macro recorder, hot ctrl + G, special, blanks, borders, ok, thick
borders.
Turn off the macro recorder. Play back.
Does that do what you want?


Regards.,
Ryan----