Hai,
Here is a method to solve your issue.
Please check with the below workbook and let me know if you have any
other query.
http://groups.google.com/group/excel-macros/web/Smart_LookUp.xls?hl=en
Happy New Year 2009.
Maddy
LIFE = IF(Rand()*100<50,"P
How do you want to return the results?
It's a simple matter to create a loop that looks through column A and
for matching values, add the column B data to sheet 1.
Or. you could use filters on sheet 2,
activate the filter on column A, then copy/paste column B.
let me know what approach you'd lik
You can get it done with the help of pivot table.
Please refer to our earlier thread in the below link:
http://groups.google.com/group/excel-macros/t/abb778320b48ea8a?hl=en
Still, if you have any queries, please post them.
Happy New Year 2009 !!!
Maddy
On Jan 1, 2:41 pm, Galway wrote:
>
I am working from Excel 2007. I am being sent some files to work with
that were created and still being used in Excel 2002. They use
features from the add-in xlodbc.xla. When I try to open the file, I
get an error message about not being able to use xlodbc.xla and then
excel crashes.
Has anybo
Hi everyone,
I need some vba code to download a specific file from a specific
internet location to a specific place on my hard drive. I don't
really want any prompts or message boxes and definitely don't want the
user to have to pick where the file will be saved.
What I mean is that I want it t
Dear All,
This is not right forum to discuss these issues. Any discussion of Excel Macros
is welcome.
Sachin
- Original Message -
From: Ahmedhonest
To: mohsin ali ; excel-macros@googlegroups.com ; shafi...@gmail.com ;
MOHAMMED SAYEED ; Siraj KBS Bank
Sent: Wednesday, December
Hello everyone.
I'm thinking about to place an AutoShape on the certain word which is
a part of long text in some cell
to make the word emphasized surrounding it with line.
So I'm looking for the following information.
1. Way to measure the length of the text in certain unit of coordinates
(cm
Hello everyone.
I'm thinking about to place an AutoShape on the certain word which is
a part of long text in some cell
to make the word emphasized surrounding it with line.
So I'm looking for the following information.
1. Way to measure the length of the text in certain unit of coordinates
(cm
I need a macro. I have two columns. One with various text (column A,
worksheet 2). One with a unique text (column B, worksheet 2). I need a
macro that will search column A and give me the text in column B. Then
Find Next. The same search can find multiple choices from column B. I
want all my Colum
I am working from Excel 2007. However, I need to update files that
are from Excel 2002 and that use the sql.request function of the
XLODBC.xla.
When I open the file, I get an error about not being able to use the
features of XLODBC.xla.
Has anybody else run into this and resolved it? If so, ho
Hi
could Explain how you did??
On Sun, Dec 28, 2008 at 8:26 PM, Mr. Pardeshi Somnath wrote:
> Hi...
> Please Try Sheet Reply
> Is This fine?
>
>
>
> Somnath C Pardeshi
> +91 9221700131
>
>
>
> --
>
> Date: Sat, 27 Dec 2008 13:30:00 +0530
> From: kona...@gmai
11 matches
Mail list logo
