Dear Noorain,
Few days back you were referring a book to be written on vlookup.
If you have completed, could you please share the same with the Group?
Best Regards,
Amit
Disclaimer: This message and its attachments contain confidential information
and may also
*Thanks Rajan.*
*Now it's working fine.*
*Regards*
*Pravin Gunjal*
*
*
-- Forwarded message --
From: Rajan_Verma
Date: Mon, Oct 29, 2012 at 10:05 AM
Subject: RE: $$Excel-Macros$$ Re: VBA enabled sheet doesn't allow to protect
To: excel-macros@googlegroups.com
* *
*Try this*
*P
Hi Team,
Attached is the sheet where in i need some formula to get the below result.
1.) Create links so that if data is entered under an individual tab(eg for
Steve, Srivats, Anders, etc.) it is reflected in the All Up tab. We want
the All up tab to be the one place where you, me and anyone who
Dear Amit,
Currently i am out of station. Will share it shortly
Sent from BlackBerry® on Airtel
-Original Message-
From: "Amit Desai (MERU)"
Sender: excel-macros@googlegroups.com
Date: Mon, 29 Oct 2012 14:25:27
To:
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Vlo
Thanks a lot.
Best Regards,
Amit
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of noorain.ans...@gmail.com
Sent: 29 October 2012 17:07
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Vlookup Book
Dear Amit,
Currently i am out of station. W
Hi Pravin,
Please find attached files for both type (Auto and Workbook) of code.
regards,
Vijay
On 10/27/12, Pravin Gunjal wrote:
> *Hello Mr. Paul / Vijay / Prince,*
> *
> *
> *I have put macros in "ThisWorkbook" and checked but it's not working.*
>
> *Following is the macro.*
> *
> *
> *
> Pr
Your example seems to imply some assumptions.
Is the value in column 2 ALWAYS longer than the value in column 1?
What if the values are:
ABC1alpha and ABC1beta
what do you want in the third column?
When you said that you want to "extract the characters", does that mean
that you want the firs
Why not make your life easier and use ONE sheet for all wtih an extra
column for the name and then use filter to see the individuals as
desired
On Monday, October 29, 2012 6:22:14 AM UTC-5, Pooja S wrote:
>
>
> Hi Team,
>
> Attached is the sheet where in i need some formula to get the below
*Thanks a lot Mr Vijay and Mr Paul.*
-- Forwarded message --
From: Vijay Kr. Aggarwal
Date: Mon, Oct 29, 2012 at 5:36 PM
Subject: Re: $$Excel-Macros$$ The first sheet to be opened always in an
excel file
To: excel-macros@googlegroups.com
Hi Pravin,
Please find attached files fo
Exactly my point is the same but all sheets come from different circle
offices, i just need to check it manually and forward the same to boss.
Regards,
Lucky
On Mon, Oct 29, 2012 at 6:34 PM, Don Guillett wrote:
> Why not make your life easier and use ONE sheet for all wtih an extra
> column fo
Hello,
Could you please help on the below mail.
Thanks in advance.
Regards,
Chandru
On Fri, Oct 26, 2012 at 4:50 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:
> Hello,
>
> I am trying to send mail from Lotus Notes when I run the program. I am
> getting window saying(Pls check jpg
Hi Shrinivas,
Please check attached file. I hope this will answer your query.
regards,
Vijay
On 10/27/12, Shrinivas Shevde wrote:
> Dear all
>
>
>I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example
> .-: user want to find details of " H".then macro should ask the name a
Should do it in .xlsM workbook.
Sub getallSAS()
Dim i As Long
Dim cr As Double
Application.ScreenUpdating = False
ActiveSheet.UsedRange.Offset(1).Clear
On Error Resume Next
For i = 2 To Sheets.Count
With Sheets(i)
cr = Application.Match("contact", .Columns(1), 0)
.UsedRange.Offset(cr).Copy Cells(Ro
A macro is possible but it probably should be based on an advanced filter.
You need to give much more info on what you want.
On Saturday, October 27, 2012 3:14:51 AM UTC-5, shrini wrote:
>
> Dear all
>
>
> I WANT TO WRITE A MACRO WHICH WILL ASK USER TO DEFINE HIS SEARCH Example
> .-: us
Use it, hope it will fulfill your requirement
Sub CopyDesireCriteria()
Dim strCriteria As String, n As Integer, CellV
On Error Resume Next
Application.CutCopyMode = True
For Each CellV In ThisWorkbook.Sheets("Criteria").Range("A2:A4")
If CellV.Value = "" Then Exit For
If Le
Hi,
Please send me the code to click the browse button to choose file from the
local drive in a web page using excel vba macro.
Thanks,
Solairajan
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1)
I am not going to spend my time downloading your file untill I know what it
is you want. Please do us the courtesy of copying the steps from the file
and putting them in your post.
Also put a more relevant subject heading.
Regards
David Grugeon
On 30 October 2012 03:15, ankur kochar wrote:
>
I think you need to explain a bit more - what does ' local file in a web
page' mean? Is your file local (e.g. on C:\ drive or is it on the
internet? If it is in the cloud - what cloud application are you using?
If it is local why do you need to use the web to find it? Are you using
a google n
Good Morning Don,
Thanks a lot this stuff worked for me, but minute update is required in
this macro can we get the source tab name inserted in a column in the
summary sheet.
Regards,
Lucky S
On Mon, Oct 29, 2012 at 7:52 PM, Don Guillett wrote:
> Should do it in .xlsM workbook.
> Sub getallSA
Hi Experts,
Please solve this Query.
Regards,
Priyanka
--
Join official facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES (1120+ members already BANNED for violation)
1) Use concise, accurate thread titles. Poor thread titles, like Please Help,
Urgent, Need
Dear Priyanka,
See attached file.
Regards,
Kuldeep Singh
Back Office Executive (MIS)
Info Edge India Limited (naukri.com)
On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish <
vaishpriyanka2...@gmail.com> wrote:
> Hi Experts,
>
>
> Please solve this Query.
>
>
>
> Regards,
> Priyanka
>
> --
> Join
Hi Kuldeep,
Thank a lot.
Regards,
Priyanka
On Tue, Oct 30, 2012 at 12:05 PM, Kuldeep Singh wrote:
>
> Dear Priyanka,
>
> See attached file.
>
> Regards,
> Kuldeep Singh
> Back Office Executive (MIS)
> Info Edge India Limited (naukri.com)
>
>
> On Tue, Oct 30, 2012 at 11:47 AM, Priyanka Vaish
22 matches
Mail list logo