![]() |
Macro help: moving specific cells based upon content
Hi all,
Is there a way to search a specific column for a value and then to move just those cells that have that value one cell to the right? So, if i get a hit on B64 can I have that cell cut and pasted into C64? Any help is appreciated. |
Macro help: moving specific cells based upon content
One or many values to look for? One or many hits per value per column? -- Don Guillett Microsoft MVP Excel SalesAid Software "Scheetsky" <u54508@uwe wrote in message news:9b94d51a7c141@uwe... Hi all, Is there a way to search a specific column for a value and then to move just those cells that have that value one cell to the right? So, if i get a hit on B64 can I have that cell cut and pasted into C64? Any help is appreciated. |
Macro help: moving specific cells based upon content
There would be one specific value per column and there would be multiple hits
in that column. Thanks Don Don Guillett wrote: One or many values to look for? One or many hits per value per column? Hi all, [quoted text clipped - 5 lines] Any help is appreciated. |
Macro help: moving specific cells based upon content
Look in the vba help index for FINDNEXT. If you THEN need more help, come
back or send me your file. -- Don Guillett Microsoft MVP Excel SalesAid Software "Scheetsky" <u54508@uwe wrote in message news:9b953b24af7a3@uwe... There would be one specific value per column and there would be multiple hits in that column. Thanks Don Don Guillett wrote: One or many values to look for? One or many hits per value per column? Hi all, [quoted text clipped - 5 lines] Any help is appreciated. |
Macro help: moving specific cells based upon content
I'm not a programmer, sorry. The amount of time to figure this is out for me
is the amount of time to do the task manually. Thank you though, when I have more time I'll refer back to this so see if I can figure it out, there will be uses for this down the road. Happy Friday Don Guillett wrote: Look in the vba help index for FINDNEXT. If you THEN need more help, come back or send me your file. There would be one specific value per column and there would be multiple hits [quoted text clipped - 8 lines] Any help is appreciated. -- Message posted via http://www.officekb.com |
Macro help: moving specific cells based upon content
I'm not a programmer, sorry. The amount of time to figure this is out for me
is the amount of time to do the task manually. Thank you though, when I have more time I'll refer back to this so see if I can figure it out, there will be uses for this down the road. Happy Friday Don Guillett wrote: Look in the vba help index for FINDNEXT. If you THEN need more help, come back or send me your file. There would be one specific value per column and there would be multiple hits [quoted text clipped - 8 lines] Any help is appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
Macro help: moving specific cells based upon content
I'm not a programmer, sorry. The amount of time to figure this is out for me
is the amount of time to do the task manually. Thank you though, when I have more time I'll refer back to this so see if I can figure it out, there will be uses for this down the road. Happy Friday Don Guillett wrote: Look in the vba help index for FINDNEXT. If you THEN need more help, come back or send me your file. There would be one specific value per column and there would be multiple hits [quoted text clipped - 8 lines] Any help is appreciated. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...tions/200909/1 |
Macro help: moving specific cells based upon content
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples. -- Don Guillett Microsoft MVP Excel SalesAid Software "Scheetsky via OfficeKB.com" <u54508@uwe wrote in message news:9b9d4605caa10@uwe... I'm not a programmer, sorry. The amount of time to figure this is out for me is the amount of time to do the task manually. Thank you though, when I have more time I'll refer back to this so see if I can figure it out, there will be uses for this down the road. Happy Friday Don Guillett wrote: Look in the vba help index for FINDNEXT. If you THEN need more help, come back or send me your file. There would be one specific value per column and there would be multiple hits [quoted text clipped - 8 lines] Any help is appreciated. -- Message posted via http://www.officekb.com |
All times are GMT +1. The time now is 03:39 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com