Macro help: moving specific cells based upon content

[Scheetsky]

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.

 

[Don Guillett]

One or many values to look for?
One or many hits per value per column?

 

[Scheetsky]

There would be one specific value per column and there would be multiple hits
in that column. Thanks Don

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.

 

[Don Guillett]

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
(e-mail address removed)

There would be one specific value per column and there would be multiple
hits
in that column. Thanks Don

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.

 

[Scheetsky via OfficeKB.com]

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

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]

 

[Scheetsky via OfficeKB.com]

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

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]

 

[Scheetsky via OfficeKB.com]

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

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]

 

[Don Guillett]

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
(e-mail address removed)

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

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.