Re: $$Excel-Macros$$ Re: Introduce Yourself !!
Hi all, I m rajesh mahapatra from mumbai...i have learnt many macro trics from this group and hoping to see many morethanks On 4 Feb 2014 11:54, Nitin Mittal nitinmitt...@gmail.com wrote: Hi All, I am Nitin Mittal, working as HR Manager in Stonehill International School Bangalore. I want to learn advanced Excel and VBA, hence joined here. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/groups/opt_out.
$$Excel-Macros$$ Event - Worksheet Change
Dear Friends, kindly help out on below macro, i am not able to get output. I Wants to auto change Cell color Range F13 to Blue when Range F11 is as 1 City and cell color Range F13 to Yellow when range F11 is as 2 City. I have also attached xls for your reference. Private Sub Worksheet_Change(ByVal Target As Excel.Range) Set Target = Range(F11) If Target.Value = 1 City Then Range(F13).Interior.ColorIndex = 5 ElseIf Target.Value = 2 City Then Range(F13).Interior.ColorIndex = 6 End If End Sub -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 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) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. Event_worksheet change.xlsm Description: Binary data
Re: $$Excel-Macros$$
Hi Smitha, please find attached sheet with correction in formula you just have to put Opening stock in inverted comms. i.e. Opening stock thanks rajesh On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, Any one please help: PFA the attachment of office stock. One sheet shows the closing stock of stationery items. In the second sheet, if I select particulars as Opening stock I need toe get the closing stock of that Particular item, else for Purchase and Issue I have to manually enter the quantity, no need of closing stock from the first sheet, Please help on this as my formula on the sheet is not working. Regards Smitha -- FORUM RULES (986+ 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 (986+ 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 Office Stock Test.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ format in user form text box
hi group, how to put number format and date format in text box in user form. Thanks Regards Rajesh Mahapatra -- FORUM RULES (986+ 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$$ Add-in creation in excel 2007
thanks sam links are very helpful can i use the same ribbon in all excel files.. Thanks Rajesh Mahapatra On Tue, Apr 3, 2012 at 1:21 AM, Sam Mathai Chacko samde...@gmail.comwrote: This link will tell you how to add a tab in Excel http://www.excelfox.com/forum/f10/how-add-new-ribbon-tab-excel-26/?highlight=ribbon Regards, Sam Mathai Chacko On Mon, Apr 2, 2012 at 11:40 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think u should create custom menu to display that in Ribbon ** ** Rajan ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Raj Mahapatra *Sent:* Apr/Mon/2012 11:30 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Add-in creation in excel 2007 ** ** ** ** sam, how would i get that add in as a tab in ms excel Thanks Regards ** ** Rajesh Mahapatra ** ** ** ** On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko samde...@gmail.com wrote: Add-ins are designed to run in the background, and hence the file will not be visible when you open it. If you go to the VBE window, you could actually see that the vba project for your add-in is shown. Sam Mathai Chacko ** ** On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, ** ** i wants to create addin in excel. i have created a addin using below steps, but it is not working. ** ** 1. in new workbook, i have insert a module and macro codes in it. 2. then saved the same workbook using .xlam extension. 3. when i opens the same add in in new excel. it does not open. ** ** appreciation for your assistance. ** ** thanks regards ** ** Rajesh Mahapatra -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko ** ** -- FORUM RULES (986+ 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 (986+ 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 (986+ 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
$$Excel-Macros$$ Add-in creation in excel 2007
hi group, i wants to create addin in excel. i have created a addin using below steps, but it is not working. 1. in new workbook, i have insert a module and macro codes in it. 2. then saved the same workbook using .xlam extension. 3. when i opens the same add in in new excel. it does not open. appreciation for your assistance. thanks regards Rajesh Mahapatra -- FORUM RULES (986+ 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$$ Add-in creation in excel 2007
sam, how would i get that add in as a tab in ms excel Thanks Regards Rajesh Mahapatra On Mon, Apr 2, 2012 at 10:57 PM, Sam Mathai Chacko samde...@gmail.comwrote: Add-ins are designed to run in the background, and hence the file will not be visible when you open it. If you go to the VBE window, you could actually see that the vba project for your add-in is shown. Sam Mathai Chacko On Mon, Apr 2, 2012 at 10:50 PM, Raj Mahapatra rajafs...@gmail.comwrote: hi group, i wants to create addin in excel. i have created a addin using below steps, but it is not working. 1. in new workbook, i have insert a module and macro codes in it. 2. then saved the same workbook using .xlam extension. 3. when i opens the same add in in new excel. it does not open. appreciation for your assistance. thanks regards Rajesh Mahapatra -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (986+ 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 (986+ 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$$ date should be today's date in calendar in user form of excel
hi group, i want date in calendar in user form should be today's date automatically. Thanks Regards -- FORUM RULES (986+ 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$$ macro vba coding for html file search and paste the path as hyperlink
hi venkat, appreciating for your assistance.. actually i have stored some html files in a particular folder and i wants to search and hyperlink the path of that file in the sheet. Thanks Regards On Fri, Mar 23, 2012 at 9:49 AM, Venkat CV venkat1@gmail.com wrote: Hi , See below link.. http://www.pcreview.co.uk/forums/re-search-html-access-vba-t3992723.html *Best Regards,* *Venkat * *Chennai* * * On Thu, Mar 22, 2012 at 12:13 AM, Raj Mahapatra rajafs...@gmail.comwrote: hi all i am looking for some vba codes which will search html files (bases file names in the sheet) from specified locations and paste the path of the same file as hyperlink in the sheet Thanks -- FORUM RULES (986+ 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 (986+ 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 (986+ 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$$ email extraction from gmail
thanks noorain and jitendra. On Thu, Mar 22, 2012 at 12:03 PM, Jitendra singh jeete2...@gmail.comwrote: give email id A1 box in sheet and run macro --- Sub Mail_Every_Worksheet() 'Working in 2000-2010 Dim sh As Worksheet Dim wb As Workbook Dim FileExtStr As String Dim FileFormatNum As Long Dim TempFilePath As String Dim TempFileName As String Dim OutApp As Object Dim OutMail As Object TempFilePath = Environ$(temp) \ If Val(Application.Version) 12 Then 'You use Excel 97-2003 FileExtStr = .xls: FileFormatNum = -4143 Else 'You use Excel 2007-2010 FileExtStr = .xlsx: FileFormatNum = 51 End If With Application .ScreenUpdating = False .EnableEvents = False End With Set OutApp = CreateObject(Outlook.Application) For Each sh In ThisWorkbook.Worksheets If sh.Range(A1).Value Like ?*@?*.?* Then sh.Copy Set wb = ActiveWorkbook TempFileName =sh.Name of _ ThisWorkbook.Name Set OutMail = OutApp.CreateItem(0) With wb .SaveAs TempFilePath TempFileName FileExtStr, _ FileFormat:=FileFormatNum On Error Resume Next With OutMail .To = sh.Range(A1).Value .CC = .BCC = .Subject = DAILY DASHBOARD .Body = DAILY DASHBOARD .Attachments.Add wb.FullName 'You can add other files also like this '.Attachments.Add (C:\test.txt) .Send 'or use .Display End With On Error GoTo 0 .Close SaveChanges:=False End With Set OutMail = Nothing Kill TempFilePath TempFileName FileExtStr End If Next sh Set OutApp = Nothing With Application .ScreenUpdating = True .EnableEvents = True End With End Sub = On Thu, Mar 22, 2012 at 8:58 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Raj, Please try through below link. http://www.gmailextractor.com/ -- Thanks regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ On Wed, Mar 21, 2012 at 11:56 PM, Raj Mahapatra rajafs...@gmail.comwrote: hi group, can you please advice me how to extract email id's from gmail or outlook using VBA Thanks Regards -- FORUM RULES (986+ 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 (986+ 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 (986+ 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
$$Excel-Macros$$ email extraction from gmail
hi group, can you please advice me how to extract email id's from gmail or outlook using VBA Thanks Regards -- FORUM RULES (986+ 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$$ macro vba coding for html file search and paste the path as hyperlink
hi all i am looking for some vba codes which will search html files (bases file names in the sheet) from specified locations and paste the path of the same file as hyperlink in the sheet Thanks -- FORUM RULES (986+ 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$$ add-in creation in excel
hi group, advice me, how to create add-ins in excel. i have tried it by creating a macro in a workbook and saving it in .xla format. but its not working. Thanks Regards -- FORUM RULES (986+ 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$$ Need pivot subtotal code
Hi Rekha, Please find the attached file Go to View Macro and Run Macro 1 data automatically will give you your output for any further queries, please feel free to revert Thanks Regards Rajesh Mahapatra On Mon, Feb 13, 2012 at 5:29 PM, rekha siri rekha.siri2...@gmail.comwrote: hi experts, please help me in provinding code . i am attaching sop and files in download zip. thanks, rekha -- FORUM RULES (986+ 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 (986+ 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 Future Inv Date_ Open Invoice Report-Markets.xlsm Description: Binary data
Re: $$Excel-Macros$$ Multiple Selection of cells copying the same using macro
kindly help on this On Thu, Jan 6, 2011 at 6:03 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi group, requesting you to tell me the macro codes for Multiple Selection of cells copying the same thanks Rajesh -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi all, any help On Wed, Jan 5, 2011 at 4:19 PM, ankur ankurpande...@gmail.com wrote: hi rajesh very gud explantion On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi Group any help thanks Rajesh On Thu, Jan 6, 2011 at 2:30 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi all, any help On Wed, Jan 5, 2011 at 4:19 PM, ankur ankurpande...@gmail.com wrote: hi rajesh very gud explantion On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Multiple Selection of cells copying the same using macro
hi group, requesting you to tell me the macro codes for Multiple Selection of cells copying the same thanks Rajesh -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi all, please help Thanks On Tue, Jan 4, 2011 at 1:38 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi gurumurthy, you are right. I want to see the description in our macro function as we see for microsoft functions. hi Haigreeva, as per the comments by the gurumurthy, I want to see the description in our macro function as we see for microsoft functions. hi Kiran, i am using Excel 2007 version. Thanks On Tue, Jan 4, 2011 at 12:43 PM, hanumant shinde hanumant_5...@yahoo.co.in wrote: Hi gurumurthy, i dont think he means what u said. he means lets say we write =sum(A1+A2) in excel cell you will see some info for sum function which is provided by microsoft itself. but if we have developed our own function (lets say ofunct) and we type this function in any cell like =ofunct() then e shud see the same kind of info as we see for miscrosoft functions. @Rajesh please correct me if i m wrong. -- *From:* gurumurthy sastry Kondury gurumurthy.sas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, 4 January, 2011 10:31:34 AM *Subject:* Re: $$Excel-Macros$$ Description while using Macro Functions in Excel Hi Rajesh, If your question is to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) , then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_if_false) This is how you normally put the function. =IF(logical_test, value_if_true, value_if_false) Here you leave a space in Cell C1 and here its just a text but not the function. Hope this helps. Or correct me If my understanding is wrong. Best Regards, Haigreeva On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.comwrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi gurumurthy, you are right. I want to see the description in our macro function as we see for microsoft functions. hi Haigreeva, as per the comments by the gurumurthy, I want to see the description in our macro function as we see for microsoft functions. hi Kiran, i am using Excel 2007 version. Thanks On Tue, Jan 4, 2011 at 12:43 PM, hanumant shinde hanumant_5...@yahoo.co.inwrote: Hi gurumurthy, i dont think he means what u said. he means lets say we write =sum(A1+A2) in excel cell you will see some info for sum function which is provided by microsoft itself. but if we have developed our own function (lets say ofunct) and we type this function in any cell like =ofunct() then e shud see the same kind of info as we see for miscrosoft functions. @Rajesh please correct me if i m wrong. -- *From:* gurumurthy sastry Kondury gurumurthy.sas...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, 4 January, 2011 10:31:34 AM *Subject:* Re: $$Excel-Macros$$ Description while using Macro Functions in Excel Hi Rajesh, If your question is to use the function in one Cell ( Say B1) and to show the description of the Function in the next cell ( say C1) , then use your function in Cell B1, and put the same function in Cell C1 leaving one space. See Example below =IF(logical_test, value_if_true, value_if_false) This is how you normally put the function. =IF(logical_test, value_if_true, value_if_false) Here you leave a space in Cell C1 and here its just a text but not the function. Hope this helps. Or correct me If my understanding is wrong. Best Regards, Haigreeva On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.comwrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Problem in Data Validation in Excel
hi Jitendra, First, Define the name range of the countries as Country Second, Define the name range of states as Country Name e.g. For all indian states give name range India Third, In first column use data validation of country in Second column use this formulat in Data Validation in List as =INDIRECT(SELECT THE CELL OF PREVIOUS COLUMN WHERE YOU HAVE USED COUNTRY) If you have further problem, kindly view the attachment. On Tue, Jan 4, 2011 at 8:45 PM, Jitendra Verma jitendra.kumarve...@gmail.com wrote: Hi All, I have a question related to data validation in excel. Below is the description.. I want to create two dropdown list using the data validation list. one is for countries and other is for State of the countries. My question is if i select country from first dropdown thee second dropdown populate only the state of India country. -- *Thanks and Regards,* Jitendra Kr. Verma| Sr. Software Engineer Mob: +91.9700695633 -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts data validation example.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Description while using Macro Functions in Excel
hi friends, please help on my below querry. Thanks On Thu, Dec 30, 2010 at 4:51 PM, Raj Mahapatra rajafs...@gmail.com wrote: hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Description while using Macro Functions in Excel
hi Group, i want to show description of the Function while using the same in Excel like below screen shot. e.g while using if function in excel it displays like =if(logical_test, value_if_true, value_if_false) thanks Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
Re: $$Excel-Macros$$ Vlookup in Macro
hi Vaibhav, thanks for this. but i want to dispaly an input box as *lookfor is not in the rng* while there is error. On Fri, Dec 10, 2010 at 1:32 PM, in.vaib...@gmail.com wrote: Hi, Add line; On error resume next Rgds Vaibhav J Sent on my BlackBerry® from Vodafone -- *From: *Raj Mahapatra rajafs...@gmail.com *Sender: *excel-mac...@googlegroups.com *Date: *Fri, 10 Dec 2010 10:02:19 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: *excel-mac...@googlegroups.com *Subject: *$$Excel-Macros$$ Vlookup in Macro hi group, In the following vlookup code in macro, if any object is #N/A in the rng then *run time error 1004*occurs. In such case, i want that it should show a message as *lookfor data is not in the range* help me how to put msg box if lookfor is not in the rng. Sub vlookup() Dim lookfor As Range Dim rng As Range Dim col As Integer Set lookfor = ActiveCell.Offset(0, 2) Set rng = Sheets(MV).Columns(A:C) col = 3 dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0) End Sub Thanks Regards Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Vlookup in Macro
hi group, In the following vlookup code in macro, if any object is #N/A in the rng then *run time error 1004*occurs. In such case, i want that it should show a message as *lookfor data is not in the range* help me how to put msg box if lookfor is not in the rng. Sub vlookup() Dim lookfor As Range Dim rng As Range Dim col As Integer Set lookfor = ActiveCell.Offset(0, 2) Set rng = Sheets(MV).Columns(A:C) col = 3 dept_code = Application.WorksheetFunction.vlookup(lookfor, rng, col, 0) End Sub Thanks Regards Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Data Validation using Macro
HI Group, I want to restrict some fields in user form as we have data validation in excel. can you please suggest me the macros using data validation following are my requirements 1. I want to restrict to 8 digits in a text box, in which first 3 characters has to be SCN 2. I want to use combo box as drop-down list. thanks in advance Rajesh Mahapatra -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Macro Commands to Create Pivot Table in Excel
hi Group, Can any one send me the macro commands to create pivot table in excel. Thanks Regards Rajesh -- -- 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/pages/discussexcelcom/160307843985936?v=wallref=ts
$$Excel-Macros$$ Purchase entry Macro from Sheet 4 to Sheet 1-
Sub purchase_entry() Dim mod_date As Date Dim entry_date As Date Dim reference As String Dim description As String Dim period As String Dim amount As Long Dim locatio As String Dim coa As String Dim coa_code As String Dim tax_account As String Dim tax_account1 As String Dim tax_account_name As Variant Dim lookfor As Range Dim rng As Range Dim col As Integer Dim tax_amount As Long Dim tax_amount1 As Long Dim tot_amt As Long 'to be fix Set lookfor = Sheets(sheet1).Range(e3) Set rng = Sheets(sheet5).Columns(A:B) col = 2 period = InputBox(Enter Period) Worksheets(sheet1).Select Range(A2).Select ActiveCell.Value = Int(Now()) ActiveCell.Offset(0, 1) = GENJV Worksheets(sheet4).Select Range(A2).Select reference = Right(ActiveCell.Offset(0, 32), 10) description = ActiveCell.Offset(0, 38) amount = ActiveCell.Offset(0, 46) tax_account_name = Application.VLookup(lookfor, rng, col, 0) If ActiveCell.Offset(0, 0) = 101 Then Location = WMAH04 ElseIf ActiveCell.Offset(0, 0) = 201 Then Location = NHAR01 End If coa = ActiveCell.Offset(0, 10) coa_code = ActiveCell.Offset(0, 9) If ActiveCell.Offset(0, 44) = CST Then tax_account = 10301004 tax_amount = ActiveCell.Offset(0, 47).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 1 Then tax_account = 10304007 tax_amount = ActiveCell.Offset(0, 48).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 5 Then tax_account = 10304038 tax_amount = ActiveCell.Offset(0, 48).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 5.25 Then tax_account = 10304038 tax_amount = ActiveCell.Offset(0, 48).Value tax_account1 = 10304039 tax_amount1 = ActiveCell.Offset(0, 49).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 12.5 Then tax_account = 10304006 tax_amount = ActiveCell.Offset(0, 48).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 13.13 Then tax_account = 10304038 tax_amount = ActiveCell.Offset(0, 48).Value tax_account1 = 10304040 tax_amount1 = ActiveCell.Offset(0, 49).Value Else tax_account = check code End If tot_amt = amount + tax_amount + tax_amount1 Worksheets(sheet4).Select Range(A2).Select Do Until IsEmpty(ActiveCell) Worksheets(sheet1).Select Range(A2).Select ActiveCell.Offset(0, 2) = reference ActiveCell.Offset(0, 3) = description ActiveCell.Offset(0, 4) = 10301001 ActiveCell.Offset(0, 5) = STOCK AT WAREHOUSE ActiveCell.Offset(0, 6) = A ActiveCell.Offset(0, 7) = period ActiveCell.Offset(0, 8) = amount ActiveCell.Offset(0, 9) = D ' to be fix ActiveCell.Offset(0, 11) = MER01 ActiveCell.Offset(0, 12) = Location ActiveCell.Offset(0, 14) = coa ActiveCell.Offset(0, 15) = coa_code ActiveCell.Offset(1, 0) = Int(Now()) ActiveCell.Offset(1, 1) = GENJV ActiveCell.Offset(1, 2) = reference ActiveCell.Offset(1, 3) = description ActiveCell.Offset(1, 4) = tax_account ActiveCell.Offset(1, 5) = tax_account_name ActiveCell.Offset(1, 6) = A ActiveCell.Offset(1, 7) = period ActiveCell.Offset(1, 8) = tax_amount ActiveCell.Offset(1, 9) = D 'to be fix ActiveCell.Offset(1, 11) = MER01 ActiveCell.Offset(1, 12) = Location ActiveCell.Offset(1, 14) = coa ActiveCell.Offset(1, 15) = coa_code Worksheets(sheet4).Select If ActiveCell.Offset(0, 49).Value = 0 Then Worksheets(sheet1).Select ActiveCell.Offset(2, 0) = Int(Now()) ActiveCell.Offset(2, 1) = GENJV ActiveCell.Offset(2, 2) = reference ActiveCell.Offset(2, 3) = description ActiveCell.Offset(2, 4) = coa_code ActiveCell.Offset(2, 5) = coa ActiveCell.Offset(2, 6) = A ActiveCell.Offset(2, 7) = period ActiveCell.Offset(2, 8) = tot_amt ActiveCell.Offset(2, 9) = C 'to be fix ActiveCell.Offset(2, 11) = MER01 ActiveCell.Offset(2, 12) = Location ActiveCell.Offset(2, 14) = STOCK AT WAREHOUSE ActiveCell.Offset(2, 15) = 10301001 Else Worksheets(sheet1).Select ActiveCell.Offset(2, 0) = Int(Now()) ActiveCell.Offset(2, 1) = GENJV ActiveCell.Offset(2, 2) = reference ActiveCell.Offset(2, 3) = description ActiveCell.Offset(2, 4) = tax_account1 ActiveCell.Offset(2, 5) = tax_account_name ActiveCell.Offset(2, 6) = A ActiveCell.Offset(2, 7) = period ActiveCell.Offset(2, 8) = tax_amount1 ActiveCell.Offset(2, 9) = D 'to be fix ActiveCell.Offset(2, 11) = MER01 ActiveCell.Offset(2, 12) = Location ActiveCell.Offset(2, 14) = coa ActiveCell.Offset(2, 15) = coa_code ActiveCell.Offset(3, 0) = Int(Now())
$$Excel-Macros$$ Purchase entry Macro
Hi Group, I am not able to run the below macro, kindly help. my requirement is like this. Sheet 4 is having data in one single row, which creates 3 or 4 multiple rows with the help of below macro. the below macro is only creates for the first line in sheet 4 only and it is not able to create for other lines. Sub purchase_entry() Dim mod_date As Date Dim entry_date As Date Dim reference As String Dim description As String Dim period As String Dim amount As Long Dim locatio As String Dim coa As String Dim coa_code As String Dim tax_account As String Dim tax_account1 As String Dim tax_account_name As Variant Dim lookfor As Range Dim rng As Range Dim col As Integer Dim tax_amount As Long Dim tax_amount1 As Long Dim tot_amt As Long 'to be fix Set lookfor = Sheets(sheet1).Range(e3) Set rng = Sheets(sheet5).Columns(A:B) col = 2 period = InputBox(Enter Period) Worksheets(sheet1).Select Range(A2).Select ActiveCell.Value = Int(Now()) ActiveCell.Offset(0, 1) = GENJV Worksheets(sheet4).Select Range(A2).Select reference = Right(ActiveCell.Offset(0, 32), 10) description = ActiveCell.Offset(0, 38) amount = ActiveCell.Offset(0, 46) tax_account_name = Application.VLookup(lookfor, rng, col, 0) If ActiveCell.Offset(0, 0) = 101 Then Location = WMAH04 ElseIf ActiveCell.Offset(0, 0) = 201 Then Location = NHAR01 End If coa = ActiveCell.Offset(0, 10) coa_code = ActiveCell.Offset(0, 9) If ActiveCell.Offset(0, 44) = CST Then tax_account = 10301004 tax_amount = ActiveCell.Offset(0, 47).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 1 Then tax_account = 10304007 tax_amount = ActiveCell.Offset(0, 48).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 5 Then tax_account = 10304038 tax_amount = ActiveCell.Offset(0, 48).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 5.25 Then tax_account = 10304038 tax_amount = ActiveCell.Offset(0, 48).Value tax_account1 = 10304039 tax_amount1 = ActiveCell.Offset(0, 49).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 12.5 Then tax_account = 10304006 tax_amount = ActiveCell.Offset(0, 48).Value ElseIf ActiveCell.Offset(0, 44) = VAT And ActiveCell.Offset(0, 45) = 13.13 Then tax_account = 10304038 tax_amount = ActiveCell.Offset(0, 48).Value tax_account1 = 10304040 tax_amount1 = ActiveCell.Offset(0, 49).Value Else tax_account = check code End If tot_amt = amount + tax_amount + tax_amount1 Worksheets(sheet4).Select Range(A2).Select Do Until IsEmpty(ActiveCell) Worksheets(sheet1).Select Range(A2).Select ActiveCell.Offset(0, 2) = reference ActiveCell.Offset(0, 3) = description ActiveCell.Offset(0, 4) = 10301001 ActiveCell.Offset(0, 5) = STOCK AT WAREHOUSE ActiveCell.Offset(0, 6) = A ActiveCell.Offset(0, 7) = period ActiveCell.Offset(0, 8) = amount ActiveCell.Offset(0, 9) = D ' to be fix ActiveCell.Offset(0, 11) = MER01 ActiveCell.Offset(0, 12) = Location ActiveCell.Offset(0, 14) = coa ActiveCell.Offset(0, 15) = coa_code ActiveCell.Offset(1, 0) = Int(Now()) ActiveCell.Offset(1, 1) = GENJV ActiveCell.Offset(1, 2) = reference ActiveCell.Offset(1, 3) = description ActiveCell.Offset(1, 4) = tax_account ActiveCell.Offset(1, 5) = tax_account_name ActiveCell.Offset(1, 6) = A ActiveCell.Offset(1, 7) = period ActiveCell.Offset(1, 8) = tax_amount ActiveCell.Offset(1, 9) = D 'to be fix ActiveCell.Offset(1, 11) = MER01 ActiveCell.Offset(1, 12) = Location ActiveCell.Offset(1, 14) = coa ActiveCell.Offset(1, 15) = coa_code Worksheets(sheet4).Select If ActiveCell.Offset(0, 49).Value = 0 Then Worksheets(sheet1).Select ActiveCell.Offset(2, 0) = Int(Now()) ActiveCell.Offset(2, 1) = GENJV ActiveCell.Offset(2, 2) = reference ActiveCell.Offset(2, 3) = description ActiveCell.Offset(2, 4) = coa_code ActiveCell.Offset(2, 5) = coa ActiveCell.Offset(2, 6) = A ActiveCell.Offset(2, 7) = period ActiveCell.Offset(2, 8) = tot_amt ActiveCell.Offset(2, 9) = C 'to be fix ActiveCell.Offset(2, 11) = MER01 ActiveCell.Offset(2, 12) = Location ActiveCell.Offset(2, 14) = STOCK AT WAREHOUSE ActiveCell.Offset(2, 15) = 10301001 Else Worksheets(sheet1).Select ActiveCell.Offset(2, 0) = Int(Now()) ActiveCell.Offset(2, 1) = GENJV ActiveCell.Offset(2, 2) = reference ActiveCell.Offset(2, 3) = description ActiveCell.Offset(2, 4) = tax_account1 ActiveCell.Offset(2, 5) = tax_account_name ActiveCell.Offset(2, 6) = A ActiveCell.Offset(2, 7) =