Hi
I am a new user of excel and have this problem:
I have created a database in excel by entering codes. i.e. I entered
Male as 1 and Female as 2.
I woukd like to know if there is a command that I can use to convert
the codes back to the words i.e to male and female
Please, I tried but did not
*See below attached pic.**mentioned few steps, that would help u.
*
[image: 1.png]
Harmeet Singh
Sent via BlackBerry Wireless
On Mon, Sep 14, 2009 at 1:15 PM, Shimmy morur...@gmail.com wrote:
Hi
I am a new user of excel and have this problem:
I have created a database in excel
Hi All,
@Satish -
You are just near the solution, which means that the information/
formulas contained in your workbook are not right. I asked for the
probabilities not the Sum. Try to modify your formulae and you will
achieve the perfect solution. Your try is appreciable. Just, take one
more
Hi Bunty,
Take a look to the following code, might help. It opens each .xls in
the same path where this file resides, and copy-paste predefined rows.
Regards,
Chechu
Sub Macro1()
Dim MyFile, MyPath, MyName, ThisFile, Location, PathFileTemp, Fila,
ThisSheet
'On Error GoTo ErrorHandler
Dear Shimmy,
Please look at attachment if you problem will be solved.
Thanks regards,
|| Mudassar Ramzan | WLL -- 061- 814-3999 | Cell -- 0321 7325277 |E-Mail:
johnplaye...@gmail.com | Web: http://johnplayer78.sitesled.com ||
This e-mail contains PRIVILEGED AND CONFIDENTIAL
Hi Umesh,
Try below link. Thanks.
Can't access your account?
Dear Prashanth,
Append your formula like this. This should help.
=IF(OR(D16=Summary!$C$3,C16=AAA, C16=BBB, C16=CCC),High,IF
(D16Summary!$C$3,Medium,Low))
Regards,
V Ravi Kumar
On Sep 14, 10:18 am, Prashanth Banneni praba...@gmail.com wrote:
Hi All,
I have a query, which needs to be
Hello everyone-
Thank you for allowing me to join this group. When I joined, I sent a
post about VBA from the website. This was several days ago, and I
have not seen the post appear yet. Was I supposed to wait X days
before posting?
I posted a VBA routine that seemed to be doing nothing-
I've tried to write this code a hundred different ways and nothing
seems to work. Please help me.
I want to select 3 non-contiguous columns (C,D G) from row 10 to the
last row used (before row 200). I'm using column J to find the last
row used.
I have these variables declared as strings and
The problem is that you're not telling
VBA to use the VALUE of the variables,
you're telling it to use the CHARACTERS
in the NAME...
what you need to do is BUILD the range like this:
Range(C10: rCLR , D10: rDLR , G10: rGLR).Select
that says to use the literal string C10: and add the
I missed your original post, but I went out and found it:
Get value of AK40, call it Supply
Select case Supply
Case 101:
DoThis(C10),Green,White
DoThis(J10),Green,White
DoThis(AB10),Green,White
Case 201
Paul,
Thank you! I will try that.
As I said, I tried a LOT of different ways to write it including:
Range(C10: rCLR , D10: rDLR , G10: rGLR).Select.
I knew that I had to build it as you suggested but I never thought the
, would need to be inside the quotes.
On Sep 14, 2:20 pm, Paul
Thank you. yes, I was saying AK40 was Supply I couldn't remember
AK40 and just named it. It never once crossed my mind that it was
checking the word Supply instead of the cell AK40. In cell AK40, I
have a list of values it may be- 101,
201,202,203,301,302,401,402,403,403, etc. I have
Hi,
I have a template in PPT that I copy charts from Excel every month. I
am trying to create a macro that will do this automatically for me.
Unfortunately, I am unable to make the macro change slides. I am able
to copy and paste the chart, but then cannot move onto the next slide.
I also do not
14 matches
Mail list logo