Re: $$Excel-Macros$$ Getting External Data using "From Microsoft Query"

[NOORAIN ANSARI]

Dear Sumesh,

Please see below link..
http://excelusergroup.org/blogs/nickhodge/archive/2008/11/04/excel-2007-getting-external-data.aspx


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Mon, Nov 21, 2011 at 12:34 PM, Sumesh wrote:

> Hi,
>
> I'm trying to get data from Oracle database using the option "From
> Microsoft Query".
>
> This however retrieves data based on the query which remains static,
> unless it is modified.
>
> I want the query to be dynamic. I would like to know how this can be
> done.
>
> For e.g. an input to my query is customer number. The customer number
> varies. The required customer number is input in a cell in one of the
> sheets. Is there a way to pick up this input into the SQL query?
>
> Hope I'm clear.
>
> Thanks in advance for the assistance.
>
> Kind Regards,
>
> Sumesh
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

** 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[krishnanm2006]

Awesome... Thanks Noorian 

Best Regards!
Sent on my BlackBerryŽ from Vodafone

-Original Message-
From: NOORAIN ANSARI 
Sender: excel-macros@googlegroups.com
Date: Mon, 21 Nov 2011 12:35:25 
To: 
Reply-To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Krishnan,

I hope your query will be solve by
=LOOKUP(G3,B3:D11)

On Mon, Nov 21, 2011 at 12:22 PM, NOORAIN ANSARI
wrote:

> Dear Krishnan,
>
> Don & SAM's  solutions are excellent.
> apart of this you can also use
> =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11)
> =INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0))
> =OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0)
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Sun, Nov 20, 2011 at 11:13 PM, Krishnan Moorthy <
> krishnanm2...@gmail.com> wrote:
>
>> Dear Excel Gurus,
>>
>> Need your help with a lookup formula. I have some min and max numbers and
>> next to it i have some values (see attached)..
>>
>> Now in column G3 if I enter any number for eg: 650 it should lookup for
>> this value in my range (B3:D11) and it should populate "*G" *in cell 
>> *H3*because 650 comes 601-700 range and the corresponding value for this is "
>> *G*"
>>
>>
>> I can understand this is very dynamic.. but any help with this is greatly
>> appreciated
>>
>> Thanks in advance..
>>
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
> ** 
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Getting External Data using "From Microsoft Query"

[Sumesh]

Hi,

I'm trying to get data from Oracle database using the option "From
Microsoft Query".

This however retrieves data based on the query which remains static,
unless it is modified.

I want the query to be dynamic. I would like to know how this can be
done.

For e.g. an input to my query is customer number. The customer number
varies. The required customer number is input in a cell in one of the
sheets. Is there a way to pick up this input into the SQL query?

Hope I'm clear.

Thanks in advance for the assistance.

Kind Regards,

Sumesh

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[NOORAIN ANSARI]

Dear Krishnan,

I hope your query will be solve by
=LOOKUP(G3,B3:D11)

On Mon, Nov 21, 2011 at 12:22 PM, NOORAIN ANSARI
wrote:

> Dear Krishnan,
>
> Don & SAM's  solutions are excellent.
> apart of this you can also use
> =LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11)
> =INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0))
> =OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0)
>
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
>
> On Sun, Nov 20, 2011 at 11:13 PM, Krishnan Moorthy <
> krishnanm2...@gmail.com> wrote:
>
>> Dear Excel Gurus,
>>
>> Need your help with a lookup formula. I have some min and max numbers and
>> next to it i have some values (see attached)..
>>
>> Now in column G3 if I enter any number for eg: 650 it should lookup for
>> this value in my range (B3:D11) and it should populate "*G" *in cell 
>> *H3*because 650 comes 601-700 range and the corresponding value for this is "
>> *G*"
>>
>>
>> I can understand this is very dynamic.. but any help with this is greatly
>> appreciated
>>
>> Thanks in advance..
>>
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
> ** 
>



-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[NOORAIN ANSARI]

Dear Krishnan,

Don & SAM's  solutions are excellent.
apart of this you can also use
=LOOKUP(2,(1/($B$3:$B$11=G3)),$D$3:$D$11)
=INDEX($D$3:$D$11,MATCH(G3,$B$3:$B$11,0))
=OFFSET(D2,MATCH(G3,$B$3:$B$11,0),0)

-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Sun, Nov 20, 2011 at 11:13 PM, Krishnan Moorthy
wrote:

> Dear Excel Gurus,
>
> Need your help with a lookup formula. I have some min and max numbers and
> next to it i have some values (see attached)..
>
> Now in column G3 if I enter any number for eg: 650 it should lookup for
> this value in my range (B3:D11) and it should populate "*G" *in cell 
> *H3*because 650 comes 601-700 range and the corresponding value for this is "
> *G*"
>
>
> I can understand this is very dynamic.. but any help with this is greatly
> appreciated
>
> Thanks in advance..
>
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>


** 

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Lookup(Multiple option).xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ help needs to connect form controls to the table

[Shankar Bheema]

thank you so much sir, if possible pls clarify my remaining doubts.

On Sun, Nov 20, 2011 at 1:06 AM, Sam Mathai Chacko wrote:

> You have to create a recordset by using the OpenRecordSet command in the
> CurrentDB
>
> Use
>
> Private Sub cmdsave_Click()
>
> Dim rst As Recordset
>
> Set rst = CurrentDb.OpenRecordset("SELECT * FROM t_main")
>
> rst.AddNew 'Add the Payment record
> rst.Fields(0).Value = txtfileno 'Payment ID
> rst.Fields(1).Value = txtempname 'W.O. #
>
> End Sub
>
> Also, your first column has a data type of Number. However, the txtfileno
> variable contains a string / text value. That will have to be corrected
> also. I have fixed this in the attached database.
>
> Regards,
>
> Sam Mathai Chacko
>
>
> On Sat, Nov 19, 2011 at 4:32 PM, Shankar Bheema wrote:
>
>> Dear Experts
>>
>> I created a form with MSACcess 2003, I placed a command button on the
>> form for saving the data into the table.  But it is throwing an error.  Pls
>> check and suggest me solution.
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

[Deepak Pal Singh]

Sure Maulik... I just want to know those email ids (which you want to add
in CC & BCC) are common or they'll be changed with every channel name...??

Regards
Deepak

On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote:

> Thanks you so much deepak for your effort & sorry for late reply becasue i
> can not able to use Gmail from my office pc & i check your file it is
> working very well just one thing i want to ask u that i want to add
> some email id on CC & BCC can u please help in this that how can i do
> that.& while data pasted to mail body , bottom line of table is not
> reflected .
>
> Request you to please look in small chnages & revert
>
> Thnaks in Advance..
>
> On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
>> Here it is I developed this code on 2007 platform..I hope it'll work
>> in 2003 as well...
>>
>> Sorry.. I couldn't attached the excel file with my previous post because
>> I's in office at that time & can't access to gmail over
>> there...
>>
>> Regards
>> Deepak
>>
>>
>> On Tue, Nov 15, 2011 at 11:32 PM, maulik desai wrote:
>>
>>> Hi deepu,
>>>
>>> Thanks you so much for your reply
>>>
>>> I have tried to paste the code in module but it not work properly
>>> request you to kindly provide me the excel sheet with your macro code but
>>> before you send me the file required small changes do not use K & M column
>>> for Chennel name & email address that is given just for information my
>>> actual database is from A to G request you to kindly change the macro code
>>> accordingly & send it back for the other checks also if you want u can
>>> create the summary sheet with the help of macro & paste it on sheet 2 &
>>> also for name u can use Column H for the proper output.1 more thing i want
>>> to tell you that a have to send mail with our official signature so if u
>>> can apply macro logic for the same also it would be very great ful to u.
>>>
>>> Request you to kindly make the changes & resend it for the final check
>>>
>>> Thanks in Advance & thanks for your time & support.
>>>
>>> On Mon, Nov 14, 2011 at 4:10 PM, deepu wrote:
>>>
 Hi Maulik,

 Below is the code that you're looking for...
 Insert a module in your workbook and paste the following code and run
 it...


 ---
 Dim MyArray() As Variant, ListArray() As Variant
 Dim R As Long, C As Integer, LastRow As Long, i As Long
 Dim OutObj As Object, EmailObj As Object, EmailBody As String, RecAdd
 As String
 Sub PrepareData()
 'Assigning values to MyArray
 LastRow = Sheet1.Range("A6").End(xlUp).Row
 MyArray = Sheet1.Range("A7:G" & LastRow).Value

 'Assigning values to ListArray
 LastRow = Sheet1.Range("K6").End(xlUp).Row
 ListArray = Sheet1.Range("K7:M" & LastRow).Value

 For i = LBound(ListArray) To UBound(ListArray)
RecAdd = ListArray(i, 3)
EmailBody = "Hi " &
 Application.WorksheetFunction.Proper(ListArray(i, 2)) & ",>>> Align=center>FYI..." & _
"" & _
">>> Color=#FF>Customer Name" & _
">>> Color=#FF>Location" & _
">>> Color=#FF>Date" & _
">>> Color=#FF>Site" & _
">>> Color=#FF>Status" & _
""

For R = LBound(MyArray) To UBound(MyArray)
If ListArray(i, 1) = MyArray(R, 6) Then
For C = 1 To 5
EmailBody = EmailBody & "" & _
"" & MyArray(R, 1) & "" & _
"" & MyArray(R, 2) & "" & _
"" & MyArray(R, 3) & "" & _
"" & MyArray(R, 4) & "" & _
"" & MyArray(R, 5) & "" & _
""
Next C
End If
Next R
Call SendEmail(RecAdd, EmailBody)
 Next i
 End Sub

 Sub SendEmail(ReceiptAdd As String, EBody As String)
 Set OutObj = CreateObject("Outlook.Application.12")
 Set EmailObj = OutObj.CreateItem(0)

 EmailBody = EmailBody & "" & _
 "RegardsXYZ"

 With EmailObj
.To = ReceiptAdd
.Subject = "Your Channels Data"
.HTMLBody = EmailBody
.Send
 End With

 End Sub

 ---

 Hope you'd like it.. Kindly contact to me if you face any problem...

 Regards
 Deepak

 On Nov 13, 10:00 pm, maulik desai  wrote:
 > Hi Team,
 >
 > I am having 1 excel sheet in that i have to prepare Chennel wise
 detail
 > report on a every week & i have to send that information to respective
 > chennel heads wia email ,
 > Manually i need to do filter the data base on chennal

Re: $$Excel-Macros$$ Paste Special VS Paste Special

[hanumant shinde]

Hi,

Thank you all.
in this case if i want to copy paste only format from 1 workbook to another 
then how can i achieve that.




>
> From: Venkat CV 
>To: excel-macros@googlegroups.com 
>Sent: Monday, 21 November 2011 7:56 AM
>Subject: Re: $$Excel-Macros$$ Paste Special VS Paste Special
> 
>
>Hi Hanumant,
>
>
>First one you have copied data from Some other Application(New Window 
>workbook,World..Etc) window and 2nd one Copied 
>from Same window same sheet's That's what it's Showing different Options...
>
>Best Regards,
>Venkat 
>Chennai
>My Linked in profile
>
>On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde  
>wrote:
>
>Hi Friends,
>> 
>>i have attached screenshot which has 2 windows for paste special 
>>functionality.
>>i wanted to paste only formula but i got 1st window (Left from reader) hence 
>>could not do so. can somebody please tell me in what circumstances which 
>>window appears.
>>i.e. which window will open when 
-- 
>>FORUM RULES (934+ members already BANNED for violation)
>> 
>>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not 
>>get quick attention or may not be answered.
>> 
>>2) Don't post a question in the thread of another member.
>> 
>>3) Don't post questions regarding breaking or bypassing any security measure.
>> 
>>4) Acknowledge the responses you receive, good or bad.
>> 
>>5)  Cross-promotion of, or links to, forums competitive to this forum in 
>>signatures are prohibited. 
>> 
>>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>>owners and members are not responsible for any loss.
>> 
>>--
>>To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
>-- 
>
>
>
>
>
>
>
>-- 
>FORUM RULES (934+ members already BANNED for violation)
> 
>1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
>Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
>quick attention or may not be answered.
> 
>2) Don't post a question in the thread of another member.
> 
>3) Don't post questions regarding breaking or bypassing any security measure.
> 
>4) Acknowledge the responses you receive, good or bad.
> 
>5)  Cross-promotion of, or links to, forums competitive to this forum in 
>signatures are prohibited. 
> 
>NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
>owners and members are not responsible for any loss.
> 
>--
>To post to this group, send email to excel-macros@googlegroups.com
>
>
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Kindly Help

[Venkat CV]

Hi Vijay,


See attached if helps...


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *


On Thu, Nov 17, 2011 at 2:24 PM, vijayKumar  wrote:

> Dear Friends,
>
> Request you to help me on a Query of Open Office Excel.
>
> The Query is as fallows.
>
>
>1. Can we protect the sheet as we do protect worksheet in XL.
>2. Request you to help me in creating a macro to consolidate 40
>files(Open Office Excel) in a XL sheet(2007).
>3. All Heading of The Files to be consolidated are same but number of
>lines may vary.
>
> Problems faced while doing the same manually is :
> When we copy the data from Open excel and paste to XL-2007 some data will
> be missing which will be in text. but the same will not happen when we copy
> the data from Open excel and paste it in notepad and copy the same from
> notepad to XL-2007.
>
> --
> Vijay
> 998070
>
> --
> Vijay
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


calc6_EN.pdf
Description: Adobe PDF document

Re: $$Excel-Macros$$ Paste Special VS Paste Special

[Venkat CV]

Hi Hanumant,

First one you have copied data from Some other Application(New Window
workbook,World..Etc) window and 2nd one Copied
from Same window same sheet's That's what it's Showing different Options...

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Thu, Nov 17, 2011 at 9:49 PM, hanumant shinde wrote:

> Hi Friends,
>
> i have attached screenshot which has 2 windows for paste special
> functionality.
> i wanted to paste only formula but i got 1st window (Left from reader)
> hence could not do so. can somebody please tell me in what circumstances
> which window appears.
> i.e. which window will open when
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Indirect formula

[Venkat CV]

Hi Sumitha,

Please See below links for Indirect  Function More Clarification...
http://www.contextures.com/xlFunctions05.html
http://www.cpearson.com/excel/indirect.htm


*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *



On Tue, Nov 15, 2011 at 12:13 PM, smitha.kumari  wrote:

>  Hi,
>
> ** **
>
> Any one please explain why these quotes are used in this formula
>
> ** **
>
> =SUMIF(INDIRECT("'"&B$5&"'!A:A"),$A6,INDIRECT("'"&B$5&"'!I:I"))
>
> ** **
>
> Regards
>
> Smitha 
>
> ** **
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Deleting modules

[Venkat CV]

Hi Chandra Sekar,

Right Click on Module and Remove module and Click option No,,

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Fri, Nov 18, 2011 at 4:23 PM, Chandra Shekar <
chandrashekarb@gmail.com> wrote:

> Hello,
>
> Could you please let me know how to delete module?
>
> Thanks in advance.
>
>
>
> Regards,
>
> Chandra Shekar B
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ converting excel file into xml file

[Venkat CV]

Hi Vijay,

Try File Save as a .XML

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *

On Fri, Nov 18, 2011 at 9:53 PM, P.VIJAYKUMAR  wrote:

> Dear Gurus,
>
> Is there any method to convert Excel file into XML format.In some specific
> software for impotring data .the data should be in xml format only,then
> only we can import the data.I need any macro method or any thing  which
> converts excel data into XML FILE FORMAT
>
> Thanking you all ,
>
> Regards.
> Vijaykumar
>
>
>
>
>
>
>
>
>
>
>
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
*
*
*
*
*
*

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Sales Data entry form

[dguillett1]

Did you eever get an answer to this.


Don Guillett
SalesAid Software
dguille...@gmail.com

From: Manhar Kisan 
Sent: Thursday, November 17, 2011 3:10 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Sales Data entry form

Dear All 

Hi  I have to create a sales database for my company and therefore i require 
your help.

as per attach sheet-1 i want to create data entry form and as per sheet no 2 
output require i get database.


SO Please help me for the quiry and provide me best solustion 

-- 
Thanks & Regards 
MANHAR PRAJAPATI
AHMEDABAD




-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[dguillett1]

Works for me tooo...

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Sam Mathai Chacko 
Sent: Sunday, November 20, 2011 12:43 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Lookup for a cell between a range of values

Here the attachment with the formula Don was mentioning. Working fine as far as 
I can see!

Sam


On Mon, Nov 21, 2011 at 12:10 AM, Krishnan Moorthy  
wrote:

  Don, thanks for your response..

  I have tried Vlookup.. if I enter 99 in G3 it shows NA.. 

  Let me rephrase my question once again...If I enter any number between 1-900 
it should pick the corresponding Value .. for example. if I enter 650 it should 
lookup for this value in my range (B3:D11) and it should populate "G" in cell 
H3 because 650 comes 601-700 range and the corresponding value for this is "G" 





  On Sun, Nov 20, 2011 at 11:59 PM, dguillett1  wrote:

Have you tried?

=VLOOKUP(G3,$B$3D$11,3)

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Krishnan Moorthy 
Sent: Sunday, November 20, 2011 11:43 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Excel Gurus,

Need your help with a lookup formula. I have some min and max numbers and 
next to it i have some values (see attached)..

Now in column G3 if I enter any number for eg: 650 it should lookup for 
this value in my range (B3:D11) and it should populate "G" in cell H3 because 
650 comes 601-700 range and the corresponding value for this is "G"


I can understand this is very dynamic.. but any help with this is greatly 
appreciated

Thanks in advance..


-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security 
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security 
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com





  -- 
  Regards,

  Krishnan Moorthy. 

  -- 
  FORUM RULES (934+ members already BANNED for violation)
   
  1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
   
  2) Don't post a question in the thread of another member.
   
  3) Don't post questions regarding breaking or bypassing any security measure.
   
  4) Acknowledge the responses you receive, good or bad.
   
  5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
   
  NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
   
  
--
  To post to this group, send email to excel-macros@googlegroups.com




-- 
Sam Mathai Chacko
-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion 

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[Krishnan Moorthy]

Sam and Don...

Thanks so much!! I never knew that this could be solved using a simple
vlookup :)

I thought that some nested formula should be written to solve this...Thanks
once again..


Warm Regards !


On Mon, Nov 21, 2011 at 12:13 AM, Sam Mathai Chacko wrote:

> Here the attachment with the formula Don was mentioning. Working fine as
> far as I can see!
>
> Sam
>
>
> On Mon, Nov 21, 2011 at 12:10 AM, Krishnan Moorthy <
> krishnanm2...@gmail.com> wrote:
>
>> Don, thanks for your response..
>>
>> I have tried Vlookup.. if I enter 99 in G3 it shows NA..
>>
>> Let me rephrase my question once again...If I enter any number between
>> 1-900 it should pick the corresponding Value .. for example. if I enter 650
>> it should lookup for this value in my range (B3:D11) and it should populate
>> "*G" *in cell *H3* because 650 comes 601-700 range and the corresponding
>> value for this is "*G*"
>>
>>
>>
>>
>> On Sun, Nov 20, 2011 at 11:59 PM, dguillett1 wrote:
>>
>>>   Have you tried?
>>>
>>> =VLOOKUP(G3,$B$3[image: Embarrassed smile]D$11,3)
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Krishnan Moorthy 
>>> *Sent:* Sunday, November 20, 2011 11:43 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Lookup for a cell between a range of values
>>>
>>> Dear Excel Gurus,
>>>
>>> Need your help with a lookup formula. I have some min and max numbers
>>> and next to it i have some values (see attached)..
>>>
>>> Now in column G3 if I enter any number for eg: 650 it should lookup for
>>> this value in my range (B3:D11) and it should populate "*G" *in cell *H3
>>> * because 650 comes 601-700 range and the corresponding value for this
>>> is "*G*"
>>>
>>>
>>> I can understand this is very dynamic.. but any help with this is
>>> greatly appreciated
>>>
>>> Thanks in advance..
>>>
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>> --
>>> FORUM RULES (934+ members already BANNED for violation)
>>>
>>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>>
>>> 2) Don't post a question in the thread of another member.
>>>
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>>
>>> 4) Acknowledge the responses you receive, good or bad.
>>>
>>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>>> signatures are prohibited.
>>>
>>> NOTE : Don't ever post personal or confidential data in a workbook.
>>> Forum owners and members are not responsible for any loss.
>>>
>>>
>>> --
>>> To post to this group, send email to excel-macros@googlegroups.com
>>>
>>
>>
>>
>> --
>> Regards,
>>
>> Krishnan Moorthy.
>>
>>  --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Sam Mathai Chacko
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be 

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[Sam Mathai Chacko]

Here the attachment with the formula Don was mentioning. Working fine as
far as I can see!

Sam

On Mon, Nov 21, 2011 at 12:10 AM, Krishnan Moorthy
wrote:

> Don, thanks for your response..
>
> I have tried Vlookup.. if I enter 99 in G3 it shows NA..
>
> Let me rephrase my question once again...If I enter any number between
> 1-900 it should pick the corresponding Value .. for example. if I enter 650
> it should lookup for this value in my range (B3:D11) and it should populate
> "*G" *in cell *H3* because 650 comes 601-700 range and the corresponding
> value for this is "*G*"
>
>
>
>
> On Sun, Nov 20, 2011 at 11:59 PM, dguillett1  wrote:
>
>>   Have you tried?
>>
>> =VLOOKUP(G3,$B$3[image: Embarrassed smile]D$11,3)
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Krishnan Moorthy 
>> *Sent:* Sunday, November 20, 2011 11:43 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Lookup for a cell between a range of values
>>
>> Dear Excel Gurus,
>>
>> Need your help with a lookup formula. I have some min and max numbers and
>> next to it i have some values (see attached)..
>>
>> Now in column G3 if I enter any number for eg: 650 it should lookup for
>> this value in my range (B3:D11) and it should populate "*G" *in cell 
>> *H3*because 650 comes 601-700 range and the corresponding value for this is "
>> *G*"
>>
>>
>> I can understand this is very dynamic.. but any help with this is greatly
>> appreciated
>>
>> Thanks in advance..
>>
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatures are prohibited.
>>
>> NOTE : Don't ever post personal or confidential data in a workbook. Forum
>> owners and members are not responsible for any loss.
>>
>>
>> --
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>
>
>
> --
> Regards,
>
> Krishnan Moorthy.
>
>  --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Sam Mathai Chacko

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

---

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[Krishnan Moorthy]

Don, thanks for your response..

I have tried Vlookup.. if I enter 99 in G3 it shows NA..

Let me rephrase my question once again...If I enter any number between
1-900 it should pick the corresponding Value .. for example. if I enter 650
it should lookup for this value in my range (B3:D11) and it should populate
"*G" *in cell *H3* because 650 comes 601-700 range and the corresponding
value for this is "*G*"



On Sun, Nov 20, 2011 at 11:59 PM, dguillett1  wrote:

>   Have you tried?
>
> =VLOOKUP(G3,$B$3[image: Embarrassed smile]D$11,3)
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Krishnan Moorthy 
> *Sent:* Sunday, November 20, 2011 11:43 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Lookup for a cell between a range of values
>
> Dear Excel Gurus,
>
> Need your help with a lookup formula. I have some min and max numbers and
> next to it i have some values (see attached)..
>
> Now in column G3 if I enter any number for eg: 650 it should lookup for
> this value in my range (B3:D11) and it should populate "*G" *in cell 
> *H3*because 650 comes 601-700 range and the corresponding value for this is "
> *G*"
>
>
> I can understand this is very dynamic.. but any help with this is greatly
> appreciated
>
> Thanks in advance..
>
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5) Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>



-- 
Regards,

Krishnan Moorthy.

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ Lookup for a cell between a range of values

[dguillett1]

Have you tried?

=VLOOKUP(G3,$B$3D$11,3)

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Krishnan Moorthy 
Sent: Sunday, November 20, 2011 11:43 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Lookup for a cell between a range of values

Dear Excel Gurus,

Need your help with a lookup formula. I have some min and max numbers and next 
to it i have some values (see attached)..

Now in column G3 if I enter any number for eg: 650 it should lookup for this 
value in my range (B3:D11) and it should populate "G" in cell H3 because 650 
comes 601-700 range and the corresponding value for this is "G"


I can understand this is very dynamic.. but any help with this is greatly 
appreciated

Thanks in advance..


-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com
<>

Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

[dguillett1]

I would highly recommend that you keep all data one ONE sheet and use 
data>filter>autotfilter on vendor, etc. Your summary can use vlookup for c2
  TSNB 
=VLOOKUP(B2,Data!$C$2:$Z$1000,2,0) 
and SUMPRODUCT formulas based on your other criteria 

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Prabhu 
Sent: Sunday, November 20, 2011 11:01 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

Hi Friends,

I have attached a workbook which contains Sheets “Data, Summary, etc.,”

Data sheet is the base data from there we need to create new sheet using VBA 
based on Vendor (Column “C”).

Each and every vendor’s data needs to have separate sheet (sheet name also 
reflect the vendor name) and finally we have crate summary sheet as per 
attached sheet with hyper link.

Can anyone help me to have VBA code for the same?

Regards,

Prabhu

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

[dguillett1]

OOPs sent as response to ANOTHER POST. Ignore

Don Guillett
SalesAid Software
dguille...@gmail.com

From: dguillett1 
Sent: Sunday, November 20, 2011 12:00 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

How many times do I need to send this to you?

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Prabhu 
Sent: Sunday, November 20, 2011 11:01 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

Hi Friends,

I have attached a workbook which contains Sheets “Data, Summary, etc.,”

Data sheet is the base data from there we need to create new sheet using VBA 
based on Vendor (Column “C”).

Each and every vendor’s data needs to have separate sheet (sheet name also 
reflect the vendor name) and finally we have crate summary sheet as per 
attached sheet with hyper link.

Can anyone help me to have VBA code for the same?

Regards,

Prabhu

-- 
FORUM RULES (934+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

$$Excel-Macros$$ Lookup for a cell between a range of values

[Krishnan Moorthy]

Dear Excel Gurus,

Need your help with a lookup formula. I have some min and max numbers and
next to it i have some values (see attached)..

Now in column G3 if I enter any number for eg: 650 it should lookup for
this value in my range (B3:D11) and it should populate "*G" *in cell
*H3*because 650 comes 601-700 range and the corresponding value for
this is "
*G*"


I can understand this is very dynamic.. but any help with this is greatly
appreciated

Thanks in advance..

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Lookup.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

[Prabhu]

Hi Friends,
I have attached a workbook which contains Sheets “Data, Summary,
etc.,”

Data sheet is the base data from there we need to create new sheet
using VBA based on Vendor (Column “C”).

Each and every vendor’s data needs to have separate sheet (sheet name
also reflect the vendor name) and finally we have crate summary sheet
as per attached sheet with hyper link.

Can anyone help me to have VBA code for the same?

Regards,

Prabhu

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ ***VBA Code to Create New Sheet with summary***

[NOORAIN ANSARI]

Dear Prabhu,

Attachment is missing..
Please send your workbook


-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Sun, Nov 20, 2011 at 10:26 PM, Prabhu  wrote:

> Hi Friends,
> I have attached a workbook which contains Sheets “Data, Summary,
> etc.,”
>
> Data sheet is the base data from there we need to create new sheet
> using VBA based on Vendor (Column “C”).
>
> Each and every vendor’s data needs to have separate sheet (sheet name
> also reflect the vendor name) and finally we have crate summary sheet
> as per attached sheet with hyper link.
>
> Can anyone help me to have VBA code for the same?
>
> Regards,
>
> Prabhu
>
> --
> FORUM RULES (934+ members already BANNED for violation)
>
> 1) Use concise, accurate thread titles. Poor thread titles, like Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
>
> 2) Don't post a question in the thread of another member.
>
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
>
> 4) Acknowledge the responses you receive, good or bad.
>
> 5)  Cross-promotion of, or links to, forums competitive to this forum in
> signatures are prohibited.
>
> NOTE  : Don't ever post personal or confidential data in a workbook. Forum
> owners and members are not responsible for any loss.
>
>
> --
> To post to this group, send email to excel-macros@googlegroups.com
>

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Fwd: $$Excel-Macros$$ Fwd: How can I repeat top most data of a column on each page

[MRafique Ujjan]

Dear All,

I am thankful to all of friends who responded me well, but it is my
fault that i could not mention my problem clearly. Therefore I once
again try to mention please help me in this regard as earlier.

Problem:
Suppose I have one two columns A1 & B1.  In column A1  I entered
Different Countries and in other column B1 I enter Sale in different
cities. So now i have entered thousands of entries in sale column. If
in the column A1 I enter every country name against column B1 for
sales. Then it looks like as below

       A1                                B1

1.  Pakistan                       Karachi
2.  Pakistan                       Hyderabad
3.  Pakistan                       Islamabad
4.  India                             Delhi
5.  India                             Kolkata
6.  India                             Mumbai
1.  Pakistan                       Karachi
2.  Pakistan                       Hyderabad
3.  Pakistan                       Islamabad
4.  India                             Delhi
5.  India                             Kolkata
6.  India                             Mumbai
7.  Pakistan                       Karachi
8.  Pakistan                       Hyderabad
9.  Pakistan                       Islamabad
10.  India                           Delhi
11.  India                           Kolkata
12.  India                           Mumbai
and so on .

Now if I have entered thousands of rows entries for both columns. Then
it looks bad to enter each country name against every city. So I
entered the data in this way.

A1                                B1

1.  Pakistan                      Karachi
2.                                     Hyderabad
3.                                     Islamabad
4.  India                             Delhi
5.                                     Kolkata
6.                                     Mumbai
7.  Pakistan                       Karachi
8.                                     Hyderabad
9.                                     Islamabad
10.  India                           Delhi
11.                                   Kolkata
12.                                   Mumbai
13.  Pakistan                    Karachi
14.                                   Hyderabad
15.                                   Islamabad
16.  India                           Delhi
17.                                   Kolkata
18.                                   Mumbai
Now as I have already told you that I have entered thousands of
entries like above. Therefore, when i print the data it looks like
this

Page 1
==
1.  Pakistan                      Karachi
2.                                     Hyderabad
3.                                     Islamabad
4.  India                             Delhi
5.                                     Kolkata
6.                                     Mumbai
7.  Pakistan                       Karachi
8.                                     Hyderabad
9.                                     Islamabad
10.  India                           Delhi
11.                                   Kolkata
12.                                   Mumbai
13.  Pakistan                    Karachi
14.                                   Hyderabad
15.                                   Islamabad
16.  India                           Delhi
17.                                   Kolkata
18.                                   Mumbai

Page 2
==
19.                                     Karachi
20.                                     Hyderabad
21.                                     Islamabad
22.  India                             Delhi
23.                                     Kolkata
24.                                     Mumbai
25.  Pakistan                       Karachi
26.                                     Hyderabad
27.                                     Islamabad
28.  India                           Delhi
29.                                   Kolkata
30.                                   Mumbai
31.  Pakistan                    Karachi
32.                                   Hyderabad
33.                                   Islamabad
34.  India                           Delhi
35.                                   Kolkata
36.                                   Mumbai

Now suppose in the page 2 there is no name mentioned in the Column A1
(1st row of page 2)  against the column B1. In the page 1 the data is
clear to understand but in page 2 it is not clear.
Therefore I need a formula or macro for each page to show the name of
country automatically in the 1st row of each next page.

I have tried my level best to mention clearly my problem. I hope that
I will get the problem solved soon.

Thanking you in anticipation.

M. Rafique Ujjan

On Nov 19, 1:16 am, "dguillett1"  wrote:







> You can use the change event macro so when you type in the sample number you 
> will get what you requested.
> However,I suspect that you want more
> On the print 

Re: $$Excel-Macros$$ How can I repeat top most data of a column on each page

[M.Rafique MRU]

Dear All.

I haveattached here a sample worksheet for you, in which all queries are
mentioned. Your help in this regard will be highly appreciated.

Thanking you in anticipation.

M. Rafique Ujjan

-- 
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


Sample Worksheet.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Program

[dguillett1]

I looked at this again and I think?? I understand what you want. I also 
notice that your web fetch is very slow and inefficient. What you need will 
require a lot of programming so I suggest you contact me privately.



Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: renuka chari

Sent: Saturday, November 19, 2011 3:31 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Macro Chart Problem For Stack Exchange Program

hi

Sam Mathai Chacko,
Don Guillett.

thanks for ur responce

Actually this Excel Project Will work like this:

here Ohlc Sheet Having data it is automatically coming from yahoo site
if we need to select symbol, next cell for company, and enter starting
date and ending date then click on get data button then data will
coming automatically here max & min values are depending on close
column chart sheet having block size if we need to enter bolck size
and click on drawchart then graph will display reversal is fixed
constant

Presently chart ranges are coming depending on the Fixed block size
but I need like this, if Max & Min valus are Max is 6000 & min is 290
then when ever clicking on draw chart Button the scale should be
display 6000-2900 range diff is 100 & 2900-1400 range diff is 50 &
1400-600 Range diff is 20 like this.


i think my problem is clear if not plz feel free to give a responce




thanks in advance
Renukachari

--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please 
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will 
not get quick attention or may not be answered.


2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security 
measure.


4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited.


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.


--
To post to this group, send email to excel-macros@googlegroups.com 


--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Making Chart more useful to readers

[Steve Weaver]

Thank you Sam and Don for sharing your knowledge.

You guys are GREAT!

Steve


On 11/19/2011 1:13 PM, Sam Mathai Chacko wrote:
For some reason, the named range with an INDIRECT formula isn't 
getting accepted within the chart. Had to change the formula to


=OFFSET($A$7,1,0,13,1), assuming row 7 or any row above will not be 
deleted or inserted, since OP mentioned that they always insert new 
data in Row 8


Have put in the dynamic names as Don suggested. You can have a look at 
the attachment Steve.


Regards,

Sam Mathai Chacko

On Sat, Nov 19, 2011 at 9:05 PM, dguillett1 > wrote:


Doesn’t seem right but then try my suggestion with this change to
always start at row 8
months
=OFFSET(INDIRECT("$A$" & 8),0,0,13,1)
Don Guillett
SalesAid Software
dguille...@gmail.com 
*From:* Steve Weaver 
*Sent:* Saturday, November 19, 2011 9:14 AM
*To:* excel-macros@googlegroups.com

*Cc:* Sam Mathai Chacko 
*Subject:* Re: $$Excel-Macros$$ Making Chart more useful to readers
Sam,

Currently each week we insert a new row for week number 1 (row 8)
and manually insert the new data. Than we adjust the table to
reflect the proper week number for the previous weeks. Once that
is finished, we change the chart to select the proper time frame
Weeks 1 thru 13.

I'd like to show the chart in the most meaningful way possible. 
If that means making the chart look differently, I'm open to that

suggestion.

Hope this helps!

Thanks!
Steve



On 11/19/2011 8:25 AM, Sam Mathai Chacko wrote:

To suggest a suitable solution, you will have to clearly mention
how your weekly data gets input. As of now, it is not clear how a
new set of data is added to your table.

From the attached file, can you confirm if that is how you want
the charts to look like

Regards,

Sam Mathai Chacko
On Sat, Nov 19, 2011 at 6:15 PM, Steve Weaver
mailto:steveweave...@comcast.net>> wrote:

Hi all,

I would like to change the attached spreadsheet to allow for
easier weekly updates and to provide the readers with a
little more useful information. To accomplish this I would
like to do the following:

  * make the rolling 13 week data dynamic so that when the
current weeks information is added it will automatically
use only the most recent 13 weeks of data

  * on the chart showing the Order Bookings ($), split each
weekly total between the inside and outside bookings

Thank you in advance for your help.

Steve

-- 
FORUM RULES (934+ members already BANNED for violation)


1) Use concise, accurate thread titles. Poor thread titles,
like Please Help, Urgent, Need Help, Formula Problem, Code
Problem, and Need Advice will not get quick attention or may
not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any
security measure.

4) Acknowledge the responses you receive, good or bad.

5) Cross-promotion of, or links to, forums competitive to
this forum in signatures are prohibited.

NOTE : Don't ever post personal or confidential data in a
workbook. Forum owners and members are not responsible for
any loss.


--
To post to this group, send email to
excel-macros@googlegroups.com


-- 



--
FORUM RULES (934+ members already BANNED for violation)

1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.

2) Don't post a question in the thread of another member.

3) Don't post questions regarding breaking or bypassing any security measure.

4) Acknowledge the responses you receive, good or bad.

5)  Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. 


NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Required Progres bar / Status bar while macro runinng....

[maulik desai]

Hi Ranjan,

Thanks for your reply but can u plese how to use this..

On Tue, Nov 15, 2011 at 2:18 PM, rajan verma wrote:

> You can use UserForm.SHow 0 ..
>
> On Mon, Nov 14, 2011 at 6:47 PM, dguillett1  wrote:
>
>>   Attach your file with a reply to this msg.
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* maulik desai 
>> *Sent:* Sunday, November 13, 2011 10:31 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Required Progres bar / Status bar while
>> macro runinng
>>
>>   Hi Team,
>>
>> I having 1 excel sheet in that i have apply below Sumproduct macro code
>> 72 times to get output on my database (This code is provided by Daniel
>> of this group ) my But my problem is it take about 20 to 30 mins to run the
>> code total 550 row(not fixed) x 72 columns ) what I want that can i get
>> a progress bar which shows me status like " 3 outof 72 columns completed"
>> or 10%,15% ,30% completed like that
>>
>> also if can help to reduce the code size to work faster
>> Please find below code provided by Mr.Daniel of this group.
>>
>> Thanks in advance
>>
>>
>> Here is an example to replace sheet Batch column K with a macro:
>>
>> 
>>
>> Sub test()
>>
>> 'sheet Batch column K
>>
>> With Sheets("Batch")
>>
>> For Each c In .Range(.[A7], .[A65536].End(xlUp))
>>
>> .Cells(c.Row, 11) = Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" &
>> c.Row & ")*(DB!$AP$2:$AP$46803=""Yes""))")
>>
>> Next c
>>
>> End With
>>
>> End Sub
>>
>> 
>>
>> You should run the macro each time you change, add or delete a value in
>> column A; place the following macro in the sheet module :
>>
>> Private Sub Worksheet_Change(ByVal Target As Range)
>>
>> If Target.Column = 1 And Target.Row > 6 Then
>>
>> Cells(Target.Row, 11) =
>> Evaluate("sumproduct((DB!$A$2:$A$46803=Batch!$A" _
>>
>> & Target.Row & ")*(DB!$AP$2:$AP$46803=""Yes""))")
>>
>> End If
>>
>> End Sub
>>
>> 
>>
>> You’ll have to do the same for others formulas.
>>
>> Regards.
>>
>> Daniel
>>
>> 
>>
>> *De :* excel-macros@googlegroups.com [mailto:
>> excel-macros@googlegroups.com] *De la part de* maulik desai
>> *Envoyé :* mardi 22 février 2011 18:55
>> *À :* excel-macros@googlegroups.com
>> *Objet :* $$Excel-Macros$$ How to use sumproduct Formula in Macro
>>
>> 
>>
>> I having Database with 4Sheets and i have used Sumproduct Formula in many
>> Columns in my database. i have apply the formulas on every columns but the
>> prolem is the file becomes very heavy & it take to much time to give the
>> output
>>
>> is there any way to use the samproduct function with the help of macro **
>> **
>>
>> 
>>
>> sample file attached i am having large database 
>>
>> 
>>
>> Request you to kindly provide the solution for the same
>>
>> --
>> Thanks & Regards,
>> Maulik Desai
>> 9967363926
>>
>> --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>  --
>>
>> --
>> Some important links for excel users:
>> 1. Follow us on TWITTER for tips tricks and links :
>> http://twitter.com/exceldailytip
>> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
>> 3. Excel tutorials at http://www.excel-macros.blogspot.com
>> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
>> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>>
>> To post to this group, send email to excel-macros@googlegroups.com
>>
>> <><><><><><><><><><><><><><><><><><><><><><>
>> Like our page on facebook , Just follow below link
>> http://www.facebook.com/discussexcel
>>
>>
>>
>> --
>> Thanks & Regards,
>> Maulik Desai
>> 9967363926
>> --
>> FORUM RULES (934+ members already BANNED for violation)
>>
>> 1) Use concise, accurate thread titles. Poor thread titles, like Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>>
>> 2) Don't post a question in the thread of another member.
>>
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>>
>> 4) Acknowledge the responses you receive, good or bad.
>>
>> 5) Cross-promotion of, or links to, forums competitive to this forum in
>> signatu

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

[maulik desai]

On Sun, Nov 20, 2011 at 2:43 PM, maulik desai wrote:

> Thanks you so much deepak for your effort & sorry for late reply becasue i
> can not able to use Gmail from my office pc & i check your file it is
> working very well just one thing i want to ask u that i want to add
> some email id on CC & BCC can u please help in this that how can i do
> that.& while data pasted to mail body , bottom line of table is not
> reflected .
>
> Request you to please look in small chnages & revert
>
> Thnaks in Advance..
>
>  On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
>> Here it is I developed this code on 2007 platform..I hope it'll work
>> in 2003 as well...
>>
>> Sorry.. I couldn't attached the excel file with my previous post because
>> I's in office at that time & can't access to gmail over
>> there...
>>
>> Regards
>> Deepak
>>
>>
>> On Tue, Nov 15, 2011 at 11:32 PM, maulik desai wrote:
>>
>>> Hi deepu,
>>>
>>> Thanks you so much for your reply
>>>
>>> I have tried to paste the code in module but it not work properly
>>> request you to kindly provide me the excel sheet with your macro code but
>>> before you send me the file required small changes do not use K & M column
>>> for Chennel name & email address that is given just for information my
>>> actual database is from A to G request you to kindly change the macro code
>>> accordingly & send it back for the other checks also if you want u can
>>> create the summary sheet with the help of macro & paste it on sheet 2 &
>>> also for name u can use Column H for the proper output.1 more thing i want
>>> to tell you that a have to send mail with our official signature so if u
>>> can apply macro logic for the same also it would be very great ful to u.
>>>
>>> Request you to kindly make the changes & resend it for the final check
>>>
>>> Thanks in Advance & thanks for your time & support.
>>>
>>> On Mon, Nov 14, 2011 at 4:10 PM, deepu wrote:
>>>
 Hi Maulik,

 Below is the code that you're looking for...
 Insert a module in your workbook and paste the following code and run
 it...


 ---
 Dim MyArray() As Variant, ListArray() As Variant
 Dim R As Long, C As Integer, LastRow As Long, i As Long
 Dim OutObj As Object, EmailObj As Object, EmailBody As String, RecAdd
 As String
 Sub PrepareData()
 'Assigning values to MyArray
 LastRow = Sheet1.Range("A6").End(xlUp).Row
 MyArray = Sheet1.Range("A7:G" & LastRow).Value

 'Assigning values to ListArray
 LastRow = Sheet1.Range("K6").End(xlUp).Row
 ListArray = Sheet1.Range("K7:M" & LastRow).Value

 For i = LBound(ListArray) To UBound(ListArray)
RecAdd = ListArray(i, 3)
EmailBody = "Hi " &
 Application.WorksheetFunction.Proper(ListArray(i, 2)) & ",>>> Align=center>FYI..." & _
"" & _
">>> Color=#FF>Customer Name" & _
">>> Color=#FF>Location" & _
">>> Color=#FF>Date" & _
">>> Color=#FF>Site" & _
">>> Color=#FF>Status" & _
""

For R = LBound(MyArray) To UBound(MyArray)
If ListArray(i, 1) = MyArray(R, 6) Then
For C = 1 To 5
EmailBody = EmailBody & "" & _
"" & MyArray(R, 1) & "" & _
"" & MyArray(R, 2) & "" & _
"" & MyArray(R, 3) & "" & _
"" & MyArray(R, 4) & "" & _
"" & MyArray(R, 5) & "" & _
""
Next C
End If
Next R
Call SendEmail(RecAdd, EmailBody)
 Next i
 End Sub

 Sub SendEmail(ReceiptAdd As String, EBody As String)
 Set OutObj = CreateObject("Outlook.Application.12")
 Set EmailObj = OutObj.CreateItem(0)

 EmailBody = EmailBody & "" & _
 "RegardsXYZ"

 With EmailObj
.To = ReceiptAdd
.Subject = "Your Channels Data"
.HTMLBody = EmailBody
.Send
 End With

 End Sub

 ---

 Hope you'd like it.. Kindly contact to me if you face any problem...

 Regards
 Deepak

 On Nov 13, 10:00 pm, maulik desai  wrote:
 > Hi Team,
 >
 > I am having 1 excel sheet in that i have to prepare Chennel wise
 detail
 > report on a every week & i have to send that information to respective
 > chennel heads wia email ,
 > Manually i need to do filter the data base on chennal name & then
 copy data
 > from sheet & need to paste on mail body then i have to send the data
 to
 > that chennel head based on chennel name.
 

Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday

[maulik desai]

Thanks you so much deepak for your effort & sorry for late reply becasue i
can not able to use Gmail from my office pc & i check your file it is
working very well just one thing i want to ask u that i want to add
some email id on CC & BCC can u please help in this that how can i do
that.& while data pasted to mail body , bottom line of table is not
reflected .

Request you to please look in small chnages & revert

Thnaks in Advance..

On Wed, Nov 16, 2011 at 11:01 AM, Deepak Pal Singh <
deepaktheind...@gmail.com> wrote:

> Here it is I developed this code on 2007 platform..I hope it'll work
> in 2003 as well...
>
> Sorry.. I couldn't attached the excel file with my previous post because
> I's in office at that time & can't access to gmail over
> there...
>
> Regards
> Deepak
>
>
> On Tue, Nov 15, 2011 at 11:32 PM, maulik desai wrote:
>
>> Hi deepu,
>>
>> Thanks you so much for your reply
>>
>> I have tried to paste the code in module but it not work properly request
>> you to kindly provide me the excel sheet with your macro code but before
>> you send me the file required small changes do not use K & M column for
>> Chennel name & email address that is given just for information my actual
>> database is from A to G request you to kindly change the macro code
>> accordingly & send it back for the other checks also if you want u can
>> create the summary sheet with the help of macro & paste it on sheet 2 &
>> also for name u can use Column H for the proper output.1 more thing i want
>> to tell you that a have to send mail with our official signature so if u
>> can apply macro logic for the same also it would be very great ful to u.
>>
>> Request you to kindly make the changes & resend it for the final check
>>
>> Thanks in Advance & thanks for your time & support.
>>
>> On Mon, Nov 14, 2011 at 4:10 PM, deepu  wrote:
>>
>>> Hi Maulik,
>>>
>>> Below is the code that you're looking for...
>>> Insert a module in your workbook and paste the following code and run
>>> it...
>>>
>>>
>>> ---
>>> Dim MyArray() As Variant, ListArray() As Variant
>>> Dim R As Long, C As Integer, LastRow As Long, i As Long
>>> Dim OutObj As Object, EmailObj As Object, EmailBody As String, RecAdd
>>> As String
>>> Sub PrepareData()
>>> 'Assigning values to MyArray
>>> LastRow = Sheet1.Range("A6").End(xlUp).Row
>>> MyArray = Sheet1.Range("A7:G" & LastRow).Value
>>>
>>> 'Assigning values to ListArray
>>> LastRow = Sheet1.Range("K6").End(xlUp).Row
>>> ListArray = Sheet1.Range("K7:M" & LastRow).Value
>>>
>>> For i = LBound(ListArray) To UBound(ListArray)
>>>RecAdd = ListArray(i, 3)
>>>EmailBody = "Hi " &
>>> Application.WorksheetFunction.Proper(ListArray(i, 2)) & ",>> Align=center>FYI..." & _
>>>"" & _
>>>">> Color=#FF>Customer Name" & _
>>>">> Color=#FF>Location" & _
>>>">> Color=#FF>Date" & _
>>>">> Color=#FF>Site" & _
>>>">> Color=#FF>Status" & _
>>>""
>>>
>>>For R = LBound(MyArray) To UBound(MyArray)
>>>If ListArray(i, 1) = MyArray(R, 6) Then
>>>For C = 1 To 5
>>>EmailBody = EmailBody & "" & _
>>>"" & MyArray(R, 1) & "" & _
>>>"" & MyArray(R, 2) & "" & _
>>>"" & MyArray(R, 3) & "" & _
>>>"" & MyArray(R, 4) & "" & _
>>>"" & MyArray(R, 5) & "" & _
>>>""
>>>Next C
>>>End If
>>>Next R
>>>Call SendEmail(RecAdd, EmailBody)
>>> Next i
>>> End Sub
>>>
>>> Sub SendEmail(ReceiptAdd As String, EBody As String)
>>> Set OutObj = CreateObject("Outlook.Application.12")
>>> Set EmailObj = OutObj.CreateItem(0)
>>>
>>> EmailBody = EmailBody & "" & _
>>> "RegardsXYZ"
>>>
>>> With EmailObj
>>>.To = ReceiptAdd
>>>.Subject = "Your Channels Data"
>>>.HTMLBody = EmailBody
>>>.Send
>>> End With
>>>
>>> End Sub
>>>
>>> ---
>>>
>>> Hope you'd like it.. Kindly contact to me if you face any problem...
>>>
>>> Regards
>>> Deepak
>>>
>>> On Nov 13, 10:00 pm, maulik desai  wrote:
>>> > Hi Team,
>>> >
>>> > I am having 1 excel sheet in that i have to prepare Chennel wise detail
>>> > report on a every week & i have to send that information to respective
>>> > chennel heads wia email ,
>>> > Manually i need to do filter the data base on chennal name & then copy
>>> data
>>> > from sheet & need to paste on mail body then i have to send the data to
>>> > that chennel head based on chennel name.
>>> >
>>> > My problem is i have to do same excerside many times as chennel name
>>> are
>>> > approxly 80
>>> >
>>> > Request you to kindly provide me the macro code witch can directly
>>> send the
>>> > email based