Select multiple adjacent cells of multiple cells without selecting
 

Select multiple adjacent cells of multiple cells without selecting adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Thank you for your help.

Select multiple adjacent cells of multiple cells without selecting
 

Adjacent in this case, means?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sjsjsjsjsjs" wrote in message
...
Select multiple adjacent cells of multiple cells without selecting
adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Thank you for your help.

Select multiple adjacent cells of multiple cells without selec
 

Adjacent in this case, means?
some characters cells that's adjacent of A cells.

Thank you for your help.

"Don Guillett" wrote:

Adjacent in this case, means?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sjsjsjsjsjs" wrote in message
...
Select multiple adjacent cells of multiple cells without selecting
adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Thank you for your help.

.

Select multiple adjacent cells of multiple cells without selec
 

I am trying to select some characters cells that's adjacent of A cells
without selecting some characters cells one by one.

Thank you for your help.

"sjsjsjsjsjs" wrote:

Adjacent in this case, means?
some characters cells that's adjacent of A cells.

Thank you for your help.

"Don Guillett" wrote:

Adjacent in this case, means?
If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sjsjsjsjsjs" wrote in message
...
Select multiple adjacent cells of multiple cells without selecting
adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Thank you for your help.

.

Select multiple adjacent cells of multiple cells without selec
 

Examples or send your file with a COMPLETE explanation

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sjsjsjsjsjs" wrote in message
...
I am trying to select some characters cells that's adjacent of A cells
without selecting some characters cells one by one.

Thank you for your help.

"sjsjsjsjsjs" wrote:

Adjacent in this case, means?
some characters cells that's adjacent of A cells.

Thank you for your help.

"Don Guillett" wrote:

Adjacent in this case, means?
If desired, send your file to my address below. I will only look
if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"sjsjsjsjsjs" wrote in message
...
Select multiple adjacent cells of multiple cells without selecting
adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting
adjacent
cells one by one.

Thank you for your help.

.

Select multiple adjacent cells of multiple cells without selecting
 

Do you want to select or just return the values if they match "A"

=IF(B1="A",A1,"none") entered in C1 and copied down.

Maybe??


Gord Dibben MS Excel MVP

On Fri, 18 Dec 2009 11:33:01 -0800, sjsjsjsjsjs
wrote:

Select multiple adjacent cells of multiple cells without selecting adjacent
cells one by one. those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Thank you for your help.

Select multiple adjacent cells of multiple cells without selec
 

those cells looks like;
|Column A |Column B|
|random characters | Y |
|sjsjsjsjskkskskskk | Z |
|wtwuwuwuuusisis | Y |
|wuuuuusiwuwuwiu| Y |
|euuuuuuuuuuuuuuu| Z |
..
..
..
..
continue...
I am trying to select A cells that's adjacent of Y cells without selecting A
cells one by one, then
copy selected cells to Column C, and
keep rows of selected cells.
those cells will look like;
|Column C |
|random characters |
| |
|wtwuwuwuuusisis |
|wuuuuusiwuwuwiu|
| |
..
..
..
..
continue...

Thank you for your help.

cells one by one.


those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting adjacent
cells one by one.

Select multiple adjacent cells of multiple cells without selec
 

You do know you have some answers to this question over in the
worksheet.functions newsgroup where you also posted this question. For
future questions... please post them in one newsgroup only and then check
back to see the answers you get there.

--
Rick (MVP - Excel)


"sjsjsjsjsjsjs" wrote in message
...
those cells looks like;
|Column A |Column B|
|random characters | Y |
|sjsjsjsjskkskskskk | Z |
|wtwuwuwuuusisis | Y |
|wuuuuusiwuwuwiu| Y |
|euuuuuuuuuuuuuuu| Z |
.
.
.
.
continue...
I am trying to select A cells that's adjacent of Y cells without selecting
A
cells one by one, then
copy selected cells to Column C, and
keep rows of selected cells.
those cells will look like;
|Column C |
|random characters |
| |
|wtwuwuwuuusisis |
|wuuuuusiwuwuwiu|
| |
.
.
.
.
continue...

Thank you for your help.

cells one by one.


those cells looks like;
|adjacent cells |cells|
|some characters | A |
|some characters | B |
|some characters | A |
|some characters | A |
|some characters | B |
I am trying to select adjacent cells of A cells without selecting
adjacent
cells one by one.

Select multiple adjacent cells of multiple cells without selec
 

Thank you for your help.
Macro really worked.
re you working for Microsoft or have ou ever worked for Microsoft?
Did Microsoft ever publis A Super Input Routine?
my search in microsoft websites doesn't show any of information about book.

Thank you for your help.

Select multiple adjacent cells of multiple cells without selec
 

I'm glad the macro worked out for you. Something you may want to consider
with it. As it stands now, If you run the macro twice, it will leave its
previous display in Column C and just add the new items to them... if you
would rather get rid of the previous runs information so you can just see
the current run's items, add this line to the macro immediately after the
first If statement...

Columns("C").ClearContents

That will clear out Column C before displaying the new run's information.

--
Rick (MVP - Excel)


"sjsjsjsjsjsjschanged"
wrote in message ...
Thank you for your help.
Macro really worked.
re you working for Microsoft or have ou ever worked for Microsoft?
Did Microsoft ever publis A Super Input Routine?
my search in microsoft websites doesn't show any of information about
book.

Thank you for your help.

Select multiple adjacent cells of multiple cells without selec
 

Sorry, I forgot to respond to the second part of your question. No, I don't
work for Microsoft, nor did I ever work for them. I, like the other regulars
here on the newsgroups volunteer our own personal time to answer the
questions that get posted here. We hope that whatever past experiences we
have had with Excel will prove to be useful in addressing those questions.
As for the MVP designation you will see on some of the volunteers here,
perhaps this link will help you out in understanding the our relationship
with Microsoft...

http://mvp.support.microsoft.com/

As to your last question, exactly what would you expect to be in a "Super
Input Routine"?

--
Rick (MVP - Excel)


"sjsjsjsjsjsjschanged"
wrote in message ...
Thank you for your help.
Macro really worked.
re you working for Microsoft or have ou ever worked for Microsoft?
Did Microsoft ever publis A Super Input Routine?
my search in microsoft websites doesn't show any of information about
book.

Thank you for your help.

Select multiple adjacent cells of multiple cells without selec
 

input routine for Excel, and publisher of book and seller of book.

Thank you for your help.

"Rick Rothstein" wrote:

As to your last question, exactly what would you expect to be in a "Super
Input Routine"?