$$Excel-Macros$$ max length for textbox control

[Shankar Bheema]

Dear Experts

How to assign max length for a textbox control in MSAccess 2003.  In
properties, no such facility is available.  How can it be assigned through
Code.

regards
shankar sb

-- 
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

[maulik desai]

hi deepak,
thanks you so much for ur updated file but small correction required
that i can not able to use this file in 2O03, when i click on run its
highlighted 4th line of 'assiging values to list array part,request u
to kindly check the same and if u can add one more col next 2 'i' col
because now we have add the chennel name along with the subject , i m
sorry i now i m bothering very much but i just got the update for this
request you kindly make this 2 changes and resend the updated

thanks in advance and awaitng ur mail reply with changes

On 11/23/11, Deepak Pal Singh  wrote:
> Attached is the updated file, now you won't need to prepare a separate
> table to get channel wise unique email id's...
>
>
>
> On Mon, Nov 21, 2011 at 10:09 PM, maulik desai
> wrote:
>
>> Thanks Deepak, Actually those id;'s i cant disclose it but yes Email ids
>> are not common & it is also not based on channel name.its is based on
>> location wise & its always get change so i suggest you to kindly add the
>> new column after G or After M
>>
>> Actaully My Database is from A to G & if u add the new col then From A To
>> H , actually there is no summry sheet (From K to M ,if u want u can remove
>> the column L(person name ) from summary sheet & can add in main database
>> after col F so while macro prepares summry sheet it will be easy for me to
>> get data) i have just shown to u for ref
>>
>> actaully i want it like once i update the database in column A to H ,
>> Macro can create the summry sheet based on unique list & then send the
>> mail
>> to mail ids (from To & in CC fields)
>> Thanks
>> On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh <
>> deepaktheind...@gmail.com> wrote:
>>
>>> 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
>>>
>>>

Re: $$Excel-Macros$$ doubt with msaccess 2003

[Maries]

Hi,

use the below code. It will work.

Private Sub cmdnetser_Click()
Dim year1 As Double
Dim year2 As Double
Dim yearresult   As Double
Dim month1 As Double
Dim month2 As Double
Dim monthresult As Double
Dim day1 As Double
Dim day2 As Double
Dim dayresult As Double

' for net qualfying service
lblnetqs.Visible = True
lblnetyrs.Visible = True
txtnetyrs.Visible = True
lblnetmths.Visible = True
txtnetmths.Visible = True
lblnetdays.Visible = True
txtnetdays.Visible = True
year1 = ttotyrs
year2 = txtnonyrs
month1 = ttotmths
month2 = txtnonmths
day1 = ttotdays
day2 = txtnondays
If year1 > year2 And month1 > month2 And day1 > day2 Then
yearresult = year1 - year2
monthresult = month1 - month2
dayresult = day1 - day2
End If
txtnetyrs = yearresult
txtnetmths = monthresult
txtnetdays = dayresult
End Sub
Regards,

MARIES.

On Tue, Dec 13, 2011 at 12:43 PM, Shankar Bheema wrote:

> Good Afternoon
>
> I am in preparation of a calculation sheet for my office purpose in ms
> access 2003.  I am enclosing the file for your reference.  In the Form,
> Right Frame containing Qualifying service i am facing a problem.  When I
> click on "Yes" for the Non Qualifying Service, I have to give the years,
> months and days.  I have written a code in "Show Net Service" command
> button for obtaining the difference in the Net yers, net months and net
> days.  But it is not displaying. Pls provide 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
>

-- 
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$$ doubt with msaccess 2003

[Shankar Bheema]

thank you so much for your response.  I will try and get back to you with
the result.  If possible pls clarify my rest of doubts put in our community.

On Tue, Dec 13, 2011 at 4:06 PM, Maries  wrote:

>
> Hi,
>
> use the below code. It will work.
>
> Private Sub cmdnetser_Click()
> Dim year1 As Double
> Dim year2 As Double
> Dim yearresult   As Double
> Dim month1 As Double
> Dim month2 As Double
> Dim monthresult As Double
> Dim day1 As Double
> Dim day2 As Double
> Dim dayresult As Double
>
> ' for net qualfying service
> lblnetqs.Visible = True
> lblnetyrs.Visible = True
> txtnetyrs.Visible = True
> lblnetmths.Visible = True
> txtnetmths.Visible = True
> lblnetdays.Visible = True
> txtnetdays.Visible = True
> year1 = ttotyrs
> year2 = txtnonyrs
> month1 = ttotmths
> month2 = txtnonmths
> day1 = ttotdays
> day2 = txtnondays
> If year1 > year2 And month1 > month2 And day1 > day2 Then
> yearresult = year1 - year2
> monthresult = month1 - month2
> dayresult = day1 - day2
> End If
> txtnetyrs = yearresult
> txtnetmths = monthresult
> txtnetdays = dayresult
> End Sub
> Regards,
>
> MARIES.
>
> On Tue, Dec 13, 2011 at 12:43 PM, Shankar Bheema 
> wrote:
>
>> Good Afternoon
>>
>> I am in preparation of a calculation sheet for my office purpose in ms
>> access 2003.  I am enclosing the file for your reference.  In the Form,
>> Right Frame containing Qualifying service i am facing a problem.  When I
>> click on "Yes" for the Non Qualifying Service, I have to give the years,
>> months and days.  I have written a code in "Show Net Service" command
>> button for obtaining the difference in the Net yers, net months and net
>> days.  But it is not displaying. Pls provide 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
>>
>
>  --
> 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

[maulik desai]

hi kiran,
just uninstall the last antivirus pathes from system and try.

On 12/11/11, Kiran Kancherla  wrote:
>
> Hi Maulik,
>
> Good to know as there is a solution for that problem.
>
> Request you please share the same knowledge as I have same issue with me.
>
>
> Thanks,
>
>
> Sent on my BlackBerry® from Vodafone
> Thanks & Regards.
> Kiran
>
> -Original Message-
> From: maulik desai 
> Sender: excel-macros@googlegroups.com
> Date: Sun, 11 Dec 2011 14:31:50
> To: 
> Reply-To: excel-macros@googlegroups.com
> Subject: Re: $$Excel-Macros$$ Re: Email Macro required for mail Boday
>
> Hi  Sam
>
> Thanks for the update now my problem has resloved as i have checked with
> the IT people & they provide me the solution
> & now i m able to send mails
>
> On Sun, Dec 4, 2011 at 5:44 PM, Sam Mathai Chacko wrote:
>
>> IT administrators mostly disable this option in the office environment to
>> ensure that no unwanted risk lies open by taking off outlook security. If
>> you are not able to change the option, then I am afraid I do not have a
>> solution. Maybe someone from the forum can share some advice?
>>
>> Regards
>>
>> Sam Mathai Chacko
>>
>>
>> On Sun, Dec 4, 2011 at 12:59 PM, maulik desai
>> wrote:
>>
>>> Thanks sam,
>>>
>>> I just want to ask u that i have try the option at my house but i can not
>>> able to change the option in my office pc so is there any other option or
>>> any macro code for outlook which can solve my problem
>>>
>>> sorry for late reply.
>>>
>>>  On Tue, Nov 29, 2011 at 7:22 PM, Sam Mathai Chacko
>>> wrote:
>>>
 Go to Tools>Macro>Security>Programmatic Access>Never Warn

 Sam


 On Tue, Nov 29, 2011 at 8:28 AM, maulik desai
 wrote:

> Thanks you so much deepak for your great support lastly i just want to
> ask you 1 thing that when ever i clicked on
>
> Macro for mail send microsoft gives me pop up for stating that whould
> you like to send this mail (with allow or dinied option ) so every time
> i
> have to click allow buttion is there any why to remove this pop uo
> windlow
> rest everytrhing working fine
>
> pls revert with solution & thanks once again..
>  On Wed, Nov 23, 2011 at 10:14 AM, Deepak Pal Singh <
> deepaktheind...@gmail.com> wrote:
>
>> Attached is the updated file, now you won't need to prepare a separate
>> table to get channel wise unique email id's...
>>
>>
>>
>>
>> On Mon, Nov 21, 2011 at 10:09 PM, maulik desai > > wrote:
>>
>>> Thanks Deepak, Actually those id;'s i cant disclose it but yes Email
>>> ids are not common & it is also not based on channel name.its is
>>> based on
>>> location wise & its always get change so i suggest you to kindly add
>>> the
>>> new column after G or After M
>>>
>>> Actaully My Database is from A to G & if u add the new col then From
>>> A To H , actually there is no summry sheet (From K to M ,if u want u
>>> can
>>> remove the column L(person name ) from summary sheet & can add in
>>> main
>>> database after col F so while macro prepares summry sheet it will be
>>> easy
>>> for me to get data) i have just shown to u for ref
>>>
>>> actaully i want it like once i update the database in column A to H ,
>>> Macro can create the summry sheet based on unique list & then send
>>> the mail
>>> to mail ids (from To & in CC fields)
>>> Thanks
>>>  On Mon, Nov 21, 2011 at 10:56 AM, Deepak Pal Singh <
>>> deepaktheind...@gmail.com> wrote:
>>>
 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 <
 mauliksde...@gmail.com> 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
>>

Re: $$Excel-Macros$$ Help in preparing the column automatically

[dguillett1]

What happened to this code that I had offered? You can certainly add a 
provision to automatically mark your column.


Private Sub Worksheet_Change(ByVal Target As Range)
Dim tr As Long
If Target.Count > 1 Or Target.Row < 3 Then Exit Sub
tr = Target.Row
If Target.Column = 2 Then
Application.ScreenUpdating = False

Rows(tr - 1).Copy Rows(tr).Resize(2)
Cells(tr, "c").Resize(, 20).ClearContents
Rows(tr + 1).ClearContents
'Cells(tr, "b").Select

Application.ScreenUpdating = False

End If
End Sub


Don Guillett
SalesAid Software
dguille...@gmail.com
-Original Message- 
From: Ankit Agrawal

Sent: Saturday, December 10, 2011 9:54 PM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically

Dear Sir,

I had some confusion regarding my sheet now it has been clear.Please
find my new attachment.plz solve my below metion query

* I shell start from beginning.
* I have only two query.
* Need symbol in coloumn "I" i.e. "Agreement", if vendor
agreement(which mentioed in admin file) has expired on the date of
issuing SOW/PO no., then mark (x) or if agreement is valid then put
(ü). And Vendor is not in the agreement list than mark it (?)
* Another query is that I need SOW approved date is date of issuing
the No. but when I use (TODAY) function it change on daily basis

Suppose I put this formula =IF(I17="","",TODAY()) then it will change
on daily basis.

Regards,
Ankit

On 12/10/11, dguillett1  wrote:
I have developed columns A:E with a change event macro and data 
validation.

I still do NOT understand the rest,especially what date to use??

Private Sub Worksheet_Change(ByVal Target As Range)
Dim tr As Long
If Target.Count > 1 Or Target.Row < 3 Then Exit Sub
tr = Target.Row
If Target.Column = 2 Then
Application.ScreenUpdating = False
   Rows(tr - 1).Copy Rows(tr).Resize(2)
   Cells(tr, "c").Resize(, 20).ClearContents
   Rows(tr + 1).ClearContents
Application.ScreenUpdating = False
End If
End Sub

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

From: Ankit Agrawal
Sent: Saturday, December 10, 2011 1:13 AM
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Help in preparing the column automatically

Deal All,

PFA as per your query.

Regards,
Ankit


On Fri, Dec 9, 2011 at 8:19 PM, dguillett1  wrote:

  You need to give examples
  col b. could/should be from data validation list
  col a. incremented automatically when you enter col B. Example of next
number
  col c. same as col B using DV
  col I. “agreement sheet” ?
  col J. populated on what__occurring.

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

  From: Ankit Agrawal
  Sent: Friday, December 09, 2011 8:40 AM
  To: excel-macros
  Subject: $$Excel-Macros$$ Help in preparing the column automatically

  Dear Expert,

  Please help me to solve out query in attached excel.

  Here one excel file where I want to do some column automatically.

  Regards,
  Ankit
  --
  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

Re: $$Excel-Macros$$ No. of Occurrence of char in string

[dguillett1]

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

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

From: yogiyogi123 
Sent: Tuesday, December 13, 2011 1:45 AM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string

hai all :i form hyderabad i want learn VBA Course  can you suggest me  any 
books or institutions in hyderabad.


On Mon, Dec 12, 2011 at 8:18 PM, rajan verma  wrote:

  VBA Function Provided By Noorian is nice trick

  Try This  with Shift +Ctrl+Enter
  =SUM(IF(--CODE(MID(B3,ROW(INDIRECT("A1:A"&LEN(B3))),1))=CODE(C3),1,0))


  On Mon, Dec 12, 2011 at 8:00 PM, NOORAIN ANSARI  
wrote:

Dear Hanumant,

Please try it..

Function Count_character(rng As Range)
Dim str As Variant
str = Split(rng, "e")
Count_character = UBound(str)
End Function


-- 

Thanks & regards,
Noorain Ansari
http://excelmacroworld.blogspot.com/
http://noorain-ansari.blogspot.com/
On Sat, Dec 10, 2011 at 1:40 AM, hanumant shinde  
wrote:

  Hi All,

  it was an interview que.

  how will you find number of occurrence of any character from string.
  he said you can do it using 1 excel formula or you can use VBA.

  can somebody tell me the answer in both Excel as well as in VBA.

  eg. if string is "excel" then there are 2 "e"s in this string.

  Thanks,
  Hanumant.
  -- 
  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
  Rajan verma
  +91 9158998701

  -- 
  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.
 
--

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

[dguillett1]

http://tinyurl.com/7yt37xy 


https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
 

http://tinyurl.com/8749ypq 
===
Don Guillett
SalesAid Software
dguille...@gmail.com

From: Amit Desai (MERU) 
Sent: Tuesday, December 13, 2011 9:51 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

Dear Friends,

 

I have attached one excel sheet. If you make any changes it is taking very long 
time.

 

Could you please check & suggest how to speed up its performance. It should not 
take more than few seconds to do any editing in this file!

 

Regards,

Amit Desai

 




Disclaimer: This message and its attachments contain confidential information 
and may also contain legally privileged information. This message is intended 
solely for the named addressee. If you are not the addressee indicated in this 
message (or authorized to receive for addressee), you may not copy or deliver 
any part of this message or its attachments to anyone or use any part of this 
message or its attachments. Rather, you should permanently delete this message 
and its attachments (and all copies) from your system and kindly notify the 
sender by reply e-mail. Any content of this message and its attachments that 
does not relate to the official business of Meru Cab Company Pvt. Ltd. must be 
taken not to have been sent or endorsed by any of them. Email communications 
are not private and no warranty is made that e-mail communications are timely, 
secure or free from computer virus or other defect.

-- 
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$$ Urgent help needed on Slow Excel Performance

[Jitendra singh]

dear all,
 how can i learn macro.
please suggest me.

Thanks & Regards
Jitendra Singh

On Tue, Dec 13, 2011 at 10:04 PM, dguillett1  wrote:

>   *http://tinyurl.com/7yt37xy*
>
>
>
> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
> **
> *http://tinyurl.com/8749ypq*
> ===
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Amit Desai (MERU) 
> *Sent:* Tuesday, December 13, 2011 9:51 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
>
>
> Dear Friends,
>
> 
>
> I have attached one excel sheet. If you make any changes it is taking very
> long time.
>
> 
>
> Could you please check & suggest how to speed up its performance. It
> should not take more than few seconds to do any editing in this file!
>
> 
>
> Regards,
>
> *Amit Desai*
>
> 
>
> --
> Disclaimer: This message and its attachments contain confidential
> information and may also contain legally privileged information. This
> message is intended solely for the named addressee. If you are not the
> addressee indicated in this message (or authorized to receive for
> addressee), you may not copy or deliver any part of this message or its
> attachments to anyone or use any part of this message or its attachments.
> Rather, you should permanently delete this message and its attachments (and
> all copies) from your system and kindly notify the sender by reply e-mail.
> Any content of this message and its attachments that does not relate to the
> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
> been sent or endorsed by any of them. Email communications are not private
> and no warranty is made that e-mail communications are timely, secure or
> free from computer virus or other defect.
> --
> 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

$$Excel-Macros$$ urgent query on dropdown list

[Sourabh Salgotra]

Dear Sir,
plz download the attached file. detail query in file.





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc

-- 
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


QUERY.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

[NOORAIN ANSARI]

Dear Jitender,

I would suggest you to go ahead and record macro and then watch and
relate these codes by your steps, which you had taken and start
understanding VBA.  You can also refer to the Group's learning
material and find below excel macro ebook..
http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm
-- 
Thanks & regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/* 
On Tue, Dec 13, 2011 at 10:34 PM, Jitendra singh wrote:

> dear all,
>  how can i learn macro.
> please suggest me.
>
> Thanks & Regards
> Jitendra Singh
>
> On Tue, Dec 13, 2011 at 10:04 PM, dguillett1  wrote:
>
>>   *http://tinyurl.com/7yt37xy*
>>
>>
>>
>> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
>> **
>> *http://tinyurl.com/8749ypq*
>> ===
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Amit Desai (MERU) 
>> *Sent:* Tuesday, December 13, 2011 9:51 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
>>
>>
>> Dear Friends,
>>
>> 
>>
>> I have attached one excel sheet. If you make any changes it is taking
>> very long time.
>>
>> 
>>
>> Could you please check & suggest how to speed up its performance. It
>> should not take more than few seconds to do any editing in this file!
>>
>> 
>>
>> Regards,
>>
>> *Amit Desai*
>>
>> 
>>
>> --
>> Disclaimer: This message and its attachments contain confidential
>> information and may also contain legally privileged information. This
>> message is intended solely for the named addressee. If you are not the
>> addressee indicated in this message (or authorized to receive for
>> addressee), you may not copy or deliver any part of this message or its
>> attachments to anyone or use any part of this message or its attachments.
>> Rather, you should permanently delete this message and its attachments (and
>> all copies) from your system and kindly notify the sender by reply e-mail.
>> Any content of this message and its attachments that does not relate to the
>> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
>> been sent or endorsed by any of them. Email communications are not private
>> and no warranty is made that e-mail communications are timely, secure or
>> free from computer virus or other defect.
>> --
>> 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

Re: $$Excel-Macros$$ Urgent help needed on Slow Excel Performance

[Jitendra singh]

Dear Noorain,
Thanks.
Regards
Jitendra Singh

On Tue, Dec 13, 2011 at 11:01 PM, NOORAIN ANSARI
wrote:

> Dear Jitender,
>
> I would suggest you to go ahead and record macro and then watch and
> relate these codes by your steps, which you had taken and start
> understanding VBA.  You can also refer to the Group's learning
> material and find below excel macro ebook..
>
> http://www.4shared.com/document/Kd7W3YMN/MicrosofExcel2007VBAMacroProgr.htm
> --
> Thanks & regards,
> Noorain Ansari
>  *http://excelmacroworld.blogspot.com/*
> *http://noorain-ansari.blogspot.com/*
> On Tue, Dec 13, 2011 at 10:34 PM, Jitendra singh wrote:
>
>> dear all,
>>  how can i learn macro.
>> please suggest me.
>>
>> Thanks & Regards
>> Jitendra Singh
>>
>> On Tue, Dec 13, 2011 at 10:04 PM, dguillett1 wrote:
>>
>>>   *http://tinyurl.com/7yt37xy*
>>>
>>>
>>>
>>> https://login.live.com/login.srf?wa=wsignin1.0&rpsnv=11&checkda=1&ct=1323793906&rver=6.0.5276.0&wp=MCLBI&wlcxt=msdn%24msdn%24msdn&wreply=http%3a%2f%2fmsdn.microsoft.com%2fen-us%2flibrary%2faa730921%2528v%3doffice.12%2529.aspx&lc=1033&id=254354&mkt=en-US
>>> **
>>> *http://tinyurl.com/8749ypq*
>>> ===
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Amit Desai (MERU) 
>>> *Sent:* Tuesday, December 13, 2011 9:51 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ Urgent help needed on Slow Excel Performance
>>>
>>>
>>> Dear Friends,
>>>
>>> 
>>>
>>> I have attached one excel sheet. If you make any changes it is taking
>>> very long time.
>>>
>>> 
>>>
>>> Could you please check & suggest how to speed up its performance. It
>>> should not take more than few seconds to do any editing in this file!***
>>> *
>>>
>>> 
>>>
>>> Regards,
>>>
>>> *Amit Desai*
>>>
>>> 
>>>
>>> --
>>> Disclaimer: This message and its attachments contain confidential
>>> information and may also contain legally privileged information. This
>>> message is intended solely for the named addressee. If you are not the
>>> addressee indicated in this message (or authorized to receive for
>>> addressee), you may not copy or deliver any part of this message or its
>>> attachments to anyone or use any part of this message or its attachments.
>>> Rather, you should permanently delete this message and its attachments (and
>>> all copies) from your system and kindly notify the sender by reply e-mail.
>>> Any content of this message and its attachments that does not relate to the
>>> official business of Meru Cab Company Pvt. Ltd. must be taken not to have
>>> been sent or endorsed by any of them. Email communications are not private
>>> and no warranty is made that e-mail communications are timely, secure or
>>> free from computer virus or other defect.
>>>  --
>>> 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 Hel

Re: $$Excel-Macros$$ urgent query on dropdown list

[dguillett1]

You don’t say what you are to do with the SECOND drop down. Seems that it 
should not be a drop down.
Anyway, a macro can:
1. make a list from your existing full list
2. As each name is selected, remove it from the created list. Or, if no longer 
needed, the original list. 
etc

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

From: Sourabh Salgotra 
Sent: Tuesday, December 13, 2011 11:21 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ urgent query on dropdown list


Dear Sir,
plz download the attached file. detail query in file.





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc


-- 
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$$ Reduce the Size

[Jitendra singh]

Dear all expert,

Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the
Size without touch  data.

Thanks and Regards
Jitendra Singh

-- 
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$$ Reduce the Size

[Nikhil Shah]

Dear Jitendra,

Pl visit following URL

http://www.excelitems.com/2010/11/shrink-reduce-excel-file-size.html

Regards

Nikhil Shah

On Tue, Dec 13, 2011 at 11:55 PM, Jitendra singh wrote:

> Dear all expert,
>
> Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the
> Size without touch  data.
>
> Thanks and Regards
> Jitendra Singh
>
> --
> 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$$ Reduce the Size

[Paul Schreiner]

 Not enough info.

What version of Excel are you using?
What file format? (.xls, .xlt, .xlsx, .xlsm)

If you're using Office 2007 or 2010, then you have lots of options.

I have a file with 90,000 rows an over 70 columns.
In Excel 97, (which truncates at 64,000 rows) the file is 80Mb
In Excel 2007, file type .xlsm the file is 46Mb
in Excel 2007, file type .xlsb the file is 14.6Mb
 
Paul
-
“Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-





From: Jitendra singh 
To: excel-macros@googlegroups.com
Sent: Tue, December 13, 2011 1:25:58 PM
Subject: $$Excel-Macros$$ Reduce the Size


Dear all expert,
Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the Size 
without touch  data.


Thanks and Regards 
Jitendra Singh-- 
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$$ Reduce the Size

[Jitendra singh]

thanks for all

On Wed, Dec 14, 2011 at 12:09 AM, Paul Schreiner wrote:

>  Not enough info.
>
> What version of Excel are you using?
> What file format? (.xls, .xlt, .xlsx, .xlsm)
>
> If you're using Office 2007 or 2010, then you have lots of options.
>
> I have a file with 90,000 rows an over 70 columns.
> In Excel 97, (which truncates at 64,000 rows) the file is 80Mb
> In Excel 2007, file type .xlsm the file is 46Mb
> in Excel 2007, file type .xlsb the file is 14.6Mb
>
>
> *Paul*
>
> -
> *“Do all the good you can,
> By all the means you can,
> In all the ways you can,
> In all the places you can,
> At all the times you can,
> To all the people you can,
> As long as ever you can.” - John Wesley
> *-
>
>
>  --
> *From:* Jitendra singh 
> *To:* excel-macros@googlegroups.com
> *Sent:* Tue, December 13, 2011 1:25:58 PM
> *Subject:* $$Excel-Macros$$ Reduce the Size
>
>  Dear all expert,
>
> Too much data in my Excel sheet. The Size is 700 mb. i Want to reduce the
> Size without touch  data.
>
> Thanks and Regards
> Jitendra Singh
>
> --
> 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$$ urgent query on dropdown list

[Yahya Muhammad]

Dear Saurabh

Please visit below url. A similar case is neatly explained there.

http://www.get-digital-help.com/2010/07/17/create-dependent-drop-down-lists-containing-unique-distinct-values-in-excel/



Regards

Yahya





On Tue, Dec 13, 2011 at 9:05 PM, dguillett1  wrote:

>   You don’t say what you are to do with the SECOND drop down. Seems that
> it should not be a drop down.
> Anyway, a macro can:
> 1. make a list from your existing full list
> 2. As each name is selected, remove it from the created list. Or, if no
> longer needed, the original list.
> etc
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sourabh Salgotra 
> *Sent:* Tuesday, December 13, 2011 11:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ urgent query on dropdown list
>
>
> Dear Sir,
> plz download the attached file. detail query in file.
>
>
>
> 
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.cc
>
>
> --
> 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$$ No. of Occurrence of char in string

[Rohan]

This will count the input that the user makes in the input box prompt
and will display the count in a Message Box.


Sub Test()

Dim StartVal As Integer
Dim Count As Integer
Dim InputCount As Variant

InputCount = InputBox("Please enter the input u want to count")

For StartVal = 1 To Len(Range("A1"))
Range("D1").Value = Mid(Range("A1"), StartVal, 1)
If Range("D1").Value = InputCount Then
Count = Count + 1
End If
Next StartVal
MsgBox Count
End Sub

-- 
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$$ Re: VBA code automatic typesetting and show code row number

[Rohan]

Garcia,

Not sure what exactly you're asking for. If I understand, you want to
record steps in Excel and see the VBA for the same ??

-- 
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$$ No. of Occurrence of char in string

[hanumant shinde]

Dear Noorain,

UDF is superb. i modified it a bit. i am passing string also on which it should 
split.

Function Count_character(rng As Range, word As String)
Dim str
str = Split(rng, word)
Count_character = UBound(str)
End Function


thanks a lot




>
> From: NOORAIN ANSARI 
>To: excel-macros@googlegroups.com 
>Sent: Monday, 12 December 2011 8:00 PM
>Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string
> 
>
>Dear Hanumant,
> 
>Please try it..
> 
>Function Count_character(rng As Range)
>Dim str As Variant
>str = Split(rng, "e")
>Count_character = UBound(str)
>End Function
>
>
>-- 
>
>Thanks & regards,
>Noorain Ansari
>http://excelmacroworld.blogspot.com/
>http://noorain-ansari.blogspot.com/
>On Sat, Dec 10, 2011 at 1:40 AM, hanumant shinde  
>wrote:
>
>Hi All,
>>
>>
>>it was an interview que.
>>
>>
>>how will you find number of occurrence of any character from string.
>>he said you can do it using 1 excel formula or you can use VBA.
>>
>>
>>can somebody tell me the answer in both Excel as well as in VBA.
>>
>>
>>eg. if string is "excel" then there are 2 "e"s in this string.
>>
>>
>>Thanks,
>>Hanumant.-- 
>>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$$ No. of Occurrence of char in string

[hanumant shinde]

Thanks Rohan, :)

Noorain has given 1 very easy code
Dim str
str = Split(rng, word)
Count_character = UBound(str)




>
> From: Rohan 
>To: MS EXCEL AND VBA MACROS  
>Sent: Wednesday, 14 December 2011 1:06 AM
>Subject: Re: $$Excel-Macros$$ No. of Occurrence of char in string
> 
>This will count the input that the user makes in the input box prompt
>and will display the count in a Message Box.
>
>
>Sub Test()
>
>    Dim StartVal As Integer
>    Dim Count As Integer
>    Dim InputCount As Variant
>
>    InputCount = InputBox("Please enter the input u want to count")
>
>    For StartVal = 1 To Len(Range("A1"))
>        Range("D1").Value = Mid(Range("A1"), StartVal, 1)
>        If Range("D1").Value = InputCount Then
>            Count = Count + 1
>        End If
>        Next StartVal
>        MsgBox Count
>End Sub
>
>-- 
>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$$ urgent query on dropdown list

[Sourabh Salgotra]

through 2nd dropdown i want the extract the information of that student
whose name & enroll no is selected.



On Tue, Dec 13, 2011 at 11:35 PM, dguillett1  wrote:

>   You don’t say what you are to do with the SECOND drop down. Seems that
> it should not be a drop down.
> Anyway, a macro can:
> 1. make a list from your existing full list
> 2. As each name is selected, remove it from the created list. Or, if no
> longer needed, the original list.
> etc
>
> Don Guillett
> SalesAid Software
> dguille...@gmail.com
>
>  *From:* Sourabh Salgotra 
> *Sent:* Tuesday, December 13, 2011 11:21 AM
> *To:* excel-macros@googlegroups.com
> *Subject:* $$Excel-Macros$$ urgent query on dropdown list
>
>
> Dear Sir,
> plz download the attached file. detail query in file.
>
>
>
> 
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.cc
>
>
> --
> 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
>



-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc

-- 
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$$ urgent query on dropdown list

[Sourabh Salgotra]

*in the following formula plz explain the marked section how it become *

{11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1

*
*

*Convert text to numbers*

=INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1:B1, List))*(*COUNTIF(List,
">"&List)+1*))=(COUNTIF(List, ">"&List)+1), 0, 1), 0))

COUNTIF(range,criteria) counts the number of cells within a range that meet
the given condition

COUNTIF(List, ">"&List)+1

becomes

COUNTIF({"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"},
">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"})+1

becomes

{11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1

becomes

{12;10;6;10;4;14;6;4;12;3;6;1;1;6}

On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra wrote:

> through 2nd dropdown i want the extract the information of that student
> whose name & enroll no is selected.
>
>
>
> On Tue, Dec 13, 2011 at 11:35 PM, dguillett1  wrote:
>
>>   You don’t say what you are to do with the SECOND drop down. Seems that
>> it should not be a drop down.
>> Anyway, a macro can:
>> 1. make a list from your existing full list
>> 2. As each name is selected, remove it from the created list. Or, if no
>> longer needed, the original list.
>> etc
>>
>> Don Guillett
>> SalesAid Software
>> dguille...@gmail.com
>>
>>  *From:* Sourabh Salgotra 
>> *Sent:* Tuesday, December 13, 2011 11:21 AM
>> *To:* excel-macros@googlegroups.com
>> *Subject:* $$Excel-Macros$$ urgent query on dropdown list
>>
>>
>> Dear Sir,
>> plz download the attached file. detail query in file.
>>
>>
>>
>> 
>>
>>
>> Thanks & Regards
>> Sourabh
>> Contact Numbers: +91-94630-49202
>> Website:http://adhurapyaar.co.cc
>>
>>
>> --
>> 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
>>
>
>
>
> --
> mujhay dukh is baat ka nahin kay meri zaat ko
> muntashir karny walay haath tairy thy
> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
> samaitnay walay haath tairy na thy
>
>
>
>
> 
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.cc
>
>
>


-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy





Thanks & Regards
Sourabh
Contact Numbers: +91-94630-49202
Website:http://adhurapyaar.co.cc

-- 
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.

$$Excel-Macros$$ Re: VBA code automatic typesetting and show code row number

[Garcia]

Thanks, Rohan,
I'm sorry not to clear my requirement,. when i finished my code in VBA
edition, i hope their is a format tool,so i can format better for my
VBA code,then VBA coding will be easy reader. also if i can get row
number ahead the code,i'll easy to know how many coding line and which
line used.

Garcia

On 12月14日, 上午3时51分, Rohan  wrote:
> Garcia,
>
> Not sure what exactly you're asking for. If I understand, you want to
> record steps in Excel and see the VBA for the same ??

-- 
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$$ urgent query on dropdown list

[Sourabh Salgotra]

thanks for help

plz explain the following fourmula

i have done everything with these fourmulas
=INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0))
=INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0))


but the list is not in sorted order.

On Wed, Dec 14, 2011 at 5:26 AM, Sourabh Salgotra wrote:

> *in the following formula plz explain the marked section how it become *
>
> {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1
>
> *
> *
>
> *Convert text to numbers*
>
> =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1:B1, List))*(*COUNTIF(List,
> ">"&List)+1*))=(COUNTIF(List, ">"&List)+1), 0, 1), 0))
>
> COUNTIF(range,criteria) counts the number of cells within a range that
> meet the given condition
>
> COUNTIF(List, ">"&List)+1
>
> becomes
>
> COUNTIF({"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"},
> ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"})+1
>
> becomes
>
> {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1
>
> becomes
>
> {12;10;6;10;4;14;6;4;12;3;6;1;1;6}
>
> On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra wrote:
>
>> through 2nd dropdown i want the extract the information of that student
>> whose name & enroll no is selected.
>>
>>
>>
>> On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 wrote:
>>
>>>   You don’t say what you are to do with the SECOND drop down. Seems
>>> that it should not be a drop down.
>>> Anyway, a macro can:
>>> 1. make a list from your existing full list
>>> 2. As each name is selected, remove it from the created list. Or, if no
>>> longer needed, the original list.
>>> etc
>>>
>>> Don Guillett
>>> SalesAid Software
>>> dguille...@gmail.com
>>>
>>>  *From:* Sourabh Salgotra 
>>> *Sent:* Tuesday, December 13, 2011 11:21 AM
>>> *To:* excel-macros@googlegroups.com
>>> *Subject:* $$Excel-Macros$$ urgent query on dropdown list
>>>
>>>
>>> Dear Sir,
>>> plz download the attached file. detail query in file.
>>>
>>>
>>>
>>> 
>>>
>>>
>>> Thanks & Regards
>>> Sourabh
>>> Contact Numbers: +91-94630-49202
>>> Website:http://adhurapyaar.co.cc
>>>
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> mujhay dukh is baat ka nahin kay meri zaat ko
>> muntashir karny walay haath tairy thy
>> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
>> samaitnay walay haath tairy na thy
>>
>>
>>
>>
>> 
>>
>>
>> Thanks & Regards
>> Sourabh
>> Contact Numbers: +91-94630-49202
>> Website:http://adhurapyaar.co.cc
>>
>>
>>
>
>
> --
> mujhay dukh is baat ka nahin kay meri zaat ko
> muntashir karny walay haath tairy thy
> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
> samaitnay walay haath tairy na thy
>
>
>
> 
>
>
> Thanks & Regards
> Sourabh
> Contact Numbers: +91-94630-49202
> Website:http://adhurapyaar.co.cc
>
>
>


-- 
mujhay dukh is baat ka nahin kay meri zaat ko
muntashir karny walay haath tairy thy
mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
samaitnay walay haath tairy na thy

Re: $$Excel-Macros$$ urgent query on dropdown list

[Sourabh Salgotra]

>
> i have done everything with these fourmulas
> =INDEX(sname,MATCH(0,COUNTIF($C$1:$C1,sname),0))
> =INDEX(eroll,MATCH(0,COUNTIF($B$1:$B1,eroll)+(sname<>image!$A$14),0))
>
>
> but the list is not in sorted order.
>



> plz explain the following fourmula
>
> *in the following formula plz explain the marked section how it become *
>
> {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1
>
> *
> *
>
> *Convert text to numbers*
>
> =INDEX(List, MATCH(0, IF(MAX(NOT(COUNTIF($B$1:B1, List))*(*COUNTIF(List,
> ">"&List)+1*))=(COUNTIF(List, ">"&List)+1), 0, 1), 0))
>
> COUNTIF(range,criteria) counts the number of cells within a range that
> meet the given condition
>
> COUNTIF(List, ">"&List)+1
>
> becomes
>
> COUNTIF({"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"},
> ">"&{"DD";"EE";"FF";"EE";"GG";"BB";"FF";"GG";"DD";"TT";"FF";"VV";"VV";"FF"})+1
>
> becomes
>
> {11;9;5;9;3;13;5;3;11;2;5;0;0;5}+1
>
> becomes
>
> {12;10;6;10;4;14;6;4;12;3;6;1;1;6}
>
> *
>> *
>>
>> On Wed, Dec 14, 2011 at 4:27 AM, Sourabh Salgotra 
>> wrote:
>>
>>> through 2nd dropdown i want the extract the information of that student
>>> whose name & enroll no is selected.
>>>
>>>
>>>
>>> On Tue, Dec 13, 2011 at 11:35 PM, dguillett1 wrote:
>>>
   You don’t say what you are to do with the SECOND drop down. Seems
 that it should not be a drop down.
 Anyway, a macro can:
 1. make a list from your existing full list
 2. As each name is selected, remove it from the created list. Or, if no
 longer needed, the original list.
 etc

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

  *From:* Sourabh Salgotra 
 *Sent:* Tuesday, December 13, 2011 11:21 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ urgent query on dropdown list


 Dear Sir,
 plz download the attached file. detail query in file.



 


 Thanks & Regards
 Sourabh
 Contact Numbers: +91-94630-49202
 Website:http://adhurapyaar.co.cc


 --
 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

>>>
>>>
>>>
>>> --
>>> mujhay dukh is baat ka nahin kay meri zaat ko
>>> muntashir karny walay haath tairy thy
>>> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
>>> samaitnay walay haath tairy na thy
>>>
>>>
>>>
>>>
>>> 
>>>
>>>
>>> Thanks & Regards
>>> Sourabh
>>> Contact Numbers: +91-94630-49202
>>> Website:http://adhurapyaar.co.cc
>>>
>>>
>>>
>>
>>
>> --
>> mujhay dukh is baat ka nahin kay meri zaat ko
>> muntashir karny walay haath tairy thy
>> mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko
>> samaitnay walay haath tairy na thy
>>
>>
>>
>> 
>>
>>
>> Thanks & Regards
>> Sourabh
>> Contact Numbers: +91-94630-49202
>> Website:http://adhurapyaar.co.cc
>>
>>
>>
>
>
> --
> mujhay dukh is baat ka nahin kay meri zaat ko
> muntashir karny walay haath tairy 

$$Excel-Macros$$ Insert rows in tables for comparison

[Darwin Chan]

Dear all,

I have 2 tables concerning sales volume of several customers across 2
months. I want to make a comparison on the sales volume, however, some
customer buy service in previous month may not buy in the next month and
vice versa. This makes such a  tedious task by inserting rows in both
tables and fill up with zero and then to calculate the change in sales
volume. Does anyone have solutions to create a macro or any other solutions?

Below please find the attachment.

-- 
Darwin Chan
darwin.chankaw...@gmail.com
kw42c...@yahoo.com.hk

-- 
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


Insert row question.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ How to create a double click using VBA CODE without actually double clicking on the mouse

[Aju Chacko]

Dear experts,
Kindly help me with vba code for the following problem
,I have created a macro *that trap the event DOUBLE CLICKING* of mouse,But
i want to optimize in such a way that the *user need not double click each
time with the mouse*,Instead I want to create *double click of mouse using
VBA CODE*,so when this code *create double click event* ,the code written
for this event will get fired.

Thanking
you in advance

Aju V 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

$$Excel-Macros$$ Inventory management

[manhar prajapati]

Hi

any one have inventory management worksheet???

If yes please provide me as i have manufacturing unit i want for my company

Regards
Manhar Prajapati

--

-- 
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$$ Plz help urgent

[Anil Saxena]

Plz let me know that how can possible to % in pivot table. base of Caller.

Plz show the snap short also.

-- 
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


Merge Mumbai Calling (13-Dec-11).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Inventory management

[arif massani]

http://www.excel-skills.com/excel_templates.asp#InventoryUsage
See This Link May Help you

Or Contact me on my personal email address
arifmass...@gmail.com

On Wed, Dec 14, 2011 at 12:00 PM, manhar prajapati <
prajapati.man...@gmail.com> wrote:

> Hi
>
> any one have inventory management worksheet???
>
> If yes please provide me as i have manufacturing unit i want for my company
>
> Regards
> Manhar Prajapati
>
> --
>
>
>
>  --
> 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
>



-- 
Arif Mansoorali Massani
Bhavnagar
State Gujarat, India
M. +91-8530292142
 http://arifmassani.webs.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$$ Inventory management

[sushil kumar]

Hi Manhar,

Please see this link http://31.222.142.10:8080/openerp/login?db=&user=

Database:ManufacturingM
User: admin
password:admin1
This is opensource application if you want we can setup for you and
customize according to your need

Looking foward to help you

Thanks,
Sushil


On Wed, Dec 14, 2011 at 12:10 PM, arif massani wrote:

> http://www.excel-skills.com/excel_templates.asp#InventoryUsage
> See This Link May Help you
>
> Or Contact me on my personal email address
> arifmass...@gmail.com
>
>
> On Wed, Dec 14, 2011 at 12:00 PM, manhar prajapati <
> prajapati.man...@gmail.com> wrote:
>
>> Hi
>>
>> any one have inventory management worksheet???
>>
>> If yes please provide me as i have manufacturing unit i want for my
>> company
>>
>> Regards
>> Manhar Prajapati
>>
>> --
>>
>>
>>
>> --
>> 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
>>
>
>
>
> --
> Arif Mansoorali Massani
> Bhavnagar
> State Gujarat, India
> M. +91-8530292142
> http://arifmassani.webs.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$$ Plz help urgent

[B.N.Chethan Kumar]

Please find the data in required format.

Regards
Chethan Kumar BN

On Wed, Dec 14, 2011 at 12:46 PM, Anil Saxena wrote:

> Plz let me know that how can possible to % in pivot table. base of Caller.
>
> Plz show the snap short also.
>
> --
> 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
>



-- 
B.N Chetan kumar

-- 
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


Merge_Mumbai_Calling_(13-Dec-11).xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Inventory management

[manhar prajapati]

Dear Sushil Kumarji

Its very Nice how can i use it for my organistion.

Looking for your reply.

Manhar

On Wed, Dec 14, 2011 at 12:56 PM, sushil kumar wrote:

> Hi Manhar,
>
> Please see this link http://31.222.142.10:8080/openerp/login?db=&user=
>
> Database:ManufacturingM
> User: admin
> password:admin1
> This is opensource application if you want we can setup for you and
> customize according to your need
>
> Looking foward to help you
>
> Thanks,
> Sushil
>
>
> On Wed, Dec 14, 2011 at 12:10 PM, arif massani wrote:
>
>> http://www.excel-skills.com/excel_templates.asp#InventoryUsage
>> See This Link May Help you
>>
>> Or Contact me on my personal email address
>> arifmass...@gmail.com
>>
>>
>> On Wed, Dec 14, 2011 at 12:00 PM, manhar prajapati <
>> prajapati.man...@gmail.com> wrote:
>>
>>> Hi
>>>
>>> any one have inventory management worksheet???
>>>
>>> If yes please provide me as i have manufacturing unit i want for my
>>> company
>>>
>>> Regards
>>> Manhar Prajapati
>>>
>>> --
>>>
>>>
>>>
>>> --
>>> 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
>>>
>>
>>
>>
>> --
>> Arif Mansoorali Massani
>> Bhavnagar
>> State Gujarat, India
>> M. +91-8530292142
>> http://arifmassani.webs.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
>



--

-- 
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$$ Insert rows in tables for comparison

[B.N.Chethan Kumar]

Please find the table in comparsion model. I have used pivot table option.

Regards
Chethan kumar BN

On Wed, Dec 14, 2011 at 11:07 AM, Darwin Chan
wrote:

> Dear all,
>
> I have 2 tables concerning sales volume of several customers across 2
> months. I want to make a comparison on the sales volume, however, some
> customer buy service in previous month may not buy in the next month and
> vice versa. This makes such a  tedious task by inserting rows in both
> tables and fill up with zero and then to calculate the change in sales
> volume. Does anyone have solutions to create a macro or any other solutions?
>
>  Below please find the attachment.
>
> --
> Darwin Chan
> darwin.chankaw...@gmail.com
> kw42c...@yahoo.com.hk
>
> --
> 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
>



-- 
B.N Chetan kumar

-- 
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


Insert_row_question.xls
Description: MS-Excel spreadsheet

Re: $$Excel-Macros$$ Painting in excel............Amazing !

[Shaik Waheed]

Its amazing man, thanks for sharing



On Fri, Dec 9, 2011 at 11:37 PM, Nikhil Shah  wrote:

> Wow.. Wonderfull Sheet Mahesh..
>
> Thanks
>
> Nikhil Shah
>
>  On Fri, Dec 9, 2011 at 10:34 PM, Mahesh parab  wrote:
>
>> its really Amazing!
>>
>> check this link
>>
>> http://www.xcelfiles.com/ImageToXL.html
>>
>>
>>
>> HTH
>> Mahesh
>>
>> --
>> 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