It can be more simpler by using Vlookup function effectively.
Use 1 instead of 0, dont go for exact match
Example :
=VLOOKUP($B3, 'Lookup - Source'!$B$3:$H$30,7, 0)
Explaination
$B3 -->
Cell address containing Lookup value
'Look
Ayush Jain has sent you a link to a blog:
Dear group, Here is a wonderful tip: One can open a group of workbooks
in a single step by creating a workspace file. For more details and
steps visit http://bit.ly/asYC3b Share this tip with your friends
colleagues. Thanks. Best regards, Ayush Jain
Blog:
Hi Mahesh,
Thanks a lot, this is working fine now. i m great full to you.
could you pls give me one more help. i want to use check names option
in outlook. so what code should i use in this macro.
Thanks
Pankaj k Pandey
On 5/18/10, Mahesh parab wrote:
> Hi
>
> You can do below menti
I am getting the error: "Runtime error 1004 application-defined or
object-defined error" in the code provided below at this line of code:
.Cells(StartRow + n - 1, 5).Value = _
WordDoc.Comments(n).Scope
It is processing comments in a Word document and outputting them in
Hi
You can do below mention changes to add CC,BCC in mail
.To = Cells(cell.Row, "D").Value
.CC = Cells(cell.Row, "E").Value
.BCC = Cells(cell.Row, "F").Value
change the column name as per your requirement.
if you want to add yesterday's date in boday of mail then you can use below
mention code
.B
Hi Andy,
The solution in the following links should be a good point to start for
you..
http://www.ozgrid.com/forum/showthread.php?t=57799
http://www.mrexcel.com/forum/showthread.php?t=81826
Regards,
Aindril
On Mon, May 17, 2010 at 3:03 PM, Andy McGooner
wrote:
> Hi All,
>
> Apologies but i am
Dear All,
I would request to kindly help me in JAVA & Data
Structure Interview question. If do you have kindly forward me.
--
Thanks,
Prabhakar Thakur
New Delhi
+919953736776
--
--
Some important l
Dear Sir,
I am sending you a xcel file (plz see the attachment) which is a small
version of your huge data. In this file I have altered some column and
sheet, hope this will help you.
Regards,
Indrajit Snai
Kolkata
+91 9051755745
talk2indra...@gmail.com
Disclaimer:
This electronic message and an
Hi All,
Apologies but i am completely stumped on this one and all searches of
the forums etc have turned up nothing. Anyway I am putting together a
tracker that has a user interface to allow then to stick in some text,
which will automatically find the corresponding values from a base
data sheet a
