Re: $$Excel-Macros$$ Calculate Due dates
change dd-mmm- to dd-mmm' in formula On Sat, May 7, 2011 at 7:47 AM, Mr excel excelkeec...@gmail.com wrote: dear ashish,, That is excellent great.Thanks a lot .The formula u provided is very nearer to the solution i wanted.everthing is same except in the month column of the sheet.Name of the month should be printed like April'2011 instead of *05-Apr-2011 TO 04-May-2011*. the above formula also is very helpful to me in another scenario.. Really my joy knew no boundaries.. On Fri, May 6, 2011 at 6:46 AM, ashish koul koul.ash...@gmail.com wrote: try this one On Thu, May 5, 2011 at 9:11 PM, ashish koul koul.ash...@gmail.comwrote: see if it helps On Thu, May 5, 2011 at 7:23 AM, Mr excel excelkeec...@gmail.com wrote: For example, The billing cycle for supplier A is 5th of this month to 4th next so all the transactions pertaining to Supplier A will be billed in this period. Here in this example, there is only one transaction related to A and the billing is done for the month of jan'2011 so in the month column Jan'2011 should be displayed as this single transaction is done between 5th of Jan'2011-4th Feb'2011 Likewise for all the other suppliers… Hope I had made it clear. On Wed, May 4, 2011 at 9:57 PM, ashish koul koul.ash...@gmail.comwrote: can you expaln with some example in workbook On Tue, May 3, 2011 at 8:30 PM, keechak excelkeec...@gmail.comwrote: Hi forum, Thanks very much for creating such a wonderful forum. I had a problem in calculating the due dates for different customers. Col A contains suppliers with the dates they supply the raw material amount of the material supplied in the next columns B C Respectively. I need a formula or a vba routine which can calculate the due dates for all the suppliers who supply the material. There are certain cut-off dates for each supplier in calculating the due dates in the billing cycle table. I want to print the months in Column D basing upon the supply date for each supplier and the cut-off dates in the right side table(Billing Cycle -table). Please help me WebRep Overall rating -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://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 WebRep Overall rating -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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. -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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
$$Excel-Macros$$ Need Help
Hi, I need help in VBA code. I have excel sheet on which data is write as below mention Input A BC D 1 X1 1.511/11/2008 01/11/2010 2 X2 2.511/12/2009 01/11/2010 3 X3 3.511/01/2010 01/11/2010 I want Output in another sheet as given below Output A BC D 1 X1 1.011/11/2008 01/11/2010 1 X1 0.511/11/2008 01/11/2010 2 X2 2.011/12/2009 01/11/2010 2 X2 0.511/12/2009 01/11/2010 3 X3 3.011/01/2010 01/01/2010 3 X3 0.511/01/2010 01/01/2010 Procedure 1. Check column B if it contain decimal than separate integer and decimal i.e if value is 1.5 than insert row and split as mention above in output 2. Check C and D for date if C column Date is less than D Column than pick Date of D column other wise pick date of C Column. Can any body help me in this. Thanks in advance Anvesh -- -- 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$$ A small query, need your help in vba coding.
Private Sub CommandButton1_Click() Range(A65000).End(xlUp).Cells(2, 1) = Range(C1).Value: Range(A65000).End(xlUp).Cells(1, 2) = Range(D1).Value: End Sub On Sat, May 7, 2011 at 1:56 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, I have a little query in vba coding, please see the attached file. In the excel file there is a Save command button, whenever I press the button it will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my query is, if the data is already in the cell no. a1:b1 it will be saved in the next cell no. means a2:b2 then a3:b3 just going on like this, can anyone help me in that coding how do I create that loop? Thanks in advance. -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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$$ How to use Vlookup in macro
Hi All, I have excel database sheet I have created some excel output sheets (around 35 excel sheets) which gives me output data with the help of Vlookup fuction. But the problem is in every 3 months I have to change the database month name because of that I need to change the vlookup range also in output sheets manually (need to open each sheet change the new file name in that) Is there any way that whenever I changed the file name of database ,the same new range also updated in output sheets automatically. Thanks In advance. -- Thanks Regards, Maulik Desai -- -- 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$$ MkDir (ThisWorkbook.Path \33)
thanks Ranjan. one more query.. is there a way if there is any folder with the same name..it will go into the folder.. and if the file is in the same name it will replace the file with the new one. Application.ScreenUpdating = False Sheet1.Visible = xlSheetVisible Sheet1.Activate ActiveSheet.Copy Application.DisplayAlerts = False MkDir (ThisWorkbook.Path \ Sheet3.Range(M11)) ActiveSheet.SaveAs Filename:=ThisWorkbook.Path \ Sheet3.Range(M11) \ Sheet3.Range(M6) .xls ActiveWorkbook.Close Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub On 6 May 2011 16:45, rajan verma rajanverma1...@gmail.com wrote: Sub MkDir() Dim fso As New Scripting.FileSystemObject fso.CreateFolder (ThisWorkbook.Path \ *GiveThecellReferenceHere*) End Sub On Fri, May 6, 2011 at 4:43 PM, rajan verma rajanverma1...@gmail.comwrote: Sub MkDir() Dim fso As New Scripting.FileSystemObject fso.CreateFolder (ThisWorkbook.Path \ 33) End Sub On Fri, May 6, 2011 at 1:31 PM, Pravin Kumar pravin.si...@gmail.comwrote: Hi I want to create one folder in the same folder... MkDir (ThisWorkbook.Path \33) this will create a folder with the name 33. I want to link the name with a cell so that if the value is 34 the created folder name will be 34. if the cell value is 38 the folder name should be 38. Pls help. Thanks Pravin -- -- 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 -- Regards Rajan verma +91 9158998701 -- Regards Rajan verma +91 9158998701 -- -- 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$$ Please Help
* LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- 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 Help.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ NEED HELP - GET PIVOT
When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks regards On 5/6/11, mayur zinknax.zin...@gmail.com wrote: Thank you all... Have a great Weekend :) On Fri, May 6, 2011 at 8:54 AM, rajan verma rajanverma1...@gmail.comwrote: Find the attached File.. On Fri, May 6, 2011 at 5:20 PM, mayur zinknax.zin...@gmail.com wrote: Hi All, I need help on get pivot formula for getting average of last three days score. Please find attached sheet, is more self explanatory. G:18 is expected result. Can somebody help on this. -- Thanks in advance. Mayur -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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$$ Please Help
try the attachment On Sat, May 7, 2011 at 2:20 PM, karan 1237 karan1...@gmail.com wrote: * LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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 Help(1).xlsm Description: Binary data
Re: $$Excel-Macros$$ A small query, need your help in vba coding.
When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks regards On 5/7/11, STDEV(i) setiyowati.d...@gmail.com wrote: just a little modif: Private Sub CommandButton1_Click() Dim R As Long * R = Cells(Rows.Count, 1).End(xlUp).Row + 1* Cells(R, 1) = Cells(1, 3) Cells(R, 2) = Cells(1, 4) End Sub On Sat, May 7, 2011 at 11:38 AM, rajan verma rajanverma1...@gmail.comwrote: It macro will not work properly if these is any blank row between the Data.. It will all time replace existing Data.. On Sat, May 7, 2011 at 8:56 AM, STDEV(i) setiyowati.d...@gmail.comwrote: Dear Indrajit please try this code Private Sub CommandButton1_Click() ' siti Vi / jakarta, May 07, 2011 Dim R As Long R = WorksheetFunction.CountA(Range(A:A)) + 1 Cells(R, 1) = Cells(1, 3) Cells(R, 2) = Cells(1, 4) End Sub On Sat, May 7, 2011 at 3:26 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, I have a little query in vba coding, please see the attached file. In the excel file there is a Save command button, whenever I press the button it will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my query is, if the data is already in the cell no. a1:b1 it will be saved in the next cell no. means a2:b2 then a3:b3 just going on like this, can anyone help me in that coding how do I create that loop? Thanks in advance. -- Indrajit -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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$$ Macro to send email automatically.
When copying excel files, the following problems: PROBLEM 1 1). The settings of the Margins are getting disturbed PROBLEM 2 Also when you take a print out, the @age of the page fluctuates Do you or your friends have any solution Please revert Thanks regards On 5/6/11, ashish koul koul.ash...@gmail.com wrote: see if it helps http://akoul.blogspot.com/search/label/Sending%20e%20mail%20based%20on%20data%20in%20column%20in%20excel%20using%20outlook On Fri, May 6, 2011 at 4:46 PM, rajan verma rajanverma1...@gmail.comwrote: See if It help,, Edit Macro According to your requirement.. Public Sentmag As String Sub SenDmail() Dim outLookApp As Object Set outLookApp = CreateObject(Outlook.application) Dim FileName As String Dim Data As Integer Dim Msg As String Dim mitem As Object Dim Sign As String Dim recp As String Dim msglp As Integer Dim sigLp As Integer Dim cell As Range For Each cell In Range(Range) Msg = Dear cell.Offset(0, 9).Value Msg = Msg vbCrLf Please find the below mention Complaint Which is showing open Status in DFR , At this site Temperaute is going above 35, _ I Request you to please repair this Ac , if it is not capable to maintaint temperatue then Please Provide the SME Certificate for further Action Msg = Msg vbCrLf Indus ID= cell.Offset(0, 2).Value Msg = Msg vbCrLf Complaint No = cell.Offset(0, 1) vbCrLf Site Name = cell.Offset(0, 3).Value vbCrLf Equipment =AC/ cell.Offset(0, 4).Value Msg = Msg vbCrLf Technician/SUpervisor Contact No = cell.Offset(0, 7).Text vbCrLf Complaint = cell.Offset(0, 8).Text Msg = Msg vbCrLf Regards vbCrLf Rajan Verma Set mitem = outLookApp.createitem(OlMailitem) With mitem .To = cell.Offset(0, 10).Text .Subject = AC problem of cell.Offset(0, 3).Text .Body = Msg End With mitem.Send Next outLookApp.Quit Set outLookApp = Nothing MsgBox Mail Has been Sent , vbInformation End Sub On Fri, May 6, 2011 at 4:07 PM, Jitheesh Vazhapully 7jit...@gmail.comwrote: Hello Experts, I'm looking for an macro to send an email on a specific date, We can run the macro daily and I want it to compare todays date with the deadline and in case it matches, the excel should shoot an email. I have mentioned the details in the excel sheet. Please advice if this is possible -- -- 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 -- Regards Rajan verma +91 9158998701 -- -- 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 -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.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
Re: $$Excel-Macros$$ How to use Vlookup in macro
Hai Will you send a copy of worksheet... Thanks On Sat, May 7, 2011 at 12:17 PM, maulik desai mauliksde...@gmail.comwrote: Hi All, I have excel database sheet I have created some excel output sheets (around 35 excel sheets) which gives me output data with the help of Vlookup fuction. But the problem is in every 3 months I have to change the database month name because of that I need to change the vlookup range also in output sheets manually (need to open each sheet change the new file name in that) Is there any way that whenever I changed the file name of database ,the same new range also updated in output sheets automatically. Thanks In advance. -- Thanks Regards, Maulik Desai -- -- 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$$ A small query, need your help in vba coding.
Your code looks like to be run in excel 2003 only (1) In both excel 2003 / excel 2007 Range(A65000) ' last row in A column can be coded as Cells(*Rows.Count*,1) or Range(A *Rows.Count*) (2) *Value* property of a Range Object is a *DEFAULT Property* so you can ignore it For example Range(A1).*Value* = Range(C1).*Value* can be coded as: Range(A1) = Range(C1) * * On Sat, May 7, 2011 at 1:14 PM, rajan verma rajanverma1...@gmail.comwrote: Private Sub CommandButton1_Click() *Range(A65000)*.End(xlUp).Cells(2, 1) = Range(C1).Value: * Range(A65000)*.End(xlUp).Cells(1, 2) = Range(D1).Value: End Sub On Sat, May 7, 2011 at 1:56 AM, Indrajit $nai talk2indra...@gmail.comwrote: Hi All, I have a little query in vba coding, please see the attached file. In the excel file there is a Save command button, whenever I press the button it will copy the data from cell no. c1:d1 and paste in the cell a1:b1, now my query is, if the data is already in the cell no. a1:b1 it will be saved in the next cell no. means a2:b2 then a3:b3 just going on like this, can anyone help me in that coding how do I create that loop? Thanks in advance. Indrajit -- -- 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$$ How to use Vlookup in macro
It would be easy for anyone in the group to respond, if you can send a set of sample data. On Sat, May 7, 2011 at 1:47 PM, maulik desai mauliksde...@gmail.com wrote: Hi All, I have excel database sheet I have created some excel output sheets (around 35 excel sheets) which gives me output data with the help of Vlookup fuction. But the problem is in every 3 months I have to change the database month name because of that I need to change the vlookup range also in output sheets manually (need to open each sheet change the new file name in that) Is there any way that whenever I changed the file name of database ,the same new range also updated in output sheets automatically. Thanks In advance. -- -- 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$$ Please Help
try to use this UDF (user defined function) Function UniqueList(Dat As Range) ' List of UnSorted Unique Values ' '-' Dim Cel As Range, vArr(), n As Long, Tx As String Tx = , For Each Cel In Dat If InStr(1, Tx, , Cel , ) = 0 Then Tx = Tx Cel , End If Next Cel If Len(Tx) 0 Then Tx = Left(Tx, Len(Tx) - 2) If Len(Tx) 0 Then Tx = Right(Tx, Len(Tx) - 2) UniqueList = Tx End Function On Sat, May 7, 2011 at 3:50 PM, karan 1237 karan1...@gmail.com wrote: * LIST1* *LIST1* *LIST1* *RESULT* BACK SIDE FRONT BACK, SIDE, FRONT FRONT SIDE FRONT FRONT, SIDE BACK FRONT BACK BACK, FRONT FRONT FRONT FRONT FRONT *Hi Experts, I want like this. Please help. Thnx in Advance. * ııııllıı ~ ♣ кαяαηη ♣ ~ ııııllıı -- -- 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 UDF_UniqValues.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
$$Excel-Macros$$ =Now() Keep from changing
If I enter the Customer in B27 I'd like for todays date to be entered in F27 automatically. How would you keep the date from changing the next day, each time the workbook is opened? Thanks in advance!!! -- -- 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$$ =Now() Keep from changing
instead of writing =NOW() or =TODAY() in a cell select a cell then press Ctrl + ;(for FIXED today's date ) press Ctrl + Shift + :(for Fixed Now time ) On Sun, May 8, 2011 at 2:12 AM, Bob bobandrich...@comcast.net wrote: If I enter the Customer in B27 I'd like for todays date to be entered in F27 automatically. How would you keep the date from changing the next day, each time the workbook is opened? Thanks in advance!!! -- -- 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$$
Dear Board Members This is my first question on this board, I need a help in capturing data from three sheet into one (RESULT) sheet based on the CATCODE Can anybody help me to sort this out as per the attached file. Please read the notes give in id sheet and result sheet. Best Regards Siraj -- -- 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 Book-rev1.xlsx Description: Book-rev1.xlsx
