ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Macro help: moving specific cells based upon content (https://www.excelbanter.com/excel-worksheet-functions/241661-macro-help-moving-specific-cells-based-upon-content.html)

Scheetsky

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.


Don Guillett

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.



Scheetsky

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.



Don Guillett

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.




Scheetsky via 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 http://www.officekb.com


Scheetsky via 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


Scheetsky via 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


Don Guillett

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