The macro, as written, always copies the row to the bottom of the ALL sheet
and then sorts all the data in ALL. So, unless there are blank cells in
column 1, there should be no overwriting. The numbers in column B are not
involved in what the macro does.

If there will or could be blank cells in column 1, then the macro will need
to be modified to find the bottom of the data another way (perhaps a column
that won't have blank cells).

This thread it getting pretty far back in the stack, so if you want furher
help from me, you probably need to contact me directly with a sample
workbook and the below explanation of what you want to do.



--
Regards,
Tom Ogilvy





"Spreadsheet" wrote
in message ...

Thanks a bunch Tom, the macro is functional now.I just have a few
concerns.

1) Right now the macro adds the selected row to the "ALL" worksheet
according to the number in column B. This works very well when the new
row to be added to the ALL sheet has a number in column B that is
greater than any number in column B of the ALL sheet (the new row is
then added to the bottom of the sheet). However, when the new row to be
added to the ALL sheet has a number in column B that is less than some
of the numbers in column B of the ALL sheet, the macro finds the right
place for the new column and then overwrites whatever was currently in
that place on the ALL sheet. This may occur because there could be many
rows with the same number in column B.

SOLUTION? Can the macro insert a new row and then add the new
information to it?

2) The oonly other issue is this: If I want to merely update a row that
already exists, I don't want this row to be added to the ALL sheet, I
just want the information to be updated.

SOLUTION? The runs a logical test to see if the number in Column C
(this number is unique) of the currently selected row exists on the ALL
sheet in Column C. If it does, then the row containing this number is
overwritten by the currently selected row. If the number does not exist
in Column C of the ALL sheet, the macro proceeds to insert a row in the
correct place and writes the information there.

Are these suggestions possible? I'm not a programmer so I don't know if
that would be easy or not, but it seems like it shouldn't be impossible.
Thanks again for all the help.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile:
http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=551134