| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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. |
|
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| how to find and replace content of a specific cell based on its ad | Excel Discussion (Misc queries) | |||
| Moving data based on specific field | Excel Worksheet Functions | |||
| Moving Between Specific Cells | Excel Discussion (Misc queries) | |||
| Insert a variable dependant on content of specific cells | Excel Discussion (Misc queries) | |||
| Macro to highlight cells based on content | Excel Worksheet Functions | |||
Linear Mode
