| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. . |
|
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. . |
|
#6
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#7
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#8
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#9
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#10
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#11
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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. |
|
#12
Posted to microsoft.public.excel.newusers
|
|||
|
|||
|
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"? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selecting multiple cells, I can't see the cells highlighted | Excel Discussion (Misc queries) | |||
| How to change shade of cells when selecting multiple cells | Excel Discussion (Misc queries) | |||
| Countif across multiple non-adjacent cells | Excel Discussion (Misc queries) | |||
| By selecting cells adjacent to cells tally sheet | Excel Worksheet Functions | |||
| Ctrl+V pasting to multiple non-adjacent cells | Excel Discussion (Misc queries) | |||
Linear Mode
