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/
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
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
> passwo
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)
>
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,
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?
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, an
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,
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
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
tabl
>
> 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 t
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 Sa
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
*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) coun
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.
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 i
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: NOORA
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, Formul
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
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
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
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,
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 withou
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,
Urgen
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
SalesA
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.
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/
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 f
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&
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://tinyu
>> 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 hydera
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.ScreenU
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 BlackBe
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
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 Dou
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 n
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 t
37 matches
Mail list logo
