I have a macro that simply copies the rows from all worksheets that are not
named "IB_Status" to the worksheet "IB_Status". All of the worksheets have
the same columns; one of the columns is a "Sort_Order" column. I want the
rows to retain the sort order entered from their original sheet (it doesn't
matter if there are duplicates). Somehow the values are changed when they
get to the "IB_Status" sheet. It looks like Excel is autonumbering them
sequentially for me. I have tried formatting these columns as text before I
copy them. I have tried Disabling AutoComplete under Tools | Options | Edit.
Nothing has worked.

I need help retaining the value from the original sheet--this is driving me
crazy!
Thank you,
Judy

Just a guess. That value you're pasting, isn't a value--it's a formula.

And when you paste it into its new location, it reevaluates.

(Maybe paste special|values???)

Judy Ward wrote:

I have a macro that simply copies the rows from all worksheets that are not
named "IB_Status" to the worksheet "IB_Status". All of the worksheets have
the same columns; one of the columns is a "Sort_Order" column. I want the
rows to retain the sort order entered from their original sheet (it doesn't
matter if there are duplicates). Somehow the values are changed when they
get to the "IB_Status" sheet. It looks like Excel is autonumbering them
sequentially for me. I have tried formatting these columns as text before I
copy them. I have tried Disabling AutoComplete under Tools | Options | Edit.
Nothing has worked.

I need help retaining the value from the original sheet--this is driving me
crazy!
Thank you,
Judy

--

Dave Peterson

You are so right! Since the user was sequentially numbering the rows Excel
supplied a formula instead of the values!

Now I have another problem, before all I had to do was insert the rows at
the top of the sheet. Now I have to figure out how to paste special on the
first blank row (I'm going to submit another post).

Thank you very much for helping me figure out what was happening!
Judy

"Dave Peterson" wrote:

Just a guess. That value you're pasting, isn't a value--it's a formula.

And when you paste it into its new location, it reevaluates.

(Maybe paste special|values???)

Judy Ward wrote:

I have a macro that simply copies the rows from all worksheets that are not
named "IB_Status" to the worksheet "IB_Status". All of the worksheets have
the same columns; one of the columns is a "Sort_Order" column. I want the
rows to retain the sort order entered from their original sheet (it doesn't
matter if there are duplicates). Somehow the values are changed when they
get to the "IB_Status" sheet. It looks like Excel is autonumbering them
sequentially for me. I have tried formatting these columns as text before I
copy them. I have tried Disabling AutoComplete under Tools | Options | Edit.
Nothing has worked.

I need help retaining the value from the original sheet--this is driving me
crazy!
Thank you,
Judy

--

Dave Peterson