How can I automatically convert this data to column A in a worksheet with a macro. So that when I paste (CTRL + V) into the cells of column A, this data is automatically converted?
For example:
Should automatically convert to:
Please Login or Register to view this content.
That is, it is necessary that (any number)m and (any number)M be on the right.Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
You can say "THANK YOU" for help received by clicking the Star symbol at the bottom left of the helper's post.
Practice makes perfect. I'm very far from perfect so I'm still practising.
When using this macro, the data must be entered in advance and then run the macro manually. But I need the macro to automatically run on the sheet when data is inserted.Originally Posted by Mumps1
Try:
Please Login or Register to view this content.
Last edited by moninah; 09-10-2022 at 02:43 PM.
@moninah
Maybe you can start replying on#2 of Mumps1
Did the offered solution work or if it fails, on what part did it fail.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry into column A and press the ENTER key.
Please Login or Register to view this content.
Thank you! But if enter or paste one word or one number, it gives an error: "Runtime '9': Subscript out of range". It is necessary that one character can be entered, but without conversion. If remove values from a column, then the error also occurs: "Runtime '9': subscript out of range". Need to be able to delete values from cells.Copy and paste this macro into the worksheet code module. Do the following: right click the tab name for your sheet and click 'View Code'. Paste the macro into the empty code window that opens up. Close the code window to return to your sheet. Make an entry into column A and press the ENTER key.
Please Login or Register to view this content.
Attachment 795756
Last edited by moninah; 09-11-2022 at 11:47 AM.
I based the macro on the data you posted in your original post assuming that the format for all cells would always be the same. It would be easier to help and test possible solutions if you could attach a copy of your file that contains the type of data that is possible to be entered in column A. See the yellow banner at the top of this page for instructions to attach a file.
Can enter and paste everything, but not convert. Convert only (any number)m and (any number)M. Can delete and edit data in cells. Only this.
It would be helpful if you could post samples of data that show the different formats in which data can be entered. It is difficult to suggest a solution without knowing all the possibilities of what the data can look like.
@moninah
It is also a good idea to add the location in your profile.
Sometimes the result of the reply depends on the location.
Solved the problem with:Mumps1, Thank you very much for the macro.Please Login or Register to view this content.
Last edited by moninah; 09-12-2022 at 12:45 PM.
My pleasure.
Mumps1, How to make macro work with all cells of column A? So that can paste into several cells at a time and the data is converted. I need this in order to be able to convert multiple data at once.
Please post the code that is currently working for you.
Please Login or Register to view this content.
Try:
Please Login or Register to view this content.
Does not work. Error: "Run-time error '13': Type mismatch". Line: "v = Split(Target, " ")"Try:
Please Login or Register to view this content.
Last edited by moninah; 09-12-2022 at 01:35 PM.
Try:
Please Login or Register to view this content.
So the macro works with all cells of column A.Try:
Please Login or Register to view this content.
But now if enter or paste with capital "M":
it will be converted to:Please Login or Register to view this content.
Please Login or Register to view this content.
I forgot to include this line of code at the very top of the macro:
Please Login or Register to view this content.
This works great! Thanks a lot again!I forgot to include this line of code at the very top of the macro:
Please Login or Register to view this content.
You are very welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks