Re: $$Excel-Macros$$ Vlookup with more than one condition
Dear All
I am a member of this group for last more than 2 years.
I can proudly say that u will find the solutions(not solution) for all u r
problem.
By reading the above mail (from Noorani and Excel Learner) I got some
different feeling.So my suggestion is dont critise any one
Dont write any mail which will hurt someone
Shrinivas
On Sat, Sep 3, 2011 at 6:07 AM, Ms-Exl-Learner .
ms.exl.lear...@gmail.comwrote:
I am tired...
---
Ms.Exl.Learner
---
On Fri, Sep 2, 2011 at 11:48 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:
Dear MS.EXL.Learner,
Please see attached sheet...
**
Dear i better understand work and Concept of below mentioned
functionsi never denied to differencition between each
functions.
but at a time we can use a function for multiple purpose.
* *
*[vlookup, Index-Match, Offset-Match]* and *[Sumproduct, Sumifs, Dsum]*.
Thanks for your suggestion..
--
*Thanks regards,*
*Noorain Ansari*
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Sep 2, 2011 at 11:11 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.com wrote:
Hi Noorain Ansari,
Case-1
I have attached the same file for your reference and I have not changed
anything on it just created a duplicate data.
Now look at the excel file and see what are all the results your formula
is deriving. Whether all the results are same? Take my previous mail and
read it once again which is elaborated clearly without the help of the above
attachment about the differences *[vlookup, Index-Match, Offset-Match]*
and *[Sumproduct, Sumifs, Dsum]*.
Case-II
I know sumproduct very well and the method how we are using the function
will differentiate the sumproduct from other functions. But you have used
the sumproduct for a single cell, which can be done using the simple IF
function and there is no need to go for sumproduct. I just wanted to
highlight it to you, and that was I did.
Never create and suggest formula's based on the articles you read in
internet or book, understand the concept how the functions are working and
it's concept then only you can able to give exact solution.
Let me know if you need any further clarification.
---
Ms.Exl.Learner
---
On Fri, Sep 2, 2011 at 10:38 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Ms-Exl-Learner,
Thanks for your valuable suggestion..
Case -I, In case of duplicay all formulas are successfull working except
vlookup(vlookup) example.
You can see fresh attachement..
Case -II, You can't compare Sumproduct with If function both are
different..
Correct Syntex of Formula Should be..
=SUMPRODUCT((C3:C8=G3)*(D3:D8=H3)*E3:E8) .instead of
=SUMPRODUCT((F3=J3)*(G3=K3)*H3)
another way :
*{=LOOKUP(2,1/(C3:C8=G3)*(D3:D8=H3),E3:E8)}*
Keep Enjoy, Cheers..
--
Thanks regards,
Noorain Ansari
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Sep 2, 2011 at 9:51 PM, Ms-Exl-Learner .
ms.exl.lear...@gmail.com wrote:
Hi Noorain Ansari,
It might be better if you might have constructed your example data with
some duplicates, since the questioner can able to understand the
difference
between the *[vlookup, Index-Match, Offset-Match]* and *[Sumproduct,
Sumifs, Dsum]*.
The *First set of formula's / Functions* just get the first match as
result and never consider the next matches. But the *Second functions
* consider all the matches and derive the result by adding the values
of the all matches.
Please clarify me why the below formula should not be written
as =IF((F3=J3)*(G3=K3),H3,0) or =IF(AND((F3=J3),(G3=K3)),H3,0)???
=SUMPRODUCT((F3=J3)*(G3=K3)*H3)
You have provided the below formula to avoid the K3 cell criteria to be
automated by the formula
=VLOOKUP(VLOOKUP($J$3,$F$3:$G$8,2,0),$G$3:$H$8,2,0)
But,
It won't work fine when the K3 cell is having the 31-Aug as criteria
and the G5 cell have the 31-Aug.
---
Ms.Exl.Learner
---
On Fri, Sep 2, 2011 at 8:51 PM, NOORAIN ANSARI
noorain.ans...@gmail.com wrote:
Dear Haytham,
Please try below formula :
*=VLOOKUP(J3K3,$E$3:$H$3,4,0)*
*=VLOOKUP(VLOOKUP($J$3,$F$3:$G$8,2,0),$G$3:$H$8,2,0)*
other Alternative...
*=SUMPRODUCT((F3=J3)*(G3=K3)*H3)*
*{=INDEX($H$3:$H$8,MATCH(1,($F$3:$F$8=$J$3)*($G$3:$G$8=$K$3),0))}*
*{=OFFSET($H$2,MATCH(1,($F$3:$F$8=$J$3)*($G$3:$G$8=$K$3),0),0)}
=SUMIFS(H3:H8,F3:F8,J3,G3:G8,K3)*
*=DSUM($F$2:$H$8,H2,J2:K3)*
See attached sheet..
--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/
On Fri, Sep 2, 2011 at 5:02 PM, Haytham Zoromba
haythamzoro...@gmail.com wrote:
Dear all,
I have tried to search about using vlookup with more than one
condition.
Is their any one know a formula
RE: $$Excel-Macros$$ Counter in a Cell
Hi,
Paste the below macro in the ThisWorkbook module :
Private Sub Workbook_Open()
Application.OnKey {UP}, Plus
Application.OnKey {DOWN}, Minus
End Sub
Paste the bellows macros in a standard module :
Sub Plus()
With Sheets(Sheet1)
If ActiveSheet.Name = .Name Then
.[H11] = Application.Min(.[H11] + 1, 16)
End If
End With
End Sub
Sub Minus()
With Sheets(Sheet1)
If ActiveSheet.Name = .Name Then
.[H11] = Application.Max(.[H11] - 1, 0)
End If
End With
End Sub
Regards.
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : samedi 3 septembre 2011 03:13
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Counter in a Cell
Hi
In attached Sheet1, I want the cell to count from 0 to 16 up and down in
between. The count is of times up arrow and down arrow are pressed.
To set speed from, 0 to 16 for model railroad project.
Your advice appreciated.
Thanks
Charlie Harris
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
http://exceldailytip.blogspot.com
To post to this group, send email to mailto:excel-macros@googlegroups.com
excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$
Hello Haeruddin, Please send your Query.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sat, Sep 3, 2011 at 3:53 AM, Udin Haeruddin herumam...@gmail.com wrote: -- == Haeruddin, S.Pd == -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Counter in a Cell
Sorry,
In ThisWorkbook, change for :
Private Sub Workbook_Open()
Sheets(Sheet1).Activate
Application.OnKey {UP}, Plus
Application.OnKey {DOWN}, Moins
End Sub
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
If Sh.Name = Sheet1 Then
Application.OnKey {UP}, Plus
Application.OnKey {DOWN}, Moins
Else
Application.OnKey {UP},
Application.OnKey {DOWN},
End If
End Sub
Daniel
De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Cab Boose
Envoyé : samedi 3 septembre 2011 03:13
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Counter in a Cell
Hi
In attached Sheet1, I want the cell to count from 0 to 16 up and down in
between. The count is of times up arrow and down arrow are pressed.
To set speed from, 0 to 16 for model railroad project.
Your advice appreciated.
Thanks
Charlie Harris
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
Like our page on facebook , Just follow below link
http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Counter in a Cell
Use a SPIN button from the control toolbox. See atttached From: Cab Boose Sent: Friday, September 02, 2011 8:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Counter in a Cell Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel CellCountUpDown.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ extracting data from a datasheet
how to attach my file.? On Sep 1, 8:08 pm, ashish koul koul.ash...@gmail.com wrote: Can you attach the sample file On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar shankar.n...@gmail.comwrote: I made an userform with Empno, Name, Design, DOB textboxes with the save command. I am able to save the data. Now, I need code for updating the already contained data in a datasheet. How to retrieve data from datasheet basing the Empno and update (command button). Pls provide code. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ extracting data from a datasheet
Ya i attached. Pls provide me solution. On Sep 1, 8:08 pm, ashish koul koul.ash...@gmail.com wrote: Can you attach the sample file On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar shankar.n...@gmail.comwrote: I made an userform with Empno, Name, Design, DOB textboxes with the save command. I am able to save the data. Now, I need code for updating the already contained data in a datasheet. How to retrieve data from datasheet basing the Empno and update (command button). Pls provide code. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ Re: Counter in a Cell
On Sep 3, 2:12 am, Cab Boose swch...@gmail.com wrote: Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris CellCountUpDown.xls 18KViewDownload I don't believe this is possible, as pressing a key in a worksheet (i.e. the up or down arrows) does not generate a trappable event. Why not just have an up arrow shape that, when clicked increments the number? You could also define macros to increment / decrement the number and then assign them to a suitable keyboard shortcut such as Ctrl-U or Ctrl-D -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
RE: $$Excel-Macros$$ Counter in a Cell
Mr.Charlie, Please find the attached file. I have used Spin button (Form Control). It can be used another sheet linked with sheet 1 - H11 as you requested. - Xcel Inspiration From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Cab Boose Sent: 03 September 2011 05:13 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Counter in a Cell Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel CellCountUpDown.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ ***VBA code to copy and save as new book***
Hi Mahesh, Pzl find the workbook. I would like to ask one more doubt when i click the pivot table value (in the attached sheet summary)a new sheet is appearing. In that sheet all the amount columns are appearing in date format. Can you help me how to change get amount in number format and date in date format without changing manually every time. Thanks, Regards, Prabhu -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Report.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ extracting data from a datasheet
send the attachment in excel-macros@googlegroups.com email id On Sat, Sep 3, 2011 at 9:41 AM, Bheema Shankar shankar.n...@gmail.comwrote: how to attach my file.? On Sep 1, 8:08 pm, ashish koul koul.ash...@gmail.com wrote: Can you attach the sample file On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar shankar.n...@gmail.com wrote: I made an userform with Empno, Name, Design, DOB textboxes with the save command. I am able to save the data. Now, I need code for updating the already contained data in a datasheet. How to retrieve data from datasheet basing the Empno and update (command button). Pls provide code. -- --- --- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials athttp://www.excel-macros.blogspot.com 4. Learn VBA Macros athttp://www.quickvba.blogspot.com 5. Excel Tips and Tricks athttp://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- . -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
$$Excel-Macros$$ date in range
Dear Experts, I have attached my part of project file. plz see it and give me solution. regards sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel calendardemo.xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ date in range
Paste the below macro into the sheet module : Option Explicit Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean) If Intersect(Target, [G11:G23]) Is Nothing Then Exit Sub Cancel = True frmCalendar.Show End Sub Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de SAJID MEMON Envoyé : samedi 3 septembre 2011 19:24 À : Excel Group Objet : $$Excel-Macros$$ date in range Dear Experts, I have attached my part of project file. plz see it and give me solution. regards sajid memon -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Counter in a Cell
Hi Everbody Thanks for all your options. I would like to explain a little more. I want a small 5 pad keyboard to plug usb into laptop. Operator will not necessary have access to screen. The operator will just use up or down button to change the speed. So the H11 will need to be frozen I guess and then count the ups and downs and show a number in that cell. Daniel - your macro looks like doing as required, but I have tried with cursor in H11 and press the up or down, message comes up with unable to find macro. Now I have your second emailed macro in the Wookbook module. Do I still need some of the macro in the first email in a module? Attached workbook as I have at the moment. Appreciate all your work everyone. thanks Charlie Harris On Sun, Sep 4, 2011 at 3:18 AM, Excel Inspiration xcel.inspirat...@gmail.com wrote: Mr.Charlie, ** ** Please find the attached file. I have used Spin button (Form Control). It can be used another sheet linked with sheet 1 – H11 as you requested. ** ** *- Xcel Inspiration*** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Cab Boose *Sent:* 03 September 2011 05:13 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Counter in a Cell ** ** Hi In attached Sheet1, I want the cell to count from 0 to 16 up and down in between. The count is of times up arrow and down arrow are pressed. To set speed from, 0 to 16 for model railroad project. Your advice appreciated. Thanks Charlie Harris -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Query
Dear Venkat Noorain Sir I am very thankful to you for sharing your precipus time helping me solve this task. Thanks Regards Shashi Ranjan On 1 September 2011 15:09, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Shashi, Please see attached sheet if it help to u... On Thu, Sep 1, 2011 at 2:22 PM, shashi shashi2...@gmail.com wrote: Dear Venkat I have second condtion that i want payout amount datewise. I want an urgent help on condition function. In this data i have the requirement of *Payout amount* for each branch in datewise without using On Aug 31, 10:15 pm, shashi shashi2...@gmail.com wrote: Dear Excel Guru's I want an urgent help on condition function. In this data i have the requirement of *Payout amount* for each branch in datewise without using pivot. Please help me in this query. Thanks Regards Shashi Ranjan Consolidation RI payout Data.xls 1512KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Re: Query
Dear Shasi, You are Welcome... *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Sun, Sep 4, 2011 at 8:37 AM, Shashi Ranjan shashi2...@gmail.com wrote: Dear Venkat Noorain Sir I am very thankful to you for sharing your precipus time helping me solve this task. Thanks Regards Shashi Ranjan On 1 September 2011 15:09, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Shashi, Please see attached sheet if it help to u... On Thu, Sep 1, 2011 at 2:22 PM, shashi shashi2...@gmail.com wrote: Dear Venkat I have second condtion that i want payout amount datewise. I want an urgent help on condition function. In this data i have the requirement of *Payout amount* for each branch in datewise without using On Aug 31, 10:15 pm, shashi shashi2...@gmail.com wrote: Dear Excel Guru's I want an urgent help on condition function. In this data i have the requirement of *Payout amount* for each branch in datewise without using pivot. Please help me in this query. Thanks Regards Shashi Ranjan Consolidation RI payout Data.xls 1512KViewDownload -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Thanks regards, Noorain Ansari *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- * * * * * * -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
