Re: $$Excel-Macros$$ excel help me
You can use left or right function by converting number to text.. On Jan 6, 2018 21:26, "Deepu Raj"wrote: > how to remove 1025 to 25 or 140 to 40 ie hundred and thousand removing > using excel > > -- > 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 https://groups.google.com/group/excel-macros. > For more options, visit https://groups.google.com/d/optout. > -- 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 https://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Select all excel files in computer
Paul, I have been reading your codes since 2011. How do you manage to write these codes in so simple manner? Is there any logic? Please guide. Mangesh On Oct 8, 2015 6:45 PM, "Paul Schreiner"wrote: > The answer is "yes", you CAN. > How it's DONE is a bit more difficult. > > First of all, by "all drives" you must mean all physical drives (hard > drives) > since mapped network drives aren't "on" the computer they can be mapped on > the new system and nothing is lost. > > So, you only have to deal with "fixed" drives. > > Prior to Excel2007, VBA had a filesystem "search" utility. > It was dropped in Excel2007 and I don't believe it has been restored. > > consequently, you have to use "brute force" to accomplish it. > > Basically, you use the filesystem object and recursively search through > folders. > Yes, it's time consuming. > My c:\ drive has 450,000 files on it, and I found that it has 2,277 Excel > files. > > This will list the Excel files. > Next, you have to decide what you wish to DO with them! > (I'd write a function and call it from the section that writes the > filenames to the worksheet) > > Option Explicit > 'err.number & ": " & err.description > Public fso, ListRow, RepSheet > Sub List_Drives() > Dim d, dc, stat, File_Cnt > Set fso = CreateObject("scripting.filesystemobject") > Set dc = fso.drives > > RepSheet = "All_Files" > > stat = Clear_Report > > For Each d In dc > If (d.drivetype = 2) Then File_Cnt = Get_Folders(d.Path) > Next d > Application.StatusBar = False > MsgBox File_Cnt & " files found" > End Sub > > '== > Function Get_Folders(FolderName) > Dim File, Files, f, fil > Dim Folders, Folder, Ext > Dim File_Cnt, ArrFolder > ArrFolder = Split(FolderName, "\") > If (UBound(ArrFolder) = 3) Then > Application.StatusBar = "Accessing folder: " & FolderName > Debug.Assert True > End If > If (Right(FolderName, 1) <> "\") Then FolderName = FolderName & "\" > On Error Resume Next > Set Folder = fso.getfolder(FolderName) > Set Files = Folder.Files > For Each File In Files > Set f = fso.getfile(File.Path) > Ext = fso.getextensionname(File.Name) > If (Left(UCase(Ext), 3) = "XLS") Then > File_Cnt = File_Cnt + 1 > ListRow = ListRow + 1 > If (ListRow Mod 10 = 0) Then Debug.Assert True > Sheets(RepSheet).Cells(ListRow, "A").Value = f.Name > Sheets(RepSheet).Cells(ListRow, "B").Value = f.Path > Sheets(RepSheet).Cells(ListRow, "C").Value = f.Size > Sheets(RepSheet).Cells(ListRow, "D").Value = f.datecreated > Sheets(RepSheet).Cells(ListRow, "E").Value = > f.datelastmodified > End If > Next File > ' > Set Folders = Folder.subfolders > For Each Folder In Folders > File_Cnt = File_Cnt + Get_Folders(Folder.Path) > Next Folder > ' > On Error GoTo 0 > Get_Folders = File_Cnt > End Function > Function Clear_Report() > Sheets(RepSheet).Range("A2:Z100").ClearContents > Sheets(RepSheet).Range("A1").Value = "FileName" > Sheets(RepSheet).Range("B1").Value = "Path" > Sheets(RepSheet).Range("C1").Value = "Size" > Sheets(RepSheet).Range("D1").Value = "Date Created" > Sheets(RepSheet).Range("E1").Value = "Date Modified" > ListRow = 1 > End Function > > > > *Paul* > > > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Pankaj Michael > *To:* excel-macros@googlegroups.com > *Sent:* Wednesday, October 7, 2015 10:58 PM > *Subject:* $$Excel-Macros$$ Select all excel files in computer > > > Hi to ALL, > > Can we search ALL excel extension files through vba in a computer(All > Drives) through VBA? Transfer to any other location. Priority is excel > > I want to shift all excel files from one computer to another because > company is replacing systems and only ms office files needs to transfer as > per policy. > > Please help > > > > -- > > Thanks > Pankaj Kumar > 9910075248 > -- > 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
Re: $$Excel-Macros$$ Select all excel files in computer
Awesome! You are doing a great job for the learners like us. We all believe in the process of KT i.e. knowledge Transfer. But, I think you are the best definition of this term and process. Thanks a ton, Paul for all your codes and salute to your efforts and intention to help us always!!! Mangesh On Oct 8, 2015 11:09 PM, "Paul Schreiner" <schreiner_p...@att.net> wrote: > Thanks for your kind words! > > To be honest, it's mostly just experience, and "need". > > I started with writing programs (C+) and UNIX scripts in the mid 1980's. > > I currently maintain over 170,000 lines of VBA code for applications that > manage over 1,000,000 manufacturing documents and create reports from the > data contained in them. > > so, when this question came up, I knew I had some code from several years > ago. > (it was last updated in February of 2013) > So, I just grabbed it and modified it a bit to fit the question. > > It's a collection of macros I use to maintain archives. When new versions > of documents are created, the old ones get moved to an "archive" folder. > Periodically I run this macro that takes the archive folder and breaks up > the files into set not exceeding 700mb so that I can move them to CD's for > long-term storage. (I keep a copy on an external backup for easy access) > Currently, my archive folder has 12,000 files in 1,100 folders requiring > 2.2 Gb. Running the macro, in less than 2 minutes the files will be neatly > separated into separate 700Mb folders. > > As far as logic goes: I think it helps that I learned programming in an > era that had limited storage. My first programming class used punch cards. > We only were allowed to use the "terminals" once our programs compiled > successfully! > > I learned early on that the most TIME CONSUMING part of any program is > READING, WRITING and updating the display. > > So, I try whenever possible to NOT manipulate data within the cells. > but instead read the entire dataset into memory, do all my manipulations > and calculations, then write it out and refresh the display at the end. > > The other thing that adds to the "experience" is groups like this. > If my only experience was through my job, how many opportunities would I > have to run across date arithmetic problems? cost calculations? > > Instead, while I'm waiting for some of my longer programs to run (or > during lunch) I'll look through the user groups for things that look > "challenging". > Or something I can throw together quickly. > sometimes, I just answer posts because I think I can do it better/faster! > (lol) > > > With these user groups. "Communication is Key". > When I was in college, I could remember nearly all the formulas in > Calculus, but what I couldn't do was figure out when to use them! > > With the posts in user groups, there's just no convenient way we can know > all the background behind the NEED for the questions being asked. > So we have to make assumptions. > If the person asking the question doesn't recognize when we made an > assumption, he may not recognize when the assumption isn't correct. > So I try to explain WHY I selected a specific approach. > > Speaking of which... back to work! > > > > *Paul* > - > > > > > > > > *“Do all the good you can,By all the means you can,In all the ways you > can,In all the places you can,At all the times you can,To all the people > you can,As long as ever you can.” - John Wesley* > - > > -- > *From:* Mangesh Vimay <mangesh.da...@gmail.com> > *To:* excel-macros@googlegroups.com > *Sent:* Thursday, October 8, 2015 12:31 PM > *Subject:* Re: $$Excel-Macros$$ Select all excel files in computer > > Paul, > I have been reading your codes since 2011. How do you manage to write > these codes in so simple manner? Is there any logic? Please guide. > Mangesh > > > On Oct 8, 2015 6:45 PM, "Paul Schreiner" <schreiner_p...@att.net> wrote: > > The answer is "yes", you CAN. > How it's DONE is a bit more difficult. > > First of all, by "all drives" you must mean all physical drives (hard > drives) > since mapped network drives aren't "on" the computer they can be mapped on > the new system and nothing is lost. > > So, you only have to deal with "fixed" drives. > > Prior to Excel2007, VBA had a filesystem "search" utility. > It was dropped in Excel2007 and I don't believe it has been restored. > > consequently, you have to use "brute force" to accomplish it. > > Basica
Re: $$Excel-Macros$$ Need help - How to enter the text in the cells of column by using textbox in userform
Thanks a ton !!! On 8/20/13, De Premor d...@premor.net wrote: paste this on userform1 ' Dim Target As Range Private Sub CommandButton1_Click() Target.Offset(1).Select Unload Me End Sub Private Sub TextBox1_Change() Target = TextBox1.Text End Sub Private Sub UserForm_Activate() Set Target = Selection TextBox1.Text = Target End Sub '-- Pada 19/08/2013 23:36, Mangesh Vimay menulis: Hi Friends, Please suggest me vba code to enter the text in A1, A2, A3..likewise by using VBA Userform textbox. I have attached sample file for you reference. Double click on cell A1, A2 will open the useform for which I need the code. Thanks in advance. -- 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. -- With regards, *MaNgEsH* -- 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.
Re: $$Excel-Macros$$ how to make a file expire after a period of time.
Thanks for asking this query. Appreciate your mind !!! And also thanks De Pemor for the solution. Have a great day all !!! On 7/29/13, Kannan Excel kannan.ex...@gmail.com wrote: Hi, I want to set particular date and* time* also for expire is this possible.??? Or i want to set date and time for password... When i set date and time, password will appear automatically pls do the needful ASAP... On Sat, Jul 27, 2013 at 3:19 PM, De Premor d...@premor.net wrote: Using macro, but required user to run the macro This is the basic, user still can skip this by changing date on his computer Private Sub Workbook_Open() Dim Expired As Date Expired = 20 Jul 2013 If Now() Expired Then MsgBox File ThisWorkbook.FullName expired ThisWorkbook.Close End If End Sub Next step, you may add a cell validation on current file to avoid skipped by user with changin the date on his computer Once the expiration msg appear, it will write in sheet1 cell A1 a word EXPIRED, then everytime file open, it will check that cell and also the date on current computer, if one of that criteria match then it will still close the workbook. If Now() Expired or *Sheet1**.Range(**A1) = EXPIRED* Then MsgBox File ThisWorkbook.FullName expired *if Sheet1**.Range(**A1) EXPIRED then ** Sheet1.Range(A1) = EXPIRED** * *ThisWorkbook.Save End If * ThisWorkbook.Close End If Rgds, [dp] Pada 27/07/2013 15:55, Kannan Excel menulis: Hi, how to make a file expire after a period of time. regards Kannan V -- 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. -- 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
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Thank you very much !!! On 7/7/13, vba v...@vabs.in wrote: Hi PFA... Reason for error: cell was referring to NA. Make sure cell is referred correctly. Thanks On Sun, Jul 7, 2013 at 10:04 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi, When I am trying to run the macro, I am getting the error of type mismatch. (Please see the tab error in the attached sheet and the line which is getting error is highlighted in red color,) Also, it may be due to the cell K7 from the data sheet. Please suggest how to resolve it. Many thanks ! On 7/6/13, Mangesh Vimay mangesh.da...@gmail.com wrote: This group becomes special and the popular in a very small span of timebecause of the members like you and others. Thanks a lot !!! On 7/6/13, vba v...@vabs.in wrote: Thanks for Acknowledgement.. Cheers!! On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks you both for your great help. Ravinder, I didn't get what you said. Do I need to use the mentioned formula in data validation box? Please suggest. On 7/6/13, ravinder negi ravi_colw...@yahoo.com wrote: PFAtry this and advise if this does not work propery.. you just need to copy paste formula in validation rng selection box and it will automatically create range from the second sheet and in second sheet you can add more data and those will be also add in list...but your second sheet data should formated as given by you. --- On Sat, 7/6/13, Mangesh Vimay mangesh.da...@gmail.com wrote: From: Mangesh Vimay mangesh.da...@gmail.com Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists To: excel-macros@googlegroups.com Date: Saturday, July 6, 2013, 11:20 AM Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba v...@vabs.in wrote: Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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. -- With regards, *MaNgEsH* -- 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
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Simply Great !!! Could you please share final workbook. Sorry, for this. Thanks a ton !!! On 7/6/13, vba v...@vabs.in wrote: Hi You dont have to create name, this will be created programatically for data in DATA sheet. Just copy paste B2 or drag down. Hoe Name is created by this Macro: First Data sheet is sort on the basis of ID; then unique ID is pasted in range J2 downwards. Then Name is defined for each ID beginning with _ Cheers!! On Sat, Jul 6, 2013 at 2:45 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi, Thanks for the help. But, how to create data validations in the first sheet based on the list which you have retrieved by using code. Please help. On 7/6/13, vba v...@vabs.in wrote: Hey PFA. HTH On Sat, Jul 6, 2013 at 11:20 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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. -- With regards
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Thanks you both for your great help. Ravinder, I didn't get what you said. Do I need to use the mentioned formula in data validation box? Please suggest. On 7/6/13, ravinder negi ravi_colw...@yahoo.com wrote: PFAtry this and advise if this does not work propery.. you just need to copy paste formula in validation rng selection box and it will automatically create range from the second sheet and in second sheet you can add more data and those will be also add in list...but your second sheet data should formated as given by you. --- On Sat, 7/6/13, Mangesh Vimay mangesh.da...@gmail.com wrote: From: Mangesh Vimay mangesh.da...@gmail.com Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists To: excel-macros@googlegroups.com Date: Saturday, July 6, 2013, 11:20 AM Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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. -- With regards, *MaNgEsH* -- 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
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
This group becomes special and the popular in a very small span of timebecause of the members like you and others. Thanks a lot !!! On 7/6/13, vba v...@vabs.in wrote: Thanks for Acknowledgement.. Cheers!! On Sat, Jul 6, 2013 at 5:50 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks you both for your great help. Ravinder, I didn't get what you said. Do I need to use the mentioned formula in data validation box? Please suggest. On 7/6/13, ravinder negi ravi_colw...@yahoo.com wrote: PFAtry this and advise if this does not work propery.. you just need to copy paste formula in validation rng selection box and it will automatically create range from the second sheet and in second sheet you can add more data and those will be also add in list...but your second sheet data should formated as given by you. --- On Sat, 7/6/13, Mangesh Vimay mangesh.da...@gmail.com wrote: From: Mangesh Vimay mangesh.da...@gmail.com Subject: Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists To: excel-macros@googlegroups.com Date: Saturday, July 6, 2013, 11:20 AM Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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
$$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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. DropDownList.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ To create drop down list for many IDs as per many lists
Hi Be Tran Van, Thank you for your quick help. However, in my original workbook there are total 1200 lists and its quite time consuming job to create named range for all 1200 lists and then to specify the source for all the lists for data validations. Could you please suggest shortcut way/method so that I can create named range for all and then drop down list using data validation. I think, we can use vlookup, vba code to specify the named range and then to create data validations. But how, I really don't know. Appreciate your help. Thanks again !!! Regards, Mangesh On 7/6/13, Bé Trần Văn betnmtdongna...@gmail.com wrote: You select C3: C6 setting Name1, C7:C12 setting Name2, C13:C20 setting Name3. B2 Validation with Source = Name1 B3 Validation with Source = Name2 B4 Validation with Source = Name3 2013/7/6 Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached Excel file for the reference. I am unable to create a list for each ID as there are such 1200 lists for many IDs. So I need formula or vba macro to create such drop down lists for every Id given in the column A so that I can select required option from the drop down list for every ID. Appreciate your help. Detailed explanation is given in the attached sheet. Please help. Thank a ton. With regards, *MaNgEsH* -- 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. -- With regards, *MaNgEsH* -- 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
Re: $$Excel-Macros$$ vba code to insert chart from another excel file
Friends, Please help me to get this issue resolved. Thanks in advance !!! On 2/10/13, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need vba code to insert a chart from another Excel file. I have attached sample sheet. Please do the needful. Thanks !!! -- With regards, *MaNgEsH* -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- With regards, *MaNgEsH* -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out.
Re: $$Excel-Macros$$ vba code to insert chart from another excel file
Hi Ashish, Yes there will be more than one chart or max two i want to add these chart in the main sheet. Would you please suggest me the code. Thanks a ton !!! On Mon, Feb 11, 2013 at 8:37 PM, ashish koul koul.ash...@gmail.com wrote: will thr be more than one chart in source workbook. If so what would u like to do , On Mon, Feb 11, 2013 at 2:04 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Friends, Please help me to get this issue resolved. Thanks in advance !!! On 2/10/13, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need vba code to insert a chart from another Excel file. I have attached sample sheet. Please do the needful. Thanks !!! -- With regards, *MaNgEsH* -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- With regards, *MaNgEsH* -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- *Regards* * * *Ashish Koul* *Visit* *My Excel Blog http://www.excelvbamacros.com/* Like Us on Facebookhttp://www.facebook.com/pages/Excel-VBA-Codes-Macros/15180389897 Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. -- With regards, *MaNgEsH* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you
$$Excel-Macros$$ vba code to insert chart from another excel file
Hi Friends, I need vba code to insert a chart from another Excel file. I have attached sample sheet. Please do the needful. Thanks !!! -- With regards, *MaNgEsH* -- 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?hl=en. For more options, visit https://groups.google.com/groups/opt_out. Sample.xlsm Description: Binary data
Fwd: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.
Hi Friends, Please help me by providing the solution. Thanks in advance. -- Forwarded message -- From: Mangesh Vimay mangesh.da...@gmail.com Date: Tue, Nov 20, 2012 at 12:24 AM Subject: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file. To: excel-macros@googlegroups.com, Mangesh Vimay mangesh.da...@gmail.com Hi Friends, I have attached the file where I need to export specific range to another excel file which to be save on C: drive. I have created userform for this as well. Need vba code to perform this task. Waiting for the solution. Please help !!! -- With regards, *MaNgEsH* -- 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. -- With regards, *MaNgEsH* -- 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. ExportRange.xlsm Description: Binary data
Re: $$Excel-Macros$$ Please help - How to export specific range by ID to other excel file.
Thank you so much Natron. You have made my work very easy. Thanks again. On Tue, Nov 20, 2012 at 6:35 PM, Natron protoc...@gmail.com wrote: See attached, with the code I used below...there are many other ways to do this. 'This is hooked to your Export Specific Data Button on your form Private Sub cmdExport_Click() Dim intStart As Integer, intEnd As Integer On Error GoTo whoops intStart = Me.txtStart intEnd = Me.txtEnd If intStart intEnd Then GoTo whoops exportme Me.Hide Exit Sub whoops: MsgBox Please enter two integers and try again End Sub 'This is put into a Module Sub exportme() '' 'Original Script Written by www.ozgrid.com '' Dim rRange As Range Dim strCriteria As String, strCriteria2 As String Dim lCol As Long Dim rHeaderCol As Range Dim xlCalc As XlCalculation On Error Resume Next Step1: Set rRange = Range(A1).CurrentRegion 'Cancelled or non valid rage If rRange Is Nothing Then Exit Sub 'Awlays use GoTo when selecting range so doesn't matter which Worksheet Application.Goto rRange.Rows(1), True step2: lCol = 1 Step3: strCriteria = frmExport.txtStart strCriteria2 = frmExport.txtEnd 'Store current Calculation then switch to manual. 'Turn off events and screen updating With Application xlCalc = .Calculation .Calculation = xlCalculationManual .EnableEvents = False .ScreenUpdating = False End With 'Remove any filters ActiveSheet.AutoFilterMode = False Dim s As Range With rRange 'Filter, offset(to exclude headers) .AutoFilter Field:=lCol, Criteria1:== strCriteria, Operator:=XlAutoFilterOperator.xlAnd, Criteria2:== strCriteria2 .Offset(1, 0).SpecialCells(xlCellTypeVisible).Copy End With Workbooks.Add ActiveSheet.Paste ChDir C:\ ActiveWorkbook.SaveAs Filename:=C:\YourFile.xlsx, FileFormat:= _ xlOpenXMLWorkbook, CreateBackup:=False ActiveWorkbook.Save ActiveWindow.Close 'Remove any filters ActiveSheet.AutoFilterMode = False 'Revert back With Application .Calculation = xlCalc .EnableEvents = True .ScreenUpdating = True End With On Error GoTo 0 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. -- With regards, *MaNgEsH* -- 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$$ Please help - How to export specific range by ID to other excel file.
Hi Friends, I have attached the file where I need to export specific range to another excel file which to be save on C: drive. I have created userform for this as well. Need vba code to perform this task. Waiting for the solution. Please help !!! -- With regards, *MaNgEsH* -- 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. ExportRange.xlsm Description: Binary data
Re: $$Excel-Macros$$ Need Help for Access 2007- How to remove unwanted characters from table.
but how? Can you help me please. On 11/9/12, Anoop K Sharma aks.sharm...@gmail.com wrote: Use Clean function On Fri, Nov 9, 2012 at 12:09 AM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like question mark in square i.e. [image: Inline image 1], etc. I want to remove these characters from the table so that they can not be view in the from and table should be clean from such unwanted characters. I takes much time to remove them manually as my table contains more than 2000 records. Please help me by providing some suitable vba code or any other method. I need your help for this. Thanks in advance. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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, Anoop -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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$$ Need Help for Access 2007- How to remove unwanted characters from table.
Hi Friends, I need your help. I have Excel file containing some data. I have import this data to MS Access 07 table by using Append query. But when I access the table, it contains some un-wanted characters like question mark in square i.e. [image: Inline image 1], etc. I want to remove these characters from the table so that they can not be view in the from and table should be clean from such unwanted characters. I takes much time to remove them manually as my table contains more than 2000 records. Please help me by providing some suitable vba code or any other method. I need your help for this. Thanks in advance. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. image.png
Re: $$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro
Thanks Ashish for the great support !!! Please try to solve the query of RajaSekhar as it is also important for me. Thanks again On Tue, Oct 23, 2012 at 1:17 AM, Rajasekhar Praharaju rajasekhar.prahar...@gmail.com wrote: Hi Ashish, Adding to below i do maintain huge data base of access but if i want to export to excel i am facing the problem as there are more than 2lac rows or records in access Just require ur expertise can i use the same macro which is listed below if so please advise the sql command to get for example to export complete details in batches wise 1st record to 6 th record like wise. Thanks, Raj On Sun, Oct 21, 2012 at 10:13 PM, ashish koul koul.ash...@gmail.comwrote: Option Compare Database Private Sub Command11_Click() ' Add microsoft Excel ' ADD aTIEVEX DATA OBJECT Dim xla As Excel.Application Dim wk As Excel.Workbook Dim cn As New ADODB.Connection Dim rs As New ADODB.Recordset Dim j As Long Set cn = CurrentProject.Connection qry = select * from Details where [Details].[Details] like '% Me.Text12.Value %' rs.Open qry, cn, adOpenDynamic, adLockOptimistic If rs.EOF = True Then MsgBox No Records found, vbInformation, Note: rs.Close cn.Close Exit Sub End If Set xla = New Excel.Application Set wk = xla.Workbooks.Add For i = 0 To rs.Fields.Count - 1 wk.Sheets(1).Cells(1, i + 1).Value = rs.Fields(i).Name Next wk.Sheets(1).Range(A2).CopyFromRecordset rs wk.Sheets(1).UsedRange.EntireColumn.AutoFit xla.Visible = True End Sub On Sun, Oct 21, 2012 at 9:24 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Deal ALL, Please help me on above issue. Please !!! With regards, Mangesh On Sat, Oct 20, 2012 at 11:08 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Ashish, It is for just exporting result set to Excel. But, I need code for search criteria as well. Please do needful. Thanks !!! With regards, Mangesh On Sat, Oct 20, 2012 at 10:32 PM, ashish koul koul.ash...@gmail.comwrote: just make small changes in this file and it will work as per your requirement http://accessvbaprogramming.wordpress.com/2012/09/18/type-sql-query-in-text-box-in-access-form-and-export-output-to-excel/ On Sat, Oct 20, 2012 at 10:30 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain, Thank you so much for your reply. I have attached database file (sample) to show you what exact I need. Please find the file Temp. In Temp we have two objects Table - Detail Form - City Details In the Form I have inserted search criteria text box in which if I enter the text Capital and click on the Search button. Then It should export the result into Excel file with the result set like below : ID City Details 3 Mumbai Financial Capital of India 6 Delhi Capital of India So I get above output in excel file because it is containing the string capital. It can be done by Macro. And please help- me on this. Thanks With regards Mangesh On Sat, Oct 20, 2012 at 6:35 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear mangesh, Please see attached access database. Hope it will help to you. On Sat, Oct 20, 2012 at 12:20 AM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I am using MS Access 2007. I have table called City. The table City contains the information of the different cities of INDIA with their details. For example, CityDetails Mumbai It is the Financial capital of India Delhi Capital of India I have also form for retrieving details of the city It contains the drop down list for all cities of India If I select Mumbai from the drop down list, then it should display the details. However, I have another search option i.e. Search by Keyword In Search by keyword, if we enter any string from the details column. It should display all records that consists the specified string. For example, if we enter the string capital in text box, then it should display all records containing the string capital. I need the macro (or any other solution) to do this. I hope, I am able to explain what I need. I know, this group is dedicated to MS Excel only. But I also know there are many experts who does well in Access as well. So I request all please help me by providing suitable solutions. Appreciate your help !!! Thanks in Advance !!! -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
$$Excel-Macros$$ Need your advise - MS Access 2007 drop down list Macro
Hi Friends, I am using MS Access 2007. I have table called City. The table City contains the information of the different cities of INDIA with their details. For example, CityDetails Mumbai It is the Financial capital of India Delhi Capital of India I have also form for retrieving details of the city It contains the drop down list for all cities of India If I select Mumbai from the drop down list, then it should display the details. However, I have another search option i.e. Search by Keyword In Search by keyword, if we enter any string from the details column. It should display all records that consists the specified string. For example, if we enter the string capital in text box, then it should display all records containing the string capital. I need the macro (or any other solution) to do this. I hope, I am able to explain what I need. I know, this group is dedicated to MS Excel only. But I also know there are many experts who does well in Access as well. So I request all please help me by providing suitable solutions. Appreciate your help !!! Thanks in Advance !!! -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Fun with Chart
Awesome !!! Aisa bhi hota hai Excel mein ...??? Surprise !!! On 10/10/12, Ahmed Honest ahmedhon...@gmail.com wrote: Dear Rajan, Salute for your Support and Talent. Will it not be better to enlight us with your skills by having a list of topic to educate the group from that list one by one, so that we become more productive in our daily life work. For sure, I believe you too believe that Sharing Knowledge always expands and teaches you looot of experience... (My understanding is that someone like you should come up and do this initiative so that people expand and think beyond imagination to improve and for learners it will be a DAMN think out of box support). Think of this initiative if you can help us... Anyways, thanks again for your Support and Talent. Best Regars Ahmed Bawazir On Wed, Oct 10, 2012 at 7:16 PM, Rajan_Verma rajanverma1...@gmail.comwrote: * * *Just sharing fun with charts.* * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Ahmed Bawazir *احمد باوزير* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA
Hi Friends, I need to create a chart based on the chart type selected from the drop down list (created by data validation). The sample data is being provided in the sheet. Every time when we create the chart previous chart should get deleted. [Find the attachment]. Please do it by using VBA. Thanks in advance. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. Create Chart.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA
Hi Rajan, Its sample data I have provided but the data range would remain same. Please provide solution. Thanks !!! On Wed, Oct 3, 2012 at 6:43 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Is your data suitable for all chart type ? * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 03 October 2012 6:39 *To:* excel-macros@googlegroups.com; Mangesh Vimay *Subject:* $$Excel-Macros$$ Help - To create chart based on the chart type select by using VBA ** ** Hi Friends, ** ** I need to create a chart based on the chart type selected from the drop down list (created by data validation). The sample data is being provided in the sheet. Every time when we create the chart previous chart should get deleted. [Find the attachment]. ** ** Please do it by using VBA. ** ** Thanks in advance. ** ** ** ** -- With regards, ** ** *MaNgEsH* ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Excel vba
I am agree with Paul. This group is the main source of information on Excel and its basics. On Wed, Sep 12, 2012 at 7:40 PM, Paul Schreiner schreiner_p...@att.netwrote: I don't mean to be difficult, or unhelpful, or snotty, or seem to be any other bad description, but this group is designed to help people that are having difficulty with VBA macros. Not necessarily teach VBA from scratch. I think one of the BIGGEST lessons any of us need to learn is how to look for help. The minute we have a question, we should LOOK for the answer instead of simply asking someone to provide the answer. Many times while looking for an answer to one question, I find the answers to questions I didn't know I had (until later!). As far as beginner learning, the same question has been asked several times in the past month in this very forum. Instead of asking someone else to look up the previous responses, you should try to look for yourself. Simply looking for learn in this forum should give you previous responses with links to sites specializing in teaching beginners. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Shiva Prasad shivaprasad1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Wed, September 12, 2012 9:05:01 AM *Subject:* $$Excel-Macros$$ Excel vba hi team, my job profile is mis analyst level, have experience in excel depth formulas level but i need develops in excel VBA I want to learn excel vba , could any one give help me -- Regards, Shivaprasad K. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook.
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Its really Great Help Asa !!! Thanks a ton !!! On Tue, Sep 11, 2012 at 7:07 AM, Asa Rossoff a...@lovetour.info wrote: Hi Mangesh, I've read your other replies, and as to why you haven't received a formula method -- most people don't want to take the trouble on a volunteer basis to provide a more complex or difficult solution to a given problem when simple solutions exist. Also in business, the simplest solution is the best value. But I understand that in learning all aspects of a program, sometimes the exercise of solving a problem in various ways is useful. ** ** I will provide a formula solution for you. Although it could be solved several ways, I prefer using an array formula, since it can be written in such a way that it can handle a string of text with any number of commas, whereas non-array solutions would be limited to a set maximum. However, even with the array solution, and even though the array will contain all of the parts of the text string, you will only see on your spreadsheet as many parts as there are cells in the area you place the array formula (there are ways to use array formulas with too large of arrays to display on your spreadsheet ,as part of other formulas, that are useful; for example extracting certain values matching a condition, or summarizing the data (in your data, you might want to know how many Mumbais there are, how many 32145s, etc.), without actually displaying in multiple columns all the split data. ** ** **·***Select any cell on row 2* of your spreadsheet, *then create the following defined names* using the Name Manager (formulas tab in Excel 2007+). I recommend *making them Sheet-level names* rather than the default Workbook-level. **1. ***Name* =$A2 **2. ***_Name.Terminated* =Name, **3. ***_Name.ColumnIdx* =TRANSPOSE(ROW(INDIRECT(1:LEN(_Name.Terminated)-LEN(SUBSTITUTE(_Name.Terminated,,,) **4. ***_Name.StartPositions* =IF(Name.ColumnIdx1,FIND(CHAR(1),SUBSTITUTE(Name,,,CHAR(1),_Name.ColumnIdx-1)))+1 **5. ***_Name.StopPositions* =FIND(CHAR(1),SUBSTITUTE(_Name.Terminated,,,CHAR(1),_Name.ColumnIdx))-1* *** **6. ***Name.Columns* =MID(Name,_Name.StartPositions,_Name.StopPositions-_Name.StartPositions+1) ** ** *The purpose of using the defined names is to simplify the formula by breaking it into steps. Insofar as the steps are referred to more than once in the formula, it should make the formula faster to evaluate too. * *Name.Columns** is the culmination of our calculation and results in an array containing each comma-separated value from column A, divided into separate columns.* ** ** **·**To display the column-separated values on your spreadsheet, *enter the following formula in **B2*: =Name.Columns ** ** **·**Then *highlight from **B2** to the furthest column on row 2 needed* to display the maximum number of values ever expected. For a maximum of 3 values, highlight B2:D2, or for maximum of 10, B2:K2, etc.*** * **·**Then hit *F2* (edit cell) and *Ctrl-Shift-Enter* (confirm array formula). This confirms a multi-cell array formula over the selected cells. **·**Copy the array-entered range from row 2 (e.g. B2:D2) to every other row in your table. ** ** Hope this is of interest, Asa ** ** ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* Monday, September 10, 2012 4:04 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need help - To divide the string into three parts ** ** Hi Friends, ** ** I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. ** ** Thanks. ** ** -- With regards, ** ** *MaNgEsH* ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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
Re: $$Excel-Macros$$ FW: macro for pivot
Where is the file ? On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee lee.sar...@gmail.com wrote: --- ** *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 7:41 *To:* Rajan_Verma *Subject:* Re: macro for pivot ** ** once i copy and paste into a new module, how to run this macro? how do i link this code to the spreadsheet i am working on? Can you please give exact steps On Sun, Sep 9, 2012 at 8:14 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *You can copy paste this code , if dost not work , post you query on group then with your original data. **J* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 6:39 *To:* Rajan_Verma *Subject:* Re: macro for pivot Can i copy and paste this code on any file with pivot and slicers. If not , how would i change the code accordingly? i am null with VB. please advise On Sun, Sep 9, 2012 at 8:04 AM, Sara Lee lee.sar...@gmail.com wrote: Thank you. i will posit it from here on. On Sun, Sep 9, 2012 at 8:03 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *See the attached file..* *You can also post this on group * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ FW: macro for pivot
Hi Rajan, I need that file for pivot code. Can you provide same again as I am unable to see as an attachment. Thanks. On Tue, Sep 11, 2012 at 8:41 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Paste that Code in Respective Sheet Code Module * *e.g If your pivot sheet is Sheet3 then Double Click on Sheet3 in VBE And paste that code* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 11 September 2012 8:40 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ FW: macro for pivot ** ** Where is the file ? ** ** On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee lee.sar...@gmail.com wrote: ** ** --- *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 7:41 *To:* Rajan_Verma *Subject:* Re: macro for pivot once i copy and paste into a new module, how to run this macro? how do i link this code to the spreadsheet i am working on? Can you please give exact steps On Sun, Sep 9, 2012 at 8:14 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *You can copy paste this code , if dost not work , post you query on group then with your original data. **J* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 6:39 *To:* Rajan_Verma *Subject:* Re: macro for pivot Can i copy and paste this code on any file with pivot and slicers. If not , how would i change the code accordingly? i am null with VB. please advise On Sun, Sep 9, 2012 at 8:04 AM, Sara Lee lee.sar...@gmail.com wrote: Thank you. i will posit it from here on. On Sun, Sep 9, 2012 at 8:03 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *See the attached file..* *You can also post this on group * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * ** ** ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. ** ** -- With regards, ** ** *MaNgEsH* ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ FW: macro for pivot
Thanks Rajan. On Tue, Sep 11, 2012 at 8:46 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Is it?* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 11 September 2012 8:45 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ FW: macro for pivot ** ** Hi Rajan, ** ** I need that file for pivot code. Can you provide same again as I am unable to see as an attachment. Thanks. On Tue, Sep 11, 2012 at 8:41 PM, Rajan_Verma rajanverma1...@gmail.com wrote: *Paste that Code in Respective Sheet Code Module * *e.g If your pivot sheet is Sheet3 then Double Click on Sheet3 in VBE And paste that code* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 11 September 2012 8:40 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ FW: macro for pivot Where is the file ? On Sun, Sep 9, 2012 at 7:49 PM, Sara Lee lee.sar...@gmail.com wrote: --- *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 7:41 *To:* Rajan_Verma *Subject:* Re: macro for pivot once i copy and paste into a new module, how to run this macro? how do i link this code to the spreadsheet i am working on? Can you please give exact steps On Sun, Sep 9, 2012 at 8:14 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *You can copy paste this code , if dost not work , post you query on group then with your original data. **J* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* Sara Lee [mailto:lee.sar...@gmail.com] *Sent:* 09 September 2012 6:39 *To:* Rajan_Verma *Subject:* Re: macro for pivot Can i copy and paste this code on any file with pivot and slicers. If not , how would i change the code accordingly? i am null with VB. please advise On Sun, Sep 9, 2012 at 8:04 AM, Sara Lee lee.sar...@gmail.com wrote: Thank you. i will posit it from here on. On Sun, Sep 9, 2012 at 8:03 AM, Rajan_Verma rajanverma1...@gmail.com wrote: *See the attached file..* *You can also post this on group * * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. image.png
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Thanks ALL for the Great Help !!! On Mon, Sep 10, 2012 at 5:25 PM, David Grugeon da...@grugeon.com.au wrote: In B2 put =LEFT(A2,FIND(,,A2)-1) In C2 put =MID(A2,LEN(B2)+2,FIND(,,A2,LEN(B2)+2)-LEN(B2)-2) In d2 put =MID(A2,LEN(B2C2)+3,99) On 10 September 2012 21:04, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Regards David Grugeon -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. image.png
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Hi Guillett, I would like to know all possible ways of cutting the string into three parts. So please do needful by suggesting very simple formula for same. Thanks !!! On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 dguille...@gmail.com wrote: Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, September 10, 2012 6:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Mangesh, you can use text to colum Regard Manoj On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use
Re: $$Excel-Macros$$ Need help - To divide the string into three parts
Thanks all for their great support to solve this problem. On Mon, Sep 10, 2012 at 8:27 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Would it be simple for you* * * *Function SplitString(rngRange As Range) As Variant* *SplitString = Split(rngRange.Value, ,)* *End Function* * * *See the attached file.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Mangesh Vimay *Sent:* 10 September 2012 7:55 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into three parts ** ** Hi Guillett, ** ** I would like to know all possible ways of cutting the string into three parts. So please do needful by suggesting very simple formula for same.*** * Thanks !!! On Mon, Sep 10, 2012 at 5:40 PM, dguillett1 dguille...@gmail.com wrote:* *** Why clutter it up by using UN necessary formulas to clutter up the file? Unless, of course, this is HOMEWORK Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, September 10, 2012 6:11 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ Need help - To divide the string into three parts Yes u r right. I did by using Text to Column option. Its works fine. But I need it by using formula. Thanks ** ** On Mon, Sep 10, 2012 at 4:36 PM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Mangesh, you can use text to colum Regard Manoj ** ** On Mon, Sep 10, 2012 at 4:34 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to divide the string into three parts. The description and sample is given below : [image: Inline image 1] Waiting for your response. Thanks. -- With regards, ** ** *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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 mailto:excel-macros%2bunsubscr...@googlegroups.comexcel-macros%2bunsubscr...@googlegroups.com . -- With regards, ** ** *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
Re: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here)
Thats Great !!! On 9/8/12, dguillett1 dguille...@gmail.com wrote: me too.. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Paul Schreiner Sent: Friday, September 07, 2012 11:16 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Urgent... Please Help... (place useless subject here) Is it me? or does the use of this type of Subject line seem to be increasing lately? I think we (those that enjoy lending assistance) ought to each start a log file. In it, place the name of each person that says Urgent, and Please Help or some other useless subject. Then, they'll received ONE reminder. After that, if they do it again, we'll either ignore them or send some kind of equally useless response. Like: 66,000... all orange... hope this helps (lol) I wonder if the site design would allow the Forum Rules to display at the TOP of the window when creating a New Topic I suspect that many people have found the Group through Google and have never bothered to read the rules. Although, IMHO they shouldn't NEED to read them, since they are really common sense. I mean really: If you want someone to help you, tell them what you need. (And please.. don't get upset if they cannot read your mind.) Is that so difficult? Paul S. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Re: How to import data from Oracle SQL to MS Excel ?
Hi Prince, Thanks. But please let me know if this is vba code or something else. On 9/4/12, Prince Dubey prince141...@gmail.com wrote: Hi Mangesh You can use an sddin to simplify your task for example you can use SQLodbc ( *http://sqlodbc.t35.com* http://sqlodbc.t35.com/) =sql.execute(CONNECTION STRING;YOUR SQL CODE); hope this will help you regards prince dubey. On Monday, September 3, 2012 6:03:56 PM UTC+5:30, Mangesh wrote: Hi Friends, I would like to import the data/query result of Oracle SQL to Excel. Can you please help me by providing suitable solution over my problem. You can also suggest VBA code/guidelines to solve the issue. Thanks lot !!! -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Noorain Ansari - Most Helpful Member August 2012
Congratulations Noorain for your great support. On 9/3/12, rameshwari shyam rameshwarish...@gmail.com wrote: Hi Noorain sir, Congratulation to help people thanks regards, Rameshwari On Sun, Sep 2, 2012 at 9:02 AM, Ayush Jain jainayus...@gmail.com wrote: Dear members, Once again, Noorain Ansari has been selected as 'Most Helpful Member' for the month of Aug'12. He has posted 111 posts in August 2012 and helped many forum members through his excel expertise. I truly appreciate his consistency and commitment to the group. He is really doing great job. *Noorain, please find enclosed the award certificate in honour of your contribution.* Thanks to all other folks for helping excel enthusiasts voluntarily !! Keep posting. Regards, Ayush Jain Group Manager Microsoft MVP -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
$$Excel-Macros$$ How to import data from Oracle SQL to MS Excel ?
Hi Friends, I would like to import the data/query result of Oracle SQL to Excel. Can you please help me by providing suitable solution over my problem. You can also suggest VBA code/guidelines to solve the issue. Thanks lot !!! -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Pivot Table Vba Help needed
Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 8/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kaushik, Please find attached VBA Pivot Table Template, Hope it will help to you. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to extract the details of each supplier in different tab so as to create an invoice for the individual supplier showing them the transactions during the amount. The extracted data should automatically extract data from pivot for as many supplier available. In the attached file as instance there are 4 suppliers namely A,B,C,D.* *4. The extracted data should automatically rename the worksheet tab containing the name of supplier.* * * *Looking forward for your prompt response.* * * *Regards,* *Kaushik Savla* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ How to import data from Oracle SQL to MS Excel ?
Thanks you Ashish On 9/3/12, ashish koul koul.ash...@gmail.com wrote: http://www.connectionstrings.com/Forum/excel/how-to-export-excel-worksheet-to-mysql-db-with-vba http://www.excel-sql-server.com/excel-sql-server-import-export-using-vba.htm On Mon, Sep 3, 2012 at 6:03 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I would like to import the data/query result of Oracle SQL to Excel. Can you please help me by providing suitable solution over my problem. You can also suggest VBA code/guidelines to solve the issue. Thanks lot !!! -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- *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 (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Pivot Table Vba Help needed
Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 9/3/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain, You have sent very good file for learning PT with all options in terms of VBA. Can you send same kind of file for Chart as well. Thanks in Advance. On 8/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Kaushik, Please find attached VBA Pivot Table Template, Hope it will help to you. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com On Fri, Aug 31, 2012 at 6:20 PM, KAUSHIK SAVLA savla.kaus...@gmail.comwrote: Hi All, *Need your help to perform the attached task.* * * *What I am doing is as below:=* * * *1. I am having the data in the Data tab of the file* *2. I want to create the Pivot table based on the Data tab with Criteria as Row Labels: Supplier and Values: Sum of Amount.* *3. Then I want to extract the details of each supplier in different tab so as to create an invoice for the individual supplier showing them the transactions during the amount. The extracted data should automatically extract data from pivot for as many supplier available. In the attached file as instance there are 4 suppliers namely A,B,C,D.* *4. The extracted data should automatically rename the worksheet tab containing the name of supplier.* * * *Looking forward for your prompt response.* * * *Regards,* *Kaushik Savla* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, *MaNgEsH* -- With regards, *MaNgEsH* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you
Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD
Simply Awesome !!! On Sat, Aug 25, 2012 at 1:51 PM, amar takale amartak...@gmail.com wrote: Hi Hilary I used Excel 2003 So I tell you it is possible to see excel 2003. No problem I will see it 2007. Thanks On Sat, Aug 25, 2012 at 1:40 PM, resp...@gmail.com wrote: ** Hi Amar I built the dashboard in 2007 and 2010 environment. Am not sure why you can't view in 2003. Maybe Most of the functions I used are not in 2003 so Ʊ may probably get an error. Ʊ can upgrade your 2003 to 2007 or 10. 2010 also has 2003 environment so if Ʊ prefer that you can stick to that envt and work. With 2007 you can apply an addin function to get 2003 envt. Thanks Sent from my BlackBerry® smartphone from Airtel Ghana -- *From: * amar takale amartak...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Sat, 25 Aug 2012 10:43:25 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *Re: $$Excel-Macros$$ UPGRADE-STOCK MARKET INFORMATION DASHBOARD Hi Hilary I used Excel 2003 Then how to see it On Fri, Aug 24, 2012 at 8:08 PM, Hilary Lomotey resp...@gmail.comwrote: Hi Guys, i just completed an upgrade of my stock market dashboard, pls use as you will. cheers -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,
Re: $$Excel-Macros$$ You are gonna like it !!
Hi Rajan, Can you provide me link for the book EXCEL Charts.and.Graphs Please. Thanks. On Fri, Aug 24, 2012 at 11:28 PM, shashank bhosle catchshashankbho...@yahoo.co.in wrote: Mind Freaking Rajan !!! Awesome!!! *From:* Rajan_Verma rajanverma1...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Friday, 24 August 2012 6:53 PM *Subject:* $$Excel-Macros$$ You are gonna like it !! * * *Was just making fun with Bubble Chart **J*** * * *Comments are welcome * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ You are gonna like it !!
Mind blowing Rajan !!! On Fri, Aug 24, 2012 at 7:40 PM, Hilary Lomotey resp...@gmail.com wrote: I dont get it, can u xplain more, did u name the macro KK, i tried it nothing happened, however if i click outside the range its goes round. can u xplain how it works?. thansk On Fri, Aug 24, 2012 at 1:47 PM, Rajan_Verma rajanverma1...@gmail.comwrote: *Very nice,* * But don’t forget to handle event on Activate and deactivate sheet, Start Macro on Sheet Activate and Stop that on Sheet Deactivate.* * * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* * * *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Hilary Lomotey *Sent:* 24 August 2012 7:14 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ You are gonna like it !! ** ** i just added it to the front page of one of my dashboards, its looking great. thanks Raj On Fri, Aug 24, 2012 at 1:23 PM, Rajan_Verma rajanverma1...@gmail.com wrote: * * *Was just making fun with Bubble Chart **J* * * *Comments are welcome * * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. ** ** -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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
$$Excel-Macros$$ Need your help
Hi Friends, Please help me on issue below. *Issue :-* I need such excel file which can automatically stored login time with date and logout time so that I could able to analysis for how much time my computer was switched on/in use. For example, If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date * 13/8/2012*. Then it should feed all these data in an excel sheet like as - [image: Inline image 1] We can take help of VBA also. I hope I am able to tell you my need. If not please let me know. Thanks in advance. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. image.png
Re: $$Excel-Macros$$ Need your help
Hi Paul/Friends, I would like to use this concept for my personal computer. I knew very well that It is going to be tough job but as many experts are part of this group, I hope someone would definitely try to get answer. Let me know if you need more information on same. Please find the attached sheet that can be use as start up sheet to solve the problem. On Mon, Aug 13, 2012 at 7:41 PM, Paul Schreiner schreiner_p...@att.netwrote: I've worked through quite a bit of this. Spent MANY hours trying to work it out. There's LOTS of things to consider. #1.. is this for personal use, or for many people in an office? 1a) If it is an office, is there an I.T. department that controls PC and Windows configuration? Windows has a Group Policy that allows you to create login/logouts scripts for Windows. Since my work environment has an I.T. Department that controlls our system configurations, I could not utilize this method. (They locked out the Group Policy Editor) Instead, I created a login and logout VB script that writes to a text file. It looks for today's date. If found, it compares the current time to the time record. If for some reason, the current time is EARLIER than the login time recorded, it overwrites it. (this should only happen if someone manually modified the file) This vbscript is placed in the Startup folder and runs when windows Starts. logOUT is a bit of a problem. I created a vbscript to use to log out. It records the time, then exits windows. However, the user MUST use this script to log out. If windows is exited normally, (or abnormally for that matter)... basically.. if any other method is used to log out, the time is not recorded. For Personal use, I am very disciplined about using this. But for widespread use? I wouldn't trust it. Another security issue is that the file it updates is a simple text file. Therefore, a user COULD modify the values... (i.e.: I was 10 minutes late getting to my desk because my boss was talking to me at the coffee machine on the way in. So, I wanted to back out the time so it wouldn't show up as late...) I've CONSIDERED trying to open the file as Binary. I've done this from Excel before, but not from VBScript. My excel file then updates from this log file when opened. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* David Grugeon da...@grugeon.com.au *To:* excel-macros@googlegroups.com *Sent:* Mon, August 13, 2012 9:25:56 AM *Subject:* Re: $$Excel-Macros$$ Need your help Magnesh and Paul I think you could put an excel file (or a shortcut to one), in the startup folder. have an on open macro in the sheet to record the opening time. Then have a before close macro to record the time and save itself. My only concern would be whether Windows kills excel before the saving process is complete. Otherwise it should work, provided you don't mind having the file, and excel, open all day. On 13 August 2012 22:55, Paul Schreiner schreiner_p...@att.net wrote: This is going to be a tough one. It involves access to the Windows environment. I REALLY hope someone has an alternative, but I think you're going to have to write some VBscript files that run at Windows Login and Logout that will make entries to a log file. *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Mangesh Vimay mangesh.da...@gmail.com *To:* excel-macros@googlegroups.com; NOORAIN ANSARI noorain.ans...@gmail.com; rajan verma rajanverma1...@gmail.com *Sent:* Mon, August 13, 2012 8:48:16 AM *Subject:* $$Excel-Macros$$ Need your help Hi Friends, Please help me on issue below. *Issue :-* I need such excel file which can automatically stored login time with date and logout time so that I could able to analysis for how much time my computer was switched on/in use. For example, If I login by the time *7:00:00 AM* and logout on *12:30:00 PM* on Date * 13/8/2012*. Then it should feed all these data in an excel sheet like as - [image: Inline image 1] We can take help of VBA also. I hope I am able to tell you my need. If not please let me know. Thanks in advance. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula
Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format
So Awesome Noorain Bhai !!! On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, Please find attached updated attendance tracker. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar kumar.ashish...@gmail.comwrote: Dear Noorain, This Attendance Tracker is very useful but whenever I'hve click on Attendance Calculator Button and fill the Emp Id. field, the status was not generated automatically. kindly explain it. thanks for sharing it. Thanks Ashish On 30 July 2012 20:38, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Hemant, Please find attached Attendance Tracker, Hope it will help to you. On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar hema5s...@gmail.com wrote: Dear Ashish, How will I mark leave, I have Sick Leave, Un Planned Leave , Planned Leave , Vacation? On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 kumar.ashish...@gmail.com wrote: Dear Hemanath.D Pls find the attached Excel Sheet. Thanks Ashish kumar On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar wrote: Friends, Can any one help me in providing Employee Attendance tracker format with Employee utilization in Excel? -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks HemanatH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.com excelvbaclinic.blogspot.com http://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Thanks Regards* *Ashish Kumar* *9990624516* * * -- 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.
Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format
Dear Noorain, The attendance tracker is locked. If it is possible, can u provide password so that I can learn how to develop such forms. Thanks. On Thu, Aug 9, 2012 at 7:55 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Thanks bro On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: So Awesome Noorain Bhai !!! On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Ashish, Please find attached updated attendance tracker. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar kumar.ashish...@gmail.comwrote: Dear Noorain, This Attendance Tracker is very useful but whenever I'hve click on Attendance Calculator Button and fill the Emp Id. field, the status was not generated automatically. kindly explain it. thanks for sharing it. Thanks Ashish On 30 July 2012 20:38, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Hemant, Please find attached Attendance Tracker, Hope it will help to you. On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar hema5s...@gmail.com wrote: Dear Ashish, How will I mark leave, I have Sick Leave, Un Planned Leave , Planned Leave , Vacation? On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 kumar.ashish...@gmail.com wrote: Dear Hemanath.D Pls find the attached Excel Sheet. Thanks Ashish kumar On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar wrote: Friends, Can any one help me in providing Employee Attendance tracker format with Employee utilization in Excel? -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks HemanatH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.com excelvbaclinic.blogspot.com http://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: Employee Attendance Tracker with Utilization - Format
THank you so much Noorain. Gn On Thu, Aug 9, 2012 at 9:14 PM, Ashish kumar kumar.ashish...@gmail.comwrote: Dear Noorain, Thanks for share this traker. really this traker is very useful. Thanks Ashish On 9 August 2012 08:24, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, see attached workbook without protection. On Thu, Aug 9, 2012 at 8:28 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Dear Noorain, The attendance tracker is locked. If it is possible, can u provide password so that I can learn how to develop such forms. Thanks. On Thu, Aug 9, 2012 at 7:55 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Thanks bro On Thu, Aug 9, 2012 at 7:40 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: So Awesome Noorain Bhai !!! On Thu, Aug 9, 2012 at 5:25 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Ashish, Please find attached updated attendance tracker. -- With Regards, Noorain Ansari http:// http://www.noorainansari.com/noorainansari.comhttp://www.noorainansari.com/ http:// http://www.excelvbaclinic.blogspot.com/excelvbaclinic.comhttp://www.excelvbaclinic.blogspot.com/http://accesssqclinic.blogspot.in/ On Wed, Aug 1, 2012 at 6:04 PM, Ashish kumar kumar.ashish...@gmail.com wrote: Dear Noorain, This Attendance Tracker is very useful but whenever I'hve click on Attendance Calculator Button and fill the Emp Id. field, the status was not generated automatically. kindly explain it. thanks for sharing it. Thanks Ashish On 30 July 2012 20:38, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Hemant, Please find attached Attendance Tracker, Hope it will help to you. On Tue, Jul 31, 2012 at 12:10 AM, hemanath dhanasekar hema5s...@gmail.com wrote: Dear Ashish, How will I mark leave, I have Sick Leave, Un Planned Leave , Planned Leave , Vacation? On Mon, Jul 30, 2012 at 11:26 PM, kumar.ashish861 kumar.ashish...@gmail.com wrote: Dear Hemanath.D Pls find the attached Excel Sheet. Thanks Ashish kumar On Monday, July 30, 2012 10:24:15 AM UTC-7, hemanath dhanasekar wrote: Friends, Can any one help me in providing Employee Attendance tracker format with Employee utilization in Excel? -- Thanks Hemanath.D -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks HemanatH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.com excelvbaclinic.blogspot.comhttp://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ -- 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
$$Excel-Macros$$ Need Help - To create the folder by the names which mentioned in the excel sheet.
Hi Friends. Please tell me how to create the folder by the names which I have entered in the sheet. For more information, please refer the attached sheet. Please provide me solution. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. How to create folder.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Help - To create the folder by the names which mentioned in the excel sheet.
THank you so much Paul. On Tue, Aug 7, 2012 at 4:41 PM, Paul Schreiner schreiner_p...@att.netwrote: try this macro: Sub Make_FolderList() Dim R, nRows, BaseFldr, fso Set fso = CreateObject(Scripting.FileSystemObject) BaseFldr = C:\ nRows = Application.WorksheetFunction.CountA(Range(A1:A65000)) For R = 2 To nRows If (Not fso.folderexists(BaseFldr Cells(R, A).Value)) Then MkDir (BaseFldr Cells(R, A).Value) End If Next R End Sub *Paul* - *“Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley *- -- *From:* Mangesh Vimay mangesh.da...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, August 7, 2012 5:56:50 AM *Subject:* $$Excel-Macros$$ Need Help - To create the folder by the names which mentioned in the excel sheet. Hi Friends. Please tell me how to create the folder by the names which I have entered in the sheet. For more information, please refer the attached sheet. Please provide me solution. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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. -- With regards, MaNgEsH -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120+ 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. 6) Jobs posting is not allowed. 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed. NOTE : Don't ever post personal or 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.
Re: $$Excel-Macros$$ Need Help !!!!
Hi All, Thanks for providing me valuable solution and also I am thankful for providing me guidelines of the forum. I am sorry I have not mentioned the exact subject line in the header which I had mentioned in the sheet itself. Sorry again and Thanks a ton !!! On Tue, Jul 31, 2012 at 8:58 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, You can also use... =INDEX($C$2:$E$10,MATCH(1,(($A$2:$A$10=$G$13)*($B$2:$B$10=$G14)),0),MATCH(H$13,$C$1:$E$1,0)) with CSE See attached sheet. -- With Regards, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.com excelvbaclinic.blogspot.com http://www.excelvbaclinic.blogspot.com http://accesssqclinic.blogspot.in/ On Tue, Jul 31, 2012 at 1:21 AM, Sam Mathai Chacko samde...@gmail.comwrote: I also second both gentlemen's points. For the solution, use =SUMPRODUCT(($A$2:$A$10=$G$13)*($B$2:$B$10=$G14)*(C$2:C$10)) dragged down and across Regards, Sam Mathai Chacko On Tue, Jul 31, 2012 at 12:10 AM, dguillett1 dguille...@gmail.comwrote: I did not look at your file because you subject line did not have a meaningful question and you did not ask your question in the body of the email. It is good that you did provide a file. Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Mangesh Vimay mangesh.da...@gmail.com *Sent:* Monday, July 30, 2012 12:40 PM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Need Help Hi Friends, Please help me on the sheet provided as an attachment. Waiting for your reply !!! Thanks ! -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
$$Excel-Macros$$ Need Help !!!!
Hi Friends, Please help me on the sheet provided as an attachment. Waiting for your reply !!! Thanks ! -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Data_Query.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL
Hi Friends, Please help me on HOW TO CREATE REPORTS IN EXCEL by providing suitable examples so that I could learn it. Thanks. -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL
Hi Roshan, You are right !!! I have to provide some data to u in order to get the report. But I need some sample reports based on any data so that by practicing them, I could learn some thing like creating the reports and manipulating reports. Also, tell me what types of reports we can develop in Excel? As I am new to this world, Please help on above queries. On Thu, Jul 19, 2012 at 3:54 PM, Roshan Mathew ros...@gmail.com wrote: Hi Mangesh, Can you list out the below: To create any report your should be having some data, can you share the data? What type of reports are looking for? On Thu, Jul 19, 2012 at 1:55 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please help me on HOW TO CREATE REPORTS IN EXCEL by providing suitable examples so that I could learn it. Thanks. -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Regards, Roshan Mathew -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ HOW TO CREATE REPORTS IN EXCEL
Hi Noorain, Thanks. Can u provide me examples for all below 3 types based on any same sample data. So that I could learn it. On Thu, Jul 19, 2012 at 5:55 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, To Create report in MS Excel you can use. 1. Pivot table 2. Subtotal 3. Consolidate On Thu, Jul 19, 2012 at 3:25 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please help me on HOW TO CREATE REPORTS IN EXCEL by providing suitable examples so that I could learn it. Thanks. -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelvbaclinic.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
Thank you much for kind support. !!! On Tue, Jul 17, 2012 at 11:17 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, See attached Screen shot. On Mon, Jul 16, 2012 at 9:54 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain, If I have to delete some fields as below then How could I do this? Like Salary in Dollar, Field1, Avg Sal in $ Please help. [image: Inline image 1] On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks a ton !!! On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manesh, As desired, Please find step by step screen shot with complete explanation as attachment. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Noorain. Thanks but I do not understand how did you calculated the Average Salary ($) by using *calculated field*. Please provide me documentation so that I could understand. I know it is time consuming job for you and really sorry for that. But I dont have alternative. So please help me dear. Sorry to trouble u again and again. On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please find attached sheet.. little correction of Anil's Formula in green part =GETPIVOTDATA(Average of Salary [INR],$E$1,Dept,*$E3*)/55 Calculated Field solution is also attached here with screen shot. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.com wrote: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr
Re: $$Excel-Macros$$ Vlookup Problem
Thank you so much for providing such a nice solution. Thanks again ALL. On Tue, Jul 17, 2012 at 12:07 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote: Do as you like. 2012/7/17 Venkatesh Narla nvenki...@gmail.com Hi, Please find the attachment and let me know.. any thing els need.. Thanks, Venkatesh. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Please help me.
Thanks Deba. Its very nice even before using it I never know that Excel could do all these stuff so nicely. Thanks again Dear. On Tue, Jul 17, 2012 at 9:44 AM, Deba Ranjan drdeva...@gmail.com wrote: Dear Mangesh, To create this calendar in the range B2:H9, follow these steps: 1. Select B2:H2 and merge the cells by choosing Home ➪ Alignment ➪ Merge Center. 2. Enter a date into the merged range. The day of the month isn’t important. 3. Enter the abbreviated day names in the range B3:H3. Performing Magic with Array Formulas 4. Select B4:H9 and enter this array formula. Remember: To enter an array formula, press Ctrl+Shift+Enter (not just Enter). {=IF(MONTH(DATE(YEAR(B2),MONTH(B2),1))MONTH(DATE(YEAR(B2), MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONTH(B2),1))-1)+ {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1),””, DATE(YEAR(B2),MONTH(B2),1)-(WEEKDAY(DATE(YEAR(B2),MONT H(B2),1))-1)+ {0;1;2;3;4;5}*7+{1,2,3,4,5,6,7}-1)} 5. Format the range B4:H9 to use this custom number format: d. This step formats the dates to show only the day. Use the Custom category in the Number tab of the Format Cells dialog box to specify this custom number format. 6. Adjust the column widths and format the cells as you like. 7. Change the month and year in cell B2. The calendar updates automatically. After creating this calendar, you can copy the range to any other worksheet or workbook. Thanks Regards, *Deba Ranjan P* On Mon, Jul 16, 2012 at 4:56 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manoj, Please find attached simple Calender. You can create it simply. On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar kumarmanoj.11...@gmail.com wrote: Dear Expert, I want to make Calender on excel when i enter year month in a coll it show me date wise calender... Regard Manoj -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr
$$Excel-Macros$$ Vlookup Problem
Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com VLookUp Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Please solve my Pivot Table Problem
Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Pivot_Table Problem.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup Problem
Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote: Dear Mangesh, Please find the attached file as I have learnt this one form Noorain sir in this group. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Suman Kumar* *Mob: +91-9810333884* *RIM-+91-9555629292* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.comA_html_m691da4f3.gif
Re: $$Excel-Macros$$ Vlookup Problem
so much On Mon, Jul 16, 2012 at 4:51 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thank you much Suman On Mon, Jul 16, 2012 at 4:48 PM, Suman ksuman1...@gmail.com wrote: Dear Mangesh, Please find the attached file as I have learnt this one form Noorain sir in this group. On Mon, Jul 16, 2012 at 4:33 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please solve my VLookup Query. Description is given in attached file. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Suman Kumar* *Mob: +91-9810333884* *RIM-+91-9555629292* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.comA_html_m691da4f3.gif
Re: $$Excel-Macros$$ Please help me.
Please tell us so that we can edit and learn it. How to make ? calender_Simple.xls file On Fri, Jul 13, 2012 at 11:05 AM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Manoj, Please find attached simple Calender. You can create it simply. On Fri, Jul 13, 2012 at 10:04 AM, Manoj Kumar kumarmanoj.11...@gmail.comwrote: Dear Expert, I want to make Calender on excel when i enter year month in a coll it show me date wise calender... Regard Manoj -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
Hi Anil, Thanks lot. But I need to calculate the average($) by using Calculated Field option given in Options --- Formulas --- calculated field. Is it possible by using above method. Please let me know. Thanks again. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.com wrote: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Please solve my Pivot Table Problem
Please help me on below problem. Thanks On Mon, Jul 16, 2012 at 6:29 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain, If I have to delete some fields as below then How could I do this? Like Salary in Dollar, Field1, Avg Sal in $ Please help. [image: Inline image 1] On Mon, Jul 16, 2012 at 6:24 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Thanks a ton !!! On Mon, Jul 16, 2012 at 6:21 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Manesh, As desired, Please find step by step screen shot with complete explanation as attachment. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 16, 2012 at 5:37 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Noorain. Thanks but I do not understand how did you calculated the Average Salary ($) by using *calculated field*. Please provide me documentation so that I could understand. I know it is time consuming job for you and really sorry for that. But I dont have alternative. So please help me dear. Sorry to trouble u again and again. On Mon, Jul 16, 2012 at 5:30 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please find attached sheet.. little correction of Anil's Formula in green part =GETPIVOTDATA(Average of Salary [INR],$E$1,Dept,*$E3*)/55 Calculated Field solution is also attached here with screen shot. On Mon, Jul 16, 2012 at 5:15 PM, Anil Gawli gawlianil8...@gmail.comwrote: Pls find Attached sheet ...Like this u want? Regards, Gawli Anil On Mon, Jul 16, 2012 at 4:39 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need your help to solve my PT Problem. The description is given in sheet itself. Please FA. Thanks. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks Regards, Gawli Anil Narayan Software Developer, Abacus Software Services Pvt Ltd -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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
Re: $$Excel-Macros$$ Numbers into Words
Please send new sheet as previous sheet is protected or provide the password. On Wed, Jul 11, 2012 at 4:36 PM, Abdulgani Shaikh itpabdulg...@gmail.comwrote: Row no.28 Number marked in Yellow Row no.32 Words marked in Red On Wed, Jul 11, 2012 at 2:41 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Abdul, In attached sheet, I am unable to found yellow color, Please resend. On Wed, Jul 11, 2012 at 2:36 PM, Abdulgani Shaikh itpabdulg...@gmail.com wrote: I want numbers marked in Yellow colour to be written in numbers as given in attached filed at Red Colour Coloumn . By using formula or By using macro whichever is easy. 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need Urgent Help on If statement
Hi Friends, Please find the attached sheet for if statement. Please help me dear all !!! -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Help for IF.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need Urgent Help on If statement
Thank you so much mere bhai u saved my job On 7/4/12, ashish koul koul.ash...@gmail.com wrote: = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours)) On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please find the attached sheet for if statement. Please help me dear all !!! -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need Urgent Help on If statement
Hi Friends/Ashish, How will you put this formula in vba code. please tell. On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Thank you so much mere bhai u saved my job On 7/4/12, ashish koul koul.ash...@gmail.com wrote: = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours)) On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please find the attached sheet for if statement. Please help me dear all !!! -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need Urgent Help on If statement
Thanks Noorain Where should I put this code. I mean in module or any the place to run the code. Please tell me detail as u know very well I am new to VBA. On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please use it *Function Test(rng As Excel.Range) If rng.Value And rng.Value = 24 Then Test = 24 Hours ElseIf rng.Value And rng.Value 24 Then Test = 24 Hours Else Test = End If End Function * On Wed, Jul 4, 2012 at 7:52 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends/Ashish, How will you put this formula in vba code. please tell. On 7/4/12, Mangesh Vimay mangesh.da...@gmail.com wrote: Thank you so much mere bhai u saved my job On 7/4/12, ashish koul koul.ash...@gmail.com wrote: = iF(ISBLANK(A2),,IF(A2=24,24 Hours,24 Hours)) On Wed, Jul 4, 2012 at 7:35 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, Please find the attached sheet for if statement. Please help me dear all !!! -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards* * * *Ashish Koul* *http://www.excelvbamacros.com/* *http://www.accessvbamacros.com/* http://www.accessvbamacros.com/ P Before printing, think about the environment. -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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
$$Excel-Macros$$ PLease Help
I need diff in between these two dates in Hours Start Date End Date 4/1/2012 5:01 4/3/2012 6:15 Whatever the diff in between these two dats in terms of hours (hh:mm) Please help -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ PLease Help
Thanks Noorain On 7/4/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mangesh, Please use it.. =TEXT(B2-A2,[H]:mm:ss) On Wed, Jul 4, 2012 at 10:46 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: I need diff in between these two dates in Hours Start Date End Date 4/1/2012 5:01 4/3/2012 6:15 Whatever the diff in between these two dats in terms of hours (hh:mm) Please help -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: regarding problem on vlookup function
If Sachin Tendulkar is God of Cricket then Definitely Noorain Ansari is God of Excel. On 7/2/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Most Welcome bro.. I am not god, i m a simple Excel Lover like you. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Mon, Jul 2, 2012 at 4:47 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: You are God Noorain ansari, The reply is lighting fast. Thank you Sanjib On Mon, Jul 2, 2012 at 4:44 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Sanjib, Please absolute the range =VLOOKUP(E2,$A$1:$B$6,2,FALSE) On Mon, Jul 2, 2012 at 4:41 PM, Sanjib Chatterjee chatterjee.kolk...@gmail.com wrote: Dear Sir / Madam, Whenever I need solution the people in the group always help me. Now I am facing another problem. Please see the attachment. I am facing the problem which is mention in the yellow color. I want In the slno I put the number the description column should generate automatically. fist four line is fine working. But I am facing the problem from the next. Thanking you Regards, Sanjib -- - -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Excel VBA Training By Subject matter Experts
Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. Rule # 05 On 7/2/12, harshita desu harshita4d...@gmail.com wrote: Medha Information research Offering In House, Online and Corporate training on Excel VBA Course Highlights Fully handson Sessions. Realtime examples Interview/project support Indepth and exclusive coverage on each topic For More details, Contact us at +91 9945207350 or write us at i...@medhainfo.com Website: WWW.MEDHAINFO.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet
Hi Friends, Thanks All for your valuable solution. But, I need excel sheet when we click on its header so that I could able to modify data. Please Help !!! On 6/28/12, Rajan_Verma rajanverma1...@gmail.com wrote: Use this One .. Problem is not identified but when I click on Twice on Design button it works , may be it is a bug.. L , will get back to you on this. Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Lalit Mohan Sent: 28 June 2012 8:04 To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet Hi Rajan, It Looks great but scroll bar is not working in the list box. Regards, Lalit Mohan www.excelfox.com/forum From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Rajan_Verma Sent: Thursday, June 28, 2012 8:01 PM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet Hi You Can Refer attached sheet., Event will fire on Double Click , When you will double click you will get the desired result Description: cid:image003.png@01CD5568.CA9AE140 Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ahmed Honest Sent: 27 June 2012 11:46 To: excel-macros@googlegroups.com; mangesh.da...@gmail.com Subject: Re: $$Excel-Macros$$ Need Help !!! How to add sheet under another sheet Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Hi Rajan, Try to read of what I have mentioned above and review accordingly and comment of what you think about this ?? :-) Thanks, Ahmed Bawazir On Wed, Jun 27, 2012 at 6:03 PM, Mangesh Vimay mangesh.da...@gmail.com wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com mailto:excel-macros%2bunsubscr...@googlegroups.com -- Ahmed Bawazir احمد باوزير -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Re: Need Help !!! How to add sheet under another sheet
Hi Ahmed, Thanks but it is not solution to my problem. On 6/28/12, Ahmed Honest ahmedhon...@gmail.com wrote: Hi Mangesh, Try using from Insert Menu -- Object -- choose Create from file and locate your sheet path that is available in your respective file then an Icon is displayed so being in a sheet when you click on that Icon you will get another sheet. Revert if you failed to understand the above. I think this option should meet your requirement 100%. Thanks, Ahmed Bawazir On Thu, Jun 28, 2012 at 7:46 AM, Lalit_Mohan mohan.pande...@gmail.comwrote: Hi, This kind of functionality is available in excel i don't know but we can achieve this not exactle but will look like this by using paste data as picture link. I don't know how much it will helful to you. Regards, Lalit Mohan On Wednesday, 27 June 2012 20:33:43 UTC+5:30, Mangesh wrote: Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Ahmed Bawazir *احمد باوزير* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need Help !!! How to add sheet under another sheet
Hi Friends, I need sheet under another sheet. I have provided explanation in attached sheet. Please help. -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Sheet under another sheet.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Types of data analysis used in the company
Hi Friends, Please tell me the types of data analysis which are used in the company to perform data operations. Please provide the information. Thanks !!! -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ What is pivot table, i could not do this.... Can any body help?
Hi All, I even can't imagine my entire life without this Group.. Agar mai successful raha to The contribution of this excel group would be 99.99% to my success. 0.01% I would like to keep for myself. Thanks 2 All !!! On 6/24/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Ashutosh, Please find attached Pivot Table sample workbook. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Sun, Jun 24, 2012 at 1:51 PM, Ashutosh Sharma ashulov...@gmail.comwrote: I started using Hlookup, Vlookup but what is pivot table and uses, if any body can tell.. Regards, Ashutosh -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Formula for Username in a cell
So Nice and also I never seen such a nice tutorial on Excel, Good user friendly, easy and simply superb Thanks dear. On Thu, Jun 21, 2012 at 8:27 PM, Krishnaraddi excelkris...@in.com wrote: Hi All, Please find the attached PPT consists of few useful excel functions explained. I have prepared this document for training purpose thought to share with this group. 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Excel Q A
Thanks lot !!! On Wed, Jun 20, 2012 at 6:50 PM, Krishnaraddi excelkris...@in.com wrote: Hi Experts, I have collected few questions regarding excel and updated in single document. I have also attached answers in separate excel sheet. I hope this will help few who are learning Excel. Dear *excel-macros !* Get Yourself a cool, short *@in.com* Email ID now!http://www3.in.com/sso/commonregister.php?ref=INutm_source=inviteutm_medium=outgoing -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates
Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.com wrote: Hello Pankaj, As far as i know chandoo has greate dashboard templates for free , Attached you can find out a few chandoo dashboards , maybe they skipped your eyes. On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote: Dear All, Please share Dashboard Examples/Templates I already viewed Chandoo's Site so no reference to that site. -- Pankaj Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: share Dashboard Examples/Templates
Thanks Noorain for sharing such nice examples..!!! On Tue, Jun 19, 2012 at 6:51 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: PFA On Tue, Jun 19, 2012 at 6:49 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Many many thanks for this On Tue, Jun 19, 2012 at 6:39 PM, CoRe neculae.vale...@gmail.com wrote: Hello Pankaj, As far as i know chandoo has greate dashboard templates for free , Attached you can find out a few chandoo dashboards , maybe they skipped your eyes. On Monday, June 18, 2012 8:31:48 PM UTC+3, panky wrote: Dear All, Please share Dashboard Examples/Templates I already viewed Chandoo's Site so no reference to that site. -- Pankaj Kumar -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
$$Excel-Macros$$ Need your help !!!
Hi Friends, In above example, if we input the name like ABC then it should display it's apropriate values in the table from the above list. Please find the attached sheet. How can we find the solution by using Vlookup() function? . Thanks -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Example_Name.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Need your help !!!
Thanks Noorain Bhai, On Tue, Jun 19, 2012 at 9:08 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: see attached sheet On Tue, Jun 19, 2012 at 9:06 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mangesh, Please try it.. =VLOOKUP($H9,IF($A$2:$A$10=$H$7,$B$2:$E$10,0),MATCH(I$8,$B$1:$E$1,0),0) with ctrl+Shift+enter -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Tue, Jun 19, 2012 at 8:59 PM, Mangesh Vimay mangesh.da...@gmail.comwrote: Hi Friends, In above example, if we input the name like ABC then it should display it's apropriate values in the table from the above list. Please find the attached sheet. How can we find the solution by using Vlookup() function? . Thanks -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Re: MIS executive
Hi Friends, I am agree with Yogananda because many people are spending their time here to learn excel concepts with the intention to get the job and hence if someone is providing such nice opportunities then I think it is good. Moreover, only related job posting should be there (with excel, access only). Thanks. On Sun, Jun 17, 2012 at 8:04 AM, Prince Ever Increasing Abundance King of Exceeding Overflowing Prosperity goldasd...@hotmail.com wrote: I have no intent of doing a job posting. Asking for others. Where should job postings be done. I am in British Colulmbia Canada. What should I do if I want to change to change my email receiving address for this group? Thank you. David -- Date: Sat, 16 Jun 2012 08:14:00 -0700 From: jainayus...@gmail.com To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: MIS executive Hi Yogananda, Please note that Job posting is allowed in this forum. Please do not post any jobs going forward. Thanks. On Saturday, 16 June 2012 16:41:50 UTC+5:30, (%Allmydreams%) wrote: Hi, We have a opening for MIS - Executive in Bangalore location. Do call my below number on next coming monday. Its Urgent requirement Regards Yogananda Muthaiah Ph : 973 123 7267 -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- With regards, MaNgEsH -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ Sheet Requirements
Hi Dear, It happens with everybody specially when someone tries to learn new concepts of IT or any other topic. So keep going and this group is good to help you. MangeSH On Tue, Jun 12, 2012 at 6:45 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks. i love excel very much, Actually i keep on trying the coding But really i am so sorry that i really don't have this Idea. i purchased books for VBA macros and Excel, and i am trying my best to do so. Actually i am very new to this concepts (Means VBA coding). And even i am trying to learn from this group as well. I adopted to learn one by one. Let me tell you honestly, i have no system at my home. And what ever i learn, i learnt at Office but that too also i have many few times to learnt myself. So its my drawback. i hope i would able very few things a day, Any way thanks for suggesting that. i will keep trying. i have very confusion in coding when i go trough the books. Like String, long etc. Thanks Regards, *Deba Ranjan P* On Tue, Jun 12, 2012 at 6:34 PM, dguillett1 dguille...@gmail.com wrote: Forgive me but as I recall you have been a part of this group for awhile. If so, you should have learned enough to do this yourself. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Deba Ranjan drdeva...@gmail.com *Sent:* Tuesday, June 12, 2012 6:45 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Sheet Requirements Dear Experts, i have attached a file which contains many sheets. in every sheets there contains data. i want a button which on clicking the whole sheet data consolidated. Please find the attached. thanks... Thanks Regards, *Deba Ranjan P* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ I want to learn macro from basic level
It's really good to learn VBA Fundamentals. Thanks Rajan. mANgeSH. On Tue, Jun 12, 2012 at 7:23 PM, Rajan_Verma rajanverma1...@gmail.comwrote: Hi Guys ** ** Download from this Link for excel 2007 ** ** http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf ** ** ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* 12 June 2012 7:04 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ I want to learn macro from basic level ** ** Hi Rajan, Plz send me on my email id rakeshks@gmail.com if possible On Tue, Jun 12, 2012 at 6:15 PM, Rajan_Verma rajanverma1...@gmail.com wrote: Excel Power programming with VBA J Either you can download from internet its free or I will send you on your email id .. Really nice book to start from scratch. * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* 12 June 2012 3:00 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ I want to learn macro from basic level Hi Masters, If you have any attachment which can help me to learn excel macro from starting point, plz share. -- *Regards, **Rakesh Kumar Sharma** **Contact: +91-9971024741* -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- *Regards, **Rakesh Kumar Sharma** **Contact: +91-9971024741** * -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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,
Re: $$Excel-Macros$$ I want to learn macro from basic level
Hi Gulzar, As Rajan has mentioned in trail mail, download the desired e-book from the link http://www.comp.nus.edu.sg/~justin88/Excel%202007%20Power%20Programming%20With%20VBA.pdf On Tue, Jun 12, 2012 at 9:50 PM, Gulzar Naqvi sgna...@hotmail.com wrote: Hi Mr. Rajan, Please also send Excel Power programming with VBA on my email I'd on sgna...@hotmail.com. Regards, GHNaqvi -- Subject: Re: $$Excel-Macros$$ I want to learn macro from basic level To: excel-macros@googlegroups.com From: amar.gur...@gmail.com Date: Tue, 12 Jun 2012 12:47:10 + Hi Rajan, Please send the same on my email I'd on amar.mas...@gmail.com Regards, Amar Sent on my BlackBerry® from Vodafone -- *From: * Rajan_Verma rajanverma1...@gmail.com *Sender: * excel-macros@googlegroups.com *Date: *Tue, 12 Jun 2012 18:15:14 +0530 *To: *excel-macros@googlegroups.com *ReplyTo: * excel-macros@googlegroups.com *Subject: *RE: $$Excel-Macros$$ I want to learn macro from basic level Excel Power programming with VBA J Either you can download from internet its free or I will send you on your email id .. Really nice book to start from scratch. * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Rakesh Kumar Sharma *Sent:* 12 June 2012 3:00 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ I want to learn macro from basic level Hi Masters, If you have any attachment which can help me to learn excel macro from starting point, plz share. -- *Regards, **Rakesh Kumar Sharma** **Contact: +91-9971024741** * -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ Clock Chart (Excellent)
Simply AwesomeUltimate Use of Excel Features !!! MAnGesh On Fri, Jun 8, 2012 at 6:36 PM, Deba Ranjan drdeva...@gmail.com wrote: Thanks Bhai. Thanks Regards, *Deba Ranjan P* On Fri, Jun 8, 2012 at 6:32 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: See attachment On Fri, Jun 8, 2012 at 6:30 PM, Deba Ranjan debaranjanp...@gmail.comwrote: i am sorry sir, i can't get you please. On Fri, Jun 8, 2012 at 6:29 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Deba, Please check here.. On Fri, Jun 8, 2012 at 4:25 PM, Deba Ranjan drdeva...@gmail.comwrote: Its a awesome design. Can you please tell me , in the sheet, we are unable to view the sheets, i mean, Even we insert sheet, we are unable to see the sheet. Please explain me on this. Its make me very interesting parts. !! Thanks Regards, *Deba Ranjan P* On Thu, Jun 7, 2012 at 6:05 PM, hilary lomotey resp...@gmail.comwrote: i like this, thanks On Thu, Jun 7, 2012 at 11:52 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Thanks Nikhil. On Thu, Jun 7, 2012 at 7:53 AM, Nikhil Shah nikhil201...@gmail.comwrote: Hi Noorain , Thanks for sending excellent Chart File.. Nikhil On Thu, Jun 7, 2012 at 12:00 AM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Group, Please find attached Clock Chart. -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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
Re: $$Excel-Macros$$ How to add combo box in a sheet.....Need Help.....
Thanks All for their genuine help !!! Mangesh. On Fri, Jun 8, 2012 at 7:53 PM, dguillett1 dguille...@gmail.com wrote: Create combobox1 in sheet1 and then put this code in the SHEET module Private Sub Worksheet_Activate() Sheet1.ComboBox1.Clear Dim sh As Worksheet For Each sh In Worksheets Sheet1.ComboBox1.AddItem (sh.Name) Next End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Mangesh Dayne mangesh.da...@gmail.com *Sent:* Friday, June 08, 2012 6:17 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ How to add combo box in a sheet.Need Help. Hi Friends, I have to add combo box in a sheet that will contain all sheets name and when i select the any sheet name in combo box, it will activate in the workbook, means I can able to see the contents of sheet simply by selecting the sheet from combo box list. Moreover, combo box should automatically update the sheet name, means if i deleted any sheet from workbook the entry from the combo box should also be deleted. Thanks a lot. Please help Mangesh -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com
Re: $$Excel-Macros$$ RE: FW: hi there...
Yes, sure and please think on it how to protect this group from such spams. Mangesh On Fri, Jun 8, 2012 at 9:29 PM, Rajan_Verma rajanverma1...@gmail.comwrote: It’s a spam I think ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *NOORAIN ANSARI *Sent:* 08 June 2012 9:27 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ RE: FW: hi there... ** ** Please post ur query On Fri, Jun 8, 2012 at 9:18 PM, OfficeVba Trainer officevbatrai...@yahoo.com wrote: Thanks to Bed Defense! They saved my sister and I from our buildings bedbug infestation!! http://socjologia.c0.pl/lastnews/94RichardAlien/ -- 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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com -- Thanks regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@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 To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com