Turn 3 columns into 1

--____TRBQFUNOYCJHJLNRIYFH____
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: base64
Content-Disposition: inline; modification-date="Wed, 13 May 2008 10:57:51
	-0500"

SSBoYXZlIDMgY29sdW1ucyB0aGF0IEkgd291bGQgbGlrZSB0byBiZSBtZXJnZWQgaW4gdG8gb25l
LiBGb3IgZXhhbXBsZToNCg0KYjI9MyBjMj00IGQyPTYsIGFuZCBzbyBlMiA9IDMNCiAgICAgICAg
ICAgICAgICAgICAgICAgICAgICAgICAgICAgICBlMyA9IDQNCiAgICAgICAgICAgICAgICAgICAg
ICAgICAgICAgICAgICAgICBlNCA9IDYNCg0KVGhhbmtzIGZvciBhbnlvbmUgdGhhdCBjYW4gaGVs
cA==
--____TRBQFUNOYCJHJLNRIYFH____
Content-Type: multipart/related; boundary="____POUSEHRJORNTNXTVHMWN____"


--____POUSEHRJORNTNXTVHMWN____
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: base64
Content-Disposition: inline; modification-date="Wed, 13 May 2008 10:57:51
	-0500"

PEhUTUw+PEhFQUQ+DQo8TUVUQSBodHRwLWVxdWl2PUNvbnRlbnQtVHlwZSBjb250ZW50PSJ0ZXh0
L2h0bWw7IGNoYXJzZXQ9dXRmLTgiPg0KPE1FVEEgY29udGVudD0iTVNIVE1MIDYuMDAuMjkwMC4z
MzE0IiBuYW1lPUdFTkVSQVRPUj48L0hFQUQ+DQo8Qk9EWSBzdHlsZT0iTUFSR0lOOiA0cHggNHB4
IDFweDsgRk9OVDogMTBwdCBUYWhvbWEiPg0KPERJVj5JIGhhdmUgMyBjb2x1bW5zIHRoYXQgSSB3
b3VsZCBsaWtlIHRvIGJlIG1lcmdlZCBpbiB0byBvbmUuIEZvciBleGFtcGxlOjwvRElWPg0KPERJ
Vj4mbmJzcDs8L0RJVj4NCjxESVY+YjI9MyBjMj00IGQyPTYsIGFuZCBzbyBlMiA9IDM8L0RJVj4N
CjxESVY+Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7
Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5i
c3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7Jm5ic3A7IGUzID0g
NDwvRElWPg0KPERJVj4mbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz
cDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsm
bmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJzcDsmbmJz
cDsmbmJzcDtlNCA9IDY8L0RJVj4NCjxESVY+Jm5ic3A7PC9ESVY+DQo8RElWPlRoYW5rcyBmb3Ig
YW55b25lIHRoYXQgY2FuIGhlbHA8L0RJVj48L0JPRFk+PC9IVE1MPg==
--____POUSEHRJORNTNXTVHMWN____--

--____TRBQFUNOYCJHJLNRIYFH____--
0
dstricklen (11)
5/13/2008 8:57:51 PM
excel 39879 articles. 2 followers. Follow

4 Replies
784 Views

Similar Articles

[PageSpeed] 41

Copy and paste special and select transpose


-- 


Regards,


Peo Sjoblom



"David Stricklen" <dstricklen@kumc.edu> wrote in message 
news:4829BA7F.8C8A.004C.0@kumc.edu...
>I have 3 columns that I would like to be merged in to one. For example:
>
> b2=3 c2=4 d2=6, and so e2 = 3
>                                     e3 = 4
>                                     e4 = 6
>
> Thanks for anyone that can help


--------------------------------------------------------------------------------


>I have 3 columns that I would like to be merged in to one. For example:
>
> b2=3 c2=4 d2=6, and so e2 = 3
>                                     e3 = 4
>                                     e4 = 6
>
> Thanks for anyone that can help 


0
terre081 (3244)
5/13/2008 9:33:18 PM
Your example makes absolutely no sense, try again.

David Stricklen wrote:

> I have 3 columns that I would like to be merged in to one. For example:
>  
> b2=3 c2=4 d2=6, and so e2 = 3
>                                      e3 = 4
>                                      e4 = 6
>  
> Thanks for anyone that can help

0
birelan (531)
5/13/2008 9:35:20 PM
This is a multi-part message in MIME format.

------=_NextPart_000_0356_01C8B550.D2E7D900
Content-Type: text/plain;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

Shamelessly stealing from RB Smissert in the Programming group try:

Sub TurnIt()
    Dim LastR As Long
    Dim rRow As Long
    Dim cCol As Long
    Dim pRow As Long
    Dim dData As Variant
   =20
    LastR =3D Cells(Rows.Count, 2).End(xlUp).Row
   =20
    dData =3D Range(Cells(2, 2), Cells(LastR, 4))
    pRow =3D 1
    For rRow =3D 1 To LastR - 1
        For cCol =3D 1 To 3
            pRow =3D pRow + 1
            Cells(pRow, 5).Value =3D dData(rRow, cCol)
        Next cCol
    Next rRow
End Sub

--=20
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings

sandymann2@mailinator.com
Replace @mailinator.com with @tiscali.co.uk


  "David Stricklen" <dstricklen@kumc.edu> wrote in message =
news:4829C568.8C8A.004C.0@kumc.edu...
  Ok, it's a bit more complex than that. I should have mentioned that =
there is more than one row of info

  B2=3D5 c2=3D5 d2=3D10
  b3=3D8 c3=3D9 d3=3D11
  b4=3D9 c4=3D11 d4=3D500, and then e2 would =3D 5
                                               e3=3D5
                                               e4=3D10
                                               e5=3D8
                                               e6=3D9
                                               e7=3D11
                                               e8=3D9, and so on
                                          =20

  >>> David Stricklen<dstricklen@kumc.edu> 5/13/2008 3:57 PM >>>

  I have 3 columns that I would like to be merged in to one. For =
example:

  b2=3D3 c2=3D4 d2=3D6, and so e2 =3D 3
                                       e3 =3D 4
                                       e4 =3D 6

  Thanks for anyone that can help
------=_NextPart_000_0356_01C8B550.D2E7D900
Content-Type: text/html;
	charset="Utf-8"
Content-Transfer-Encoding: quoted-printable

=EF=BB=BF<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=3DContent-Type content=3D"text/html; charset=3Dutf-8">
<META content=3D"MSHTML 6.00.6000.16608" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY style=3D"MARGIN: 4px 4px 1px; FONT: 10pt Tahoma" =
bgColor=3D#ffffff>
<DIV><FONT face=3DArial>Shamelessly stealing from RB Smissert in the =
Programming=20
group try:</FONT></DIV>
<DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
<DIV><FONT face=3DArial>Sub TurnIt()<BR>&nbsp;&nbsp;&nbsp; Dim LastR As=20
Long<BR>&nbsp;&nbsp;&nbsp; Dim rRow As Long<BR>&nbsp;&nbsp;&nbsp; Dim =
cCol As=20
Long<BR>&nbsp;&nbsp;&nbsp; Dim pRow As Long<BR>&nbsp;&nbsp;&nbsp; Dim =
dData As=20
Variant<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; LastR =3D =
Cells(Rows.Count,=20
2).End(xlUp).Row<BR>&nbsp;&nbsp;&nbsp; <BR>&nbsp;&nbsp;&nbsp; dData =3D=20
Range(Cells(2, 2), Cells(LastR, 4))<BR>&nbsp;&nbsp;&nbsp; pRow =3D=20
1<BR>&nbsp;&nbsp;&nbsp; For rRow =3D 1 To LastR -=20
1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; For cCol =3D 1 To=20
3<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; =
pRow =3D=20
pRow + =
1<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
Cells(pRow, 5).Value =3D dData(rRow,=20
cCol)<BR>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; Next=20
cCol<BR>&nbsp;&nbsp;&nbsp; Next rRow<BR>End Sub</FONT></DIV>
<DIV><BR>-- <BR>HTH</DIV>
<DIV>&nbsp;</DIV>
<DIV>Sandy<BR>In Perth, the ancient capital of Scotland<BR>and the =
crowning=20
place of kings</DIV>
<DIV>&nbsp;</DIV>
<DIV><A=20
href=3D"mailto:sandymann2@mailinator.com">sandymann2@mailinator.com</A><B=
R>Replace=20
@mailinator.com with @tiscali.co.uk</DIV>
<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<BLOCKQUOTE dir=3Dltr=20
style=3D"PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; =
BORDER-LEFT: #000000 2px solid; MARGIN-RIGHT: 0px">
  <DIV><FONT face=3DArial>"David Stricklen" &lt;</FONT><A=20
  href=3D"mailto:dstricklen@kumc.edu"><FONT=20
  face=3DArial>dstricklen@kumc.edu</FONT></A><FONT face=3DArial>&gt; =
wrote in=20
  message </FONT><A href=3D"news:4829C568.8C8A.004C.0@kumc.edu"><FONT=20
  face=3DArial>news:4829C568.8C8A.004C.0@kumc.edu</FONT></A><FONT=20
  face=3DArial>...</FONT></DIV>
  <DIV><FONT face=3DArial>Ok, it's a bit more complex than that. I =
should have=20
  mentioned that there is more than one row of info</FONT></DIV>
  <DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial>B2=3D5 c2=3D5 d2=3D10</FONT></DIV>
  <DIV><FONT face=3DArial>b3=3D8 c3=3D9 d3=3D11</FONT></DIV>
  <DIV><FONT face=3DArial>b4=3D9 c4=3D11 d4=3D500, and then e2 would =3D =
5</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;e3=3D5</F=
ONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  e4=3D10</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  e5=3D8</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  e6=3D9</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  e7=3D11</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  e8=3D9, and so on</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  &nbsp;<BR><BR>&gt;&gt;&gt; David Stricklen&lt;dstricklen@kumc.edu&gt;=20
  5/13/2008 3:57 PM &gt;&gt;&gt;<BR></FONT></DIV>
  <DIV><FONT face=3DArial>I have 3 columns that I would like to be =
merged in to=20
  one. For example:</FONT></DIV>
  <DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial>b2=3D3 c2=3D4 d2=3D6, and so e2 =3D =
3</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;=20
  e3 =3D 4</FONT></DIV>
  <DIV><FONT=20
  =
face=3DArial>&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;e4=20
  =3D 6</FONT></DIV>
  <DIV><FONT face=3DArial></FONT>&nbsp;</DIV>
  <DIV><FONT face=3DArial>Thanks for anyone that can=20
help</FONT></DIV></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_0356_01C8B550.D2E7D900--

0
sandymann2 (1054)
5/13/2008 10:26:49 PM
Play with this entered in E2 and copied to E4

=INDEX($2:$2,ROWS($2:3))


Gord Dibben  MS Excel MVP


On Tue, 13 May 2008 15:57:51 -0500, "David Stricklen" <dstricklen@kumc.edu>
wrote:

>I have 3 columns that I would like to be merged in to one. For example:
>
>b2=3 c2=4 d2=6, and so e2 = 3
>                                     e3 = 4
>                                     e4 = 6
>
>Thanks for anyone that can help

0
Gord
5/13/2008 10:45:54 PM
Reply:

Similar Artilces:

reading pane keeps turning on and preview pane keeps turning off
I've been using outlook 2007 for about 6 months and all has been ok until now. My normal view is to have the reading pane turned off and the preview pane turned on. however, now things changed all of a sudden. now when ever I go to the inbox the reading pane is turned on and the preview pane is turned off. So I go to the view menu and reset the view to what it should be. if I click on any other folder such as sent items and back to the inbox, its back to reading pane on and preview pane off. This is the same behavior for all folders. any ideas how to resolve this? Thanks. -- ...

Rounding #3
How do I format a cell so a calcuated # is a true whole # (ie 4) for additional formulas, not just appearing as a whole # (4.43560 appearing as 4)? Formatting doesn't change the value stored in a cell, unless you have checked the Tools/Options/Calculation Precisions as displayed checkbox (which applies to the entire workbook). You can instead wrap your calculation in the ROUND() function: =ROUND(<your existing formula>,0) In article <603DF5C7-6D8F-4163-8A03-1794FFED0ACD@microsoft.com>, "jw" <anonymous@discussions.microsoft.com> wrote: > How d...

Active Directy Rename and CRM 3.0
We have an existing W2K3 domain that was set up by a former IT employee that unfortunately didn't know AD from the toilet. We are looking at performing a rename to our domain/exchange 2003 structure using the microsoft tools. i was wondering if there are considerations that would need to be taken into affect for a CRM 3 install that is on the same domain. This may be something that no one has tried before but I thought I'd through it out there and see. Hello Mike because of the nature of what you are trying to do I would open a support ticket. Even though server 2003 allows ...

3 graphs in 1?
I want to graph: sales, % increase, and sales per square foot over time (5 years. How do I show 3 different sets of information on 1 graph? So far I have sales as a bar, % as a line graph on top but I need sales psf in the background. The axes would need very different numbers. thanks! Take a look at Jon's article on panel charts with different axis. It's a bit of work, but it results in chart that does what you ask, plot 3 different axis over time. http://peltiertech.com/Excel/ChartsHowTo/PanelUnevenScales.html -- Best Regards, Luke M *Remember to click "yes" if thi...

Marketing in CRM 3.0
I am loking for a full blown marketing add-on to CRM 3.0... any suggestions? Hi MW, Microsoft CRM 3.0 ships with a Marketing Module that has campaigns, quick campains and related features. What is the functionality you are looking for? -- Manisha Powar (Madhusudanan) Program Manager Microsoft Dynamics - CRM This posting is provided "AS IS" with no warranties, and confers no rights. You assume all risk for your use. � 2005 Microsoft Corporation. All rights reserved. "mw" <mike.r.weiss@gmail.com> wrote in message news:1139506288.684981.247840@g44g2000cwa.googl...

Backup Exchange Server #3
Hi, I am new to Exchange administration. So please be gentle in reply... Here is the Question: My company currently has 1 exchange server. Recently it went down and we did not have emails for almost 3 days before I could figure out a way to get the database back (considering that there was no backup as it was failing). Now it is all working perfectly well. My boss now wants me to put in a secondary exchange server so that incase the first one fails it should automatically switch over to the second one and there should be no down time. My company is based on revenue from orders coming t...

Column Headers showing numbers
Hello there, My Excel spreadsheets are opening up with numbers at the top not letters. I'm sure I must have clicked something! Thank you in advance Julie Hi Julie, Tools | Options | General Tab | Uncheck R1C1 Reference Style --- Regards, Norman "Julie" <anonymous@discussions.microsoft.com> wrote in message news:310801c4b04f$ea2980f0$a301280a@phx.gbl... > Hello there, > > My Excel spreadsheets are opening up with numbers at the > top not letters. I'm sure I must have clicked something! > > Thank you in advance > > Julie > > ...

How do you turn off autoformatting?
I am making a spreadsheet that is essentially a record. In one of the cells, I am entering the old/new values for something as 4/80, which Excel instantly turns into April-80. I can format the the cell back to General, but the number that results is not 4/80. And if I go in and reset it to 4/80 again, the autoformatting kicks in again and the whole process starts over. While there are plenty of ways I could work around this, from changing the way I enter the data on up, it has become a sort of matter of honor now. How the heck do I stop Excel from overriding everything I enter? -- nickt --...

thread #3
how can ia crearte a new Cdialog runing under new thread mido1971 wrote: > how can ia crearte a new Cdialog runing under new thread mido: It is really not a good idea to have GUI components in a secondary thread. Just use a worker thread, or a window-less UI thread. If you have a CDialog-derived class, you can have individual methods run in the secondary thread, but they should only update the GUI using PostMesage() or SendMessage(). David Wilkinson To add to David's advice (good as usual) you can send a message to the UI thread that tells it to pop up the dialog for you wi...

Help with searching a column
I am having some trouble searching an entire column to see if a value is in the column. I've tried =IF(ISNUMBER(SEARCH(A1,K:K)),"TRUE","FALSE") - But it doesn't seem to be working. It only works if the A1 is in every cell of K. I have two columns, the first I have a list of values each on its own row. column A 1. CSS-PB-350 2. CSS-PB-122 3. CSS-PB-100 The second contains multiple values in each cell. Column B 1. CSS-PB-350, CSS-PB-111 2. CSS-PB-100, CSS-PB-091 3. CSS-PB-101, CSS-PB-021, CS-PB-234 So I would want to find that CSS-PB-350, CSS-PB-100 is in column B ...

how to turn off automatic format in Excel?
Hi Excel automatically change the first character in a cell to be uppercase. I just want lowercase. How can I turn off this function? Thanks Ngoc Hi Go to Tools / Autocorrect and uncheck Capitalize first letter of sentence. Andy. "ngoc" <linh@chello.no> wrote in message news:BOKNb.271$O41.819@amstwist00... > Hi > Excel automatically change the first character in a cell to be > uppercase. I just want lowercase. How can I turn off this function? > Thanks > Ngoc > ...

unable to send to one domain, telnet to and get 550 5.7.1 unable to relay for when i do RCPT TO:
I have no problems sending out anywhere but this one domain. Running SBS 2003 w/ Exchange 2003. users have gotton it back with The e-mail system was unable to deliver the message, but did not report a specific reason. Check the address and try again. If it still fails, contact your system administrator. <mydomain.com #4.0.0 smtp;451 Please try again> and There was a SMTP communication problem with the recipient's email server. Please contact your system administrator. <mydomain.com #5.5.0 smtp;550 Contains .gif file (blacklisted)> I t...

Can not Delete emails #3
I have outlook 2000 premium and I have a problem trying to delete emails from my inbox. My highwater mark file I believe is corrupted and I am getting repeated emails. Everytime I try to delete the extra emails I get this error message. The messaging interface has returned an unknown error. If the problem persits restart outlook. I have tried to restart but I get the same message everytime. Please advise of possible solution. What is the size of your pst-file? Have you checked it for errors already with scanpst.exe? -- Robert Sparnaaij [MVP-Outlook] www.howto-outlook.com Tips ...

Difficult function question for columns
I would like the create a column that performs the following function: [If column A=1, then display number in cell B10; If Column A=2, then display number in cell B11, If column A=3; then display number in cell B12] If it is of any importance, in the above example B10:12 have a =SUMIF/COUNTIF function in them. Thanks in advance. AAA1986 wrote: > I would like the create a column that performs the following function: > > [If column A=1, then display number in cell B10; If Column A=2, then display > number in cell B11, If column A=3; then display number in cell B1...

Drop Down Box #3
There is a drop down box that can be inserted in a spreadsheet that will go to a second sheet, and will show a listing of names and allow you to pick the exact name on the second sheet and show it on the first sheet. Can anyone tell me how to get this drop down box? Thanks. You can use Data>Validation, and refer to a named range on the second sheet. There are some instructions here: http://www.contextures.com/xlDataVal01.html harefeld wrote: > There is a drop down box that can be inserted in a > spreadsheet that will go to a second sheet, and will show > a listing ...

How do I stop bullet letter (a, b, c) from turning greek?
When I create a document in which I have used letters for bulletted lists (ie, a), b), c) etc), when I print or reopen it, the letters have changed to Greek characters alpha, beta etc. How can I stop this from happening? Thanks very much. Wow, I cannot duplicate this in any version of Publisher. Maybe you are using a different type font. -- Mary Sauer MSFT MVP http://office.microsoft.com/ http://msauer.mvps.org/ news://msnews.microsoft.com "allythegeek" <allythegeek@discussions.microsoft.com> wrote in message news:C3FD4415-6A6E-4EA1-97BD-0FF22ADFBB5A@microsoft.com... &...

Exchane E-TUrn Configuration
Hi. Can anyone please point me in the direction of a document that details the configuration of two exchange servers in different active directory domains where one must receive mails for a specific domain and park them and the other dials-up every hour and retrieves these mails? I believe I have to use E-turn for this? Thanks you ...

Preview Pane turns itself back on
I've asked everyone to disable preview pane and I have one user who tells me that everytime she disables it, it turns itself back on. She can disable it in the inbox, go to sent mail folder, return to inbox and it's back on. Help! ------------------------------------------------ ~~ Message posted from http://www.ExcelTip.com/ ~~View and post usenet messages directly from http://www.ExcelForum.com/ ...

Global Address List not updating #3
Hi, We have SBS 2003, and last week I added various Distribution Groups. I added them in the Active Directory and Users tool and they appear there and under Distribution Groups in the Server Managment. However in Outlook, non of these distribution groups appear in the Global Address List. Anyone have an idea what could be wrong or how to force the Global Address List to see the changes? Thanks! What clients are you using? Have you tried a rebuild in ESM? Nue "Lee" <noreply@infinityconcepts.net> wrote in message news:uOC0kHMXGHA.752@TK2MSFTNGP02.phx.gbl... > Hi...

is dotnet framework 4 compatiable with 3.5 app?
I currently uses 3.5 sp1 with vst 2008, no plan to go to 2010 for at least half a year. However, someone wanted a dump of the crash visual studio 2008 standard and I was not able to get the info they wanted. They suggest if I have dotnet 4 installed I can use another tool to make easier to get the dump they want Should I install .net 4 or that will give me a lot of trouble? On 15-05-2010 01:39, GS wrote: > I currently uses 3.5 sp1 with vst 2008, no plan to go to 2010 for at least > half a year. > > However, someone wanted a dump of the crash visual studio 2008 s...

How turn turn off warnings
I have a form which contains a button to run an update query. When clicking the button, it warns of running an update query to which one must respond "Yes". Then it informs you that it is going to update x number of records to which one must again respond "Yes". I have used macros in the past to turn off and then back on these warnings, but lately I have tried to write the code instead of macros. What would be the code for this? For reference, this is what I have right now: Private Sub UpdateMPS_Button_Click() On Error GoTo Err_UpdateMPS_Button_Click Dim stDocN...

1) Tabs not Transparent -- 2) Tabs Flicker ??
I just started using Tabs We use Access 2003. 1 - Tabs were not "transparent" on my form. I searched the newsgroup & discovered we had to set all XP desktops to "Windows Classic" Theme to fix this. Is there any way to return to XP Theme, or any other Theme, and have "transparent" Tabs? 2 - To kill the "flicker" issue for unbound Labels we had to convert them all to "Text Box's" and put the Label Text in the "Control Source" field and delete the Text Box Label... and set Properties for the Text Box to make it look like a Lab...

Comparing Data #3
Using Excel 2003 I have a list of names in Column A: Billy Susie Sally Fred I have another list of names in Column B: Billy Susie Johnny Sally Fred I want to compare the two columns of data to find names in Column B that are not in Column A. I cannot use the "match" function because one extra name in Column B (Johnny) throws off the side-by-side match of the two columns. Sally and Fred are both still in each column even though the extra name "Johnny" causes them to be offset from their match in Column A. Is there some other way of accomplishing this comparison?...

Charting 3 columns help
I am working on a staffing chart with three columns: Staffing Time Incident 6 3 1234 15 9 1234 I would like a graph to show the "Time" on the left the "Incident" on the bottom and Staffing in the chart I have racked my brain and have not figured out how, to make the chart work that is :o) Do I need to re-arrange the columns? a different way? Any help would be greatly appreciated. Steve In your brief sample, Incident has no variation. How do you want staffing to appear in the cha...

How to turn Off and On the pesky Office Assistant?
I want to try to live without the Office Assistant. How can I turn it off? If I find I must have it, how do I turn it back on? Thanks, tmb Right clck the office assistant and select Options. Options that are selected cause the office assistant to display, so the more options you deselect, the less times the little guy will show up. You will probably want to leave "REspond to F1 Key" selected (checked), so that you know you can always recall office assistant by pressing F1. Judy Freed "tmb" <topmailbox@yahoo.com> wrote in message news:MLfLb.219948$%h4.209554...