Fwd: $$Excel-Macros$$ Heplp Required
Dear Experts, i want randomly time and date like 10:43 AM 10:50 AM 10:05 AM 11:10 AM 1:07 PM 20-Nov-12 19-Nov-12 2-Nov-12 11-Nov-12 6-Nov-12 24-Nov-12 18-Nov-12 27-Nov-12 4-Nov-12 1-Nov-12 -- 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. -- 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.
$$Excel-Macros$$ IF Query
hi, pls find the file attached and solve my query thank you in advance Nik -- 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. doubt.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Need help atpvbaen.xlam and eurotool.xlam suddenly show up in vba ide why?
Hi there Does anyone know the reason .xlam files suddenly show up in the vba ide? I understand these are files from genuine microsoft office addins pack, I don't recall any action with addins lately and until then I only had current workbook and personal showing up as object with or without module. Now, there are other files, I think I had the analysis tool pack enabled before but I wouldn't notice anything in the vba code ide. Has anyone experienced that or is this an issue regarding the office installation (office 2010)? Regards Pascal -- 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.
Re: $$Excel-Macros$$ Heplp Required
Hi Neeraj, Try these rwo statements. =TODAY()+RANDBETWEEN(1,31) =TIME(RANDBETWEEN(1,12),RANDBETWEEN(0,60),RANDBETWEEN(0,60)) Regards Eugene On Sat, Dec 1, 2012 at 10:48 AM, neeraj chauhan neerajchauhan...@gmail.comwrote: Dear Experts, i want randomly time and date like 10:43 AM 10:50 AM 10:05 AM 11:10 AM 1:07 PM 20-Nov-12 19-Nov-12 2-Nov-12 11-Nov-12 6-Nov-12 24-Nov-12 18-Nov-12 27-Nov-12 4-Nov-12 1-Nov-12 -- 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. -- 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.
$$Excel-Macros$$ credit card due date formula
Dear All Kindly help me to solve the problem I have a excel sheet were i have required a formula which will show me the credit card month or the cycle or the due date. -- 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. credit cARD.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ credit card due date formula
Use Text formula for month like =text(d2,) and u can use text with iferror formula Sent from my iPhone On Dec 2, 2012, at 12:43 AM, Hemantpokharkar hemant...@gmail.com wrote: Dear All Kindly help me to solve the problem I have a excel sheet were i have required a formula which will show me the credit card month or the cycle or the due date. -- 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. credit cARD.xls -- 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.
$$Excel-Macros$$ Excel Google Map Integration
Hi Group, If anybody wants to create Google Geo Charts in Excel visit below links and download the working files to try them. To know more about Google Charts Visit https://developers.google.com/chart/interactive/docs/gallery/geochart. (*Snapshot of Google Geo chart below*) https://lh4.googleusercontent.com/-dt23fPdzTRE/ULrQAYRQwmI/BtU/wdvd0MFsTk8/s1600/world+map.JPG *Google World Heat Map chart in Excel* http://www.excelvbamacros.com/2012/11/google-world-heat-map-chart-in-excel.html *Google Heat Map charts In Excel (at City Level)* http://www.excelvbamacros.com/2012/11/google-heat-map-charts-in-excel-at-city.html *Google World Map chart with markers in Excel* http://www.excelvbamacros.com/2012/11/google-world-map-chart-with-markers-in.html *Google Marker Map charts In Excel (at Country Level)* http://www.excelvbamacros.com/2012/11/google-marker-map-charts-in-excel-at.html *Plot locations on Google Chart map by passing Latitude and Longitude (Country Level)* http://www.excelvbamacros.com/2012/12/plot-locations-on-google-chart-map-by.html *Plot locations on Google World map by passing Latitude and Longitude* http://www.excelvbamacros.com/2012/12/plot-locations-on-google-world-map-by.html *Google World Heat Map (By Passing Latitude and Longitude) * http://www.excelvbamacros.com/2012/11/google-world-heat-map-by-passing.html *Google Country Level Heat Map (By Passing Latitude and Longitude)* http://www.excelvbamacros.com/2012/11/google-country-level-heat-map-by.html *Google Heat Map charts In Excel (at Country Level)* http://www.excelvbamacros.com/2012/11/google-heat-map-charts-in-excel-at.html *Have a wonderful Sunday..* * * Regards Ashish Koul * * * * -- 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.
Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK
Hi Try the attached file - change the folder path in code. Regards, Ashish Koul On Fri, Nov 30, 2012 at 10:15 AM, Satendra kumar satendrakuma...@gmail.comwrote: Dear Sir, I am not expert in vba, i am beginner vba so please me suggest me where is add loop?? thankx satendra On Thu, Nov 29, 2012 at 8:22 PM, ashish koul koul.ash...@gmail.comwrote: @ Narton - Thanks @Satendra kumar - whts nt wrkng in the file u need to add the loop On Thu, Nov 29, 2012 at 6:52 AM, Natron protoc...@gmail.com wrote: *Ashish, you are awesome!* -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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. -- Thanks Regards Satendra Kumar -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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.
Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK
whts in cc email On Sun, Dec 2, 2012 at 10:55 AM, Satendra kumar satendrakuma...@gmail.comwrote: Thank you so much sir, but cc email is pick up thankx satendra On Sun, Dec 2, 2012 at 10:46 AM, ashish koul koul.ash...@gmail.comwrote: Hi Try the attached file - change the folder path in code. Regards, Ashish Koul On Fri, Nov 30, 2012 at 10:15 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Sir, I am not expert in vba, i am beginner vba so please me suggest me where is add loop?? thankx satendra On Thu, Nov 29, 2012 at 8:22 PM, ashish koul koul.ash...@gmail.comwrote: @ Narton - Thanks @Satendra kumar - whts nt wrkng in the file u need to add the loop On Thu, Nov 29, 2012 at 6:52 AM, Natron protoc...@gmail.com wrote: *Ashish, you are awesome!* -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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. -- Thanks Regards Satendra Kumar -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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
Re: $$Excel-Macros$$ EMAIL AUTOMATION BY VBA OUTLOOK
Sub emailstest() Dim i As Long Sheets(list).Select For i = 2 To Range(a65356).End(xlUp).Row Call send_emails(Range(a i).Text, Range(b i).Text, Range(c i).Text, Range(d i)) Next End Sub Sub send_emails(nm As String, to1 As String, cc1 As String, rng As Range) Dim olApp As Outlook.Application Dim olMail As MailItem Dim fld As Object, fil As Object Dim attach1 As String, bl1 As Boolean Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(C:\Documents and Settings\user\Desktop\test delete\my data) attach1 = b1 = False For Each fil In fld.Files If UCase(Left(fil.Name, Application.WorksheetFunction.Find(., fil.Name) - 1)) = UCase(nm) Then attach1 = fil.Path bl1 = True Exit For End If Next fil If bl1 = False Then rng.Value = File Not Found - No Mail Sent Else Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = to1 .CC = cc1 .Subject = Hello .Body = Please find the attachment .Attachments.Add attach1 .Send End With Set olMail = Nothing Set olApp = Nothing rng.Value = attach1 End If End Sub On Sun, Dec 2, 2012 at 11:12 AM, Satendra kumar satendrakuma...@gmail.comwrote: Dear sir, i want same mail send in email Cc address. On Sun, Dec 2, 2012 at 10:59 AM, ashish koul koul.ash...@gmail.comwrote: whts in cc email On Sun, Dec 2, 2012 at 10:55 AM, Satendra kumar satendrakuma...@gmail.com wrote: Thank you so much sir, but cc email is pick up thankx satendra On Sun, Dec 2, 2012 at 10:46 AM, ashish koul koul.ash...@gmail.comwrote: Hi Try the attached file - change the folder path in code. Regards, Ashish Koul On Fri, Nov 30, 2012 at 10:15 AM, Satendra kumar satendrakuma...@gmail.com wrote: Dear Sir, I am not expert in vba, i am beginner vba so please me suggest me where is add loop?? thankx satendra On Thu, Nov 29, 2012 at 8:22 PM, ashish koul koul.ash...@gmail.comwrote: @ Narton - Thanks @Satendra kumar - whts nt wrkng in the file u need to add the loop On Thu, Nov 29, 2012 at 6:52 AM, Natron protoc...@gmail.com wrote: *Ashish, you are awesome!* -- 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. -- *Regards* * * *Ashish Koul* *Visit* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* P Before printing, think about the environment. -- 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 . -- Thanks Regards Satendra Kumar -- 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
$$Excel-Macros$$ outline 1 = dropdown in col A, based on this selection, dropdown in col b= outline2
Hi All, I have a sheet named fruit-sheet in the attached excel, i have 4 outlines (1 to 4) in it. i need a macro code i need a macro code which does the below: 1) it should get the values which can be seen when outline is 1 (in this case fruits veg can be seen.) these values should be seen in sheet DSR as a dropdown in all the cells of column E 2) it should get the values which can be seen when outline is 2 (in this case apple, bananna, carrot, beetroot can be seen.) these values should be seen in sheet DSR as a dropdown in all the cells of column F here there is another condition: In DSR sheet, if i select Fruits in col E, the values in the dropdown in col F should be only Apple Banana if i select Veg in col E, the values ion the dropdown in col F should be only carrot Veg 3) it should get the values which can be seen when outline is 3 (in this case bangalore, Hyd, mum, goa, chennai,delhi, maratahalli st marks village can be seen.) these values should be seen in sheet DSR as a dropdown in all the cells of column G here is one more condition: if i select fruits in col E apple in col F, i should get only values bangaloe HYD in col G 4)it should get the values which can be seen when outline is 4, these values should be seen in sheet DSR as a dropdown in all the cells of column H one more condition: if i select fruits in col E apple in col F, bangalore in col G, i should get below values as dropdown in col H: Russel market ONG market Vijaynagar Shantinagar ulsoor rajajinagar 5) if i select fruits in col E apple in col F, bangalore in col G, Ulsoor in col H, i should get the corresponding row value from fruit-sheet (example in this case the row number is 9) Please let me know if you need any more clarifications from my side. Please help me out at the earliest. Thanks, Blue J -- 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. sample file.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Fw: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule *
Hello Gurus i am trying to develop a very dynamic Fixed Asset depreciation schedule but facing a slight formula or logic challenge and as usual seeking your expert advice. Basically what this current schedule does is assuming you want to depreciate your asset for say 5 years, starting from 2013 you will see information for only the five years ending 2017 so at the end of the 5th year, the asset would have been fully depreciated, assuming however in 2014 you acquired another asset and you expert to depreciate it for 5 years also, it means by the end of 2018 you should have depreciated the 2nd acquisition fully, The Scenario in cell B9, i have entered the no of years for depreciation for the first asset purchased in 2013 and am using the formula IF($B$9=COLUMN(A1),,B11+1) in cell c11 to be able to cut off years after 2017 ( ie 5 years), The Problem however if i enter the new purchase of asset in cell B27, then i would have to enter the no of yrs for deprn for this asset in cell c9, then i expert this formula to be modified IF($B$9=COLUMN(A1),,B11+1) so that the cut off year will be in 2018, it has to be dynamic such that if i enter say a new purchase in csll D27 and i enter say a the no of yr for deprn for this asset in cell E9 the cut off year would be 2020 -- 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. Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Hilary Lomotey resp...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 29 Nov 2012 17:31:58 To: excel-macrosEXCEL-MACROS@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Dynamic Fixed Asset Depreciation Schedule * This message is eligible for Automatic Cleanup! (resp...@gmail.com) Add cleanup rule: https://www.boxbe.com/popup?url=https%3A%2F%2Fwww.boxbe.com%2Fcleanup%3Ftoken%3DkyH0VhaRJnkrdHRLFNuNEqqpQr6%252BXSlKZuxuwiVdzN713QHEvj1c0Atc%252Bczign77T4KpMTzBuVHwQ3kdKNHwDcdELDg5sLGisTOz53dS2nSrRc6%252Bs4Bb1t396sEeXjfhFeoe68yRhgE%253D%26key%3Di2U6CianDR%252FtCgspNcaSLcOeF%252F1CQBbIfGc5YzNmp%252BE%253Dtc=13009448229_93838451 More info: http://blog.boxbe.com/general/boxbe-automatic-cleanup?tc=13009448229_93838451 Depreciation Schedule.xlsb Description: Binary data