Code causing data to disapear

[kosherboy]

Hi Forum,
The script of code below seems to be deleting most of my information on a spreadsheet but i am not sure why??
It only happens when once i enter a value into the active cell mentioned below (which is any odd cell in range N) and haven't exited out of that cell yet, meaning the curser is still flashing, and then i select a different sheet so as soon as i return to the original sheet somehow most of my information is gone!

*If it helps, the code below starts on any odd cell in column "N" and whatever is entered in that cell gets copied to all the odd cells in column "N" that have the same matching PO number which is found on the same row in the odd cell under column "L".

Please Login or Register  to view this content.

Any help would be greatly appreciated

[skywriter]

Can you post the worksheet? Make up some dummy data if you have to, but make sure it's indicative of your real data.



Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

[kosherboy]

Thank you for your interest in my thread.
Here is the file which i 'cleaned up" EXAMPLE 1.xlsm.
So again, make sure macros are working (sometimes these automatic macros stop working when it gets interrupted) and go into the sheet that is named 'Report Center', click on any of the links under the header 'Vendor', you will immediately be brought to the corresponding order on sheets 'Invoiced Orders' the row that you are in should be dark purple, now on sheets 'Invoiced Orders' on the active row go to column "W" and 1 cell below which you will see that it's blank, enter a "Y" in it but don't click out of the cell and instead go back to "Report Center" and then back to "Invoiced Orders", you will see that a large amount of data has gone missing
*By the way, if you click out of the cell in column "W" and go to "Report Center" and then back to "Invoiced Order" no changes happen except that the row turns green like it's supposed to.

Looking forward to hearing back from you

[karedog]

Change :

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

[kosherboy]

Hi Karedog,
Nice to see you again
Unfortunately the revision in the code did not change anything, the data still got lost

[karedog]

Hi kosherboy, me too

After I examined the whole code (you only posted part of it), there are still 4 occurences of "ActiveSheet" keyword. Please change them also to "Me", just like post #4. You can use Find and Replace feature (by pressing Ctrl H) to do this. Hope this help.


Regards

[kosherboy]

Wow, that worked!
Thank you so much
If it is not too much i would really like to understand what the difference between "activesheet" and "me" is and why my data was disapearing when i used the activesheet version?

[karedog]

You are welcome, thanks for the rep. points.

Me -> this refer to the sheet where the code is located
ActiveSheet -> this refer to the active sheet (the one that currently got the focus)

You put the code in the sheet called "Invoiced Orders"

If you don't select another sheet, then Me ("Invoiced Orders") is always the same with ActiveSheet (because the focus never left this sheet), so the code is worked.

But if you select another sheet (for example "Report Center"), then the ActiveSheet become refer to this sheet ("Report Center"), while actually the code must be performed on sheet "Invoiced Orders", so the code need to adjusted.

Hope this help.


Regards

[kosherboy]

I understand, thanks for explaining.
All the best Karedog!

[karedog]

You are welcome, glad I can help.


Regards