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?

On Jul 23, 3:57 pm, Cal0210 wrote:
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.

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----

--
RyGuy


"Spiky" wrote:

On Jul 23, 3:57 pm, Cal0210 wrote:
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.