I have an Excel spreadsheet that multiple users use. I have several macros in the spreadsheet that move entries from one worksheet to another. One of these macros involves automatically formatting and sorting the data that the user pastes the tab delimited text into the worksheet. This macro depends heavily on the pasted data being already separated into the separate columns and all highlighted (which normally happens automatically since paste is of text that is already tab delimited).
I have one user that it was working correctly for until a couple of days ago. Now, when she pastes the tab delimited text into the worksheet, it populates all to only one column, with only that one column highlighted (as if the text was not tab delimited....more like what would happen with normal text to columns that wasn't delimited). Because hers is not formatting correctly when she pastes it into the worksheet, the macro to format, sort, and move the data to another worksheet isn't working. Again, the paste is working properly for all other users, it is only for her that it does this, and hers was working normally until a couple of days ago.
I know this has to have been something she inadvertently changed on her own Excel, but I have no idea what it could be. Can someone please guide me as to what could have caused her Excel to no longer recognize the pasted data as tab delimited text? I appreciate ANY help!
Bookmarks