Hi guys,
I'd appreciate if you can help me with the following issue.
I have a Column (A). In that column I have about 10000 cells with different data. Some of the cells contain specific text (not the only text in the cell) which I want to automatically have cut and paste in the neighbour cell. So let's say I have the text "pridon1" in cell A33, I want this text cut from the cell A33 and have it pasted into B33. Can you help me please?
The VBA Instr function will do that..... If you want me to write you a quick looping sub you'll have to upload your workbook.
Elegant Simplicity............. Not Always
Hi Andy, here is the sample attachment, thank you so much
I'll get right on it ........... BRB
Attachment 224872
The above should be what you are looking for
Hi Andy,
I'm a bit confused. So what I need is to move the "(2 per box)" for example into a new cell. Can you give me the script that would do that?
1.Click the grey button
2.Type "2 per box"
3.Click OK
and ensure macro's are enabled..
Oh I see, yes it works now, thanks
One more thing - it moves the entire text from the cell, however I need the specific text moved, what do I need to change?
Do you also need the specific text deleting from column A ?
yes yes, that's the idea
Replace the existing code in module 1 with this.
Please Login or Register to view this content.
Andy, you are the best, thank you!
Anytime mate
Or do you mean like this?
Last edited by jindon; 04-09-2013 at 10:02 AM.
Andy, the document you have attached, I can not download it anymore, could you reattach it please?Originally Posted by AndyLitch
sample1 (1).xlsm
There you go bud.. Make sure you save it cos it's only available for a fixed period.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks