I copy and paste data from a webpage. The webpage has changed its format. The macros formula I use to sort the data from webpage no longer works. Can someone please adjust the macros code to adjust to the new data format? I would like the data in Column A sorted into the format in cells in Columns C thru J. Thanks in advance!
MacroFix.xlsx
Please Login or Register to view this content.
Last edited by 6StringJazzer; 06-29-2025 at 04:15 PM. Reason: better titles please
Please add sample of expected output to your file.
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED.
MacroFix.xlsxOriginally Posted by JohnTopley
Thanks in advance!
Hi Idaba,
You should post the .xlsm file so we can see the VBA as the .xlsx doesn't have any VBA in it.
One test is worth a thousand opinions.
Click the * Add Reputation below to say thanks.
Please Login or Register to view this content.
Last edited by JohnTopley; 06-29-2025 at 03:03 PM.
I have updated your title because it didn't describe your question.
Sorry about that!Hi Idaba,
You should post the .xlsm file so we can see the VBA as the .xlsx doesn't have any VBA in it.
MacroFIx.xlsm
Last edited by IdabaMalouki; 06-29-2025 at 06:24 PM.
See post #5
Thank you, John. Works like a charm!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks