Re: $$Excel-Macros$$ Query: Charts
Dear Pankaj, Please try it.. *=OFFSET($B12,0,COUNTA($C$11:$P$11)-4,1,5)* see attached sheet for more clarity. -- 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 Wed, Feb 13, 2013 at 3:31 PM, pankaj sangotra psangotr...@gmail.comwrote: Hi Experts, I have mention the details in the tab itself, Please do the needful.. Thanks Pankaj Sangotra -- 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. -- 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. Query- Charts(Solved).xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Query
Dear Neeraj, You can use.. =EDATE(A2,6) or =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2)) On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan neerajchauhan...@gmail.comwrote: Dear Experts, kindly find the attached sheet i want the add the 6 or 7 months in particular date. -- 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, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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$$ Query
thanks sir, its working thanks again On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Neeraj, You can use.. =EDATE(A2,6) or =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2)) On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan neerajchauhan...@gmail.com wrote: Dear Experts, kindly find the attached sheet i want the add the 6 or 7 months in particular date. -- 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, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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. -- 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$$ Query
neeraj, very bad subject and query explaination On Fri, Feb 8, 2013 at 2:17 AM, neeraj chauhan neerajchauhan...@gmail.comwrote: thanks sir, its working thanks again On Fri, Feb 8, 2013 at 2:16 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Neeraj, You can use.. =EDATE(A2,6) or =DATE(YEAR(A2),MONTH(A2)+6,DAY(A2)) On Fri, Feb 8, 2013 at 1:35 PM, neeraj chauhan neerajchauhan...@gmail.com wrote: Dear Experts, kindly find the attached sheet i want the add the 6 or 7 months in particular date. -- 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, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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. -- 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 Rajan verma +91 9158998701 -- 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
Re: $$Excel-Macros$$ query for getting external data from a website
Thanks dhaval,but how do i use in my project file.can i import all this data in my same project sheet?and i want to import it automatically by changing date and nse symbol in my excel sheet itself.is that also can be done ?? --- On Mon, 12/31/12, Dhaval Shah todhavals...@gmail.com wrote: From: Dhaval Shah todhavals...@gmail.com Subject: Re: $$Excel-Macros$$ query for getting external data from a website To: excel-macros@googlegroups.com Cc: keni...@yahoo.com Date: Monday, December 31, 2012, 12:24 PM Kenil pls click the below mention link to download data of any eq series stocks www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012TCSEQN.csv www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCEEQN.csv just u have to change the script name ( NSE SYMBOL ) time period for difference stocks On Sun, Dec 30, 2012 at 4:46 PM, Kenil Gala keni...@yahoo.com wrote: Hi, I want data of last 3months of a particular stock from a website. i have link of that website but dont know how to import it.i just want if i change just symbol of that particular script i get the data of that particular script i want. pls find the file attached for details. Pls help Thanks. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ query for getting external data from a website
Kenil pls click the below mention link to download data of any eq series stocks www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012 *TCS*EQN.csv www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE **EQN.csv just u have to change the script name ( NSE SYMBOL ) time period for difference stocks On Sun, Dec 30, 2012 at 4:46 PM, Kenil Gala keni...@yahoo.com wrote: Hi, I want data of last 3months of a particular stock from a website. i have link of that website but dont know how to import it.i just want if i change just symbol of that particular script i get the data of that particular script i want. pls find the file attached for details. Pls help Thanks. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en.
Re: $$Excel-Macros$$ query for getting external data from a website
Hi Kenil, Make changes to below code as per your requirement. If you get stuck then let me know. *What you need to do:* -change cURL as per your required time period. -change the range and sheet. -change the query table. Public Const cURL = http://www.forexpros.com/indices/us-spx-500-components; Sub SportExchangeQuery() Application.EnableEvents = False Dim rRange As Range Dim shCountAs Integer Dim lRow As Long Dim ShIndex As Integer ShIndex = 1 shCount = ThisWorkbook.Sheets.Count ThisWorkbook.Sheets(ShIndex).Activate If shCount = 2 Then ThisWorkbook.Sheets(ShIndex + 1).Activate lRow = Range(A65000).End(xlUp).Row + 20 Else lRow = Range(A65000).End(xlUp).Row + 20 End If If lRow 6 Then ThisWorkbook.Sheets.Add After:=Sheets(ShIndex) lRow = Range(A65000).End(xlUp).Row + 2 End If Set rRange = Range(B lRow + 1) rRange.Select rRange.Offset(0, -1).Value = Date rRange.Offset(0, -1).Resize(1, 10).Font.Bold = True rRange.Offset(0, -1).Resize(1, 10).Interior.Color = vbCyan With ActiveSheet.QueryTables.Add(Connection:= _ URL; cURL, Destination:=Range(rRange.Address)) .Name = HOCKEY .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = True .RefreshOnFileOpen = False .BackgroundQuery = False .RefreshStyle = xlInsertDeleteCells .SavePassword = False .SaveData = True .AdjustColumnWidth = True .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = 2,3,4,5 .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With Range(rRange.Offset(1, -1).Address, Range(B63000).End(xlUp).Offset(0, -1).Address).Value = Now ActiveSheet.Columns(A).EntireColumn.AutoFit Call StartTimer Application.EnableEvents = True End Sub On Mon, Dec 31, 2012 at 12:24 PM, Dhaval Shah todhavals...@gmail.comwrote: Kenil pls click the below mention link to download data of any eq series stocks www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012 *TCS*EQN.csv www.nseindia.com/content/equities/scripvol/datafiles/30-09-2012-TO-28-12-2012RELIANCE **EQN.csv just u have to change the script name ( NSE SYMBOL ) time period for difference stocks On Sun, Dec 30, 2012 at 4:46 PM, Kenil Gala keni...@yahoo.com wrote: Hi, I want data of last 3months of a particular stock from a website. i have link of that website but dont know how to import it.i just want if i change just symbol of that particular script i get the data of that particular script i want. pls find the file attached for details. Pls help Thanks. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send email to excel-macros@googlegroups.com. To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros?hl=en. -- Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To post to this group, send
Re: $$Excel-Macros$$ Query for applying the formula
Hi It could not be so. Check whether you have provided correct sheet name in your project sheet also.. Rgds//Vabs On Wed, Oct 24, 2012 at 4:05 PM, Kenil Gala keni...@yahoo.com wrote: Hi all, Pls help me solve my query. I have written my query in the attachment . Thanks Regards. -- 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.
Re: $$Excel-Macros$$ Query related to Salary binding up
Hi all, Need help on this. Regards, Ankit On Thu, Oct 18, 2012 at 5:21 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Hi Haseeb, Thanks for your mail. this is really help me. but I have some point which can make it more effective and efficient. - Department code will be written automatically. - and , another point is, If any employee salary is going in two percentage(%) (as in sonu),we do not need to write it twice and more time. Except above point sheet and process is really good and helpful to me Regards, Ankit On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal ankit.agrawal...@gmail.com wrote: Dear All, I have a salary sheets where there are three column i.e. Name, Department and salary. I need department wise salary sheet but there is one issue.there are lots of employees whose salary is going in more then 1 department so I am confused how I bind up my salary. I mentioned my method in attached sheet.kindly give me better way to prepare it. Regards, Ankit -- 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.
Re: $$Excel-Macros$$ Query related to Salary binding up
Hi Haseeb, Thanks for your mail. this is really help me. but I have some point which can make it more effective and efficient. - Department code will be written automatically. - and , another point is, If any employee salary is going in two percentage(%) (as in sonu),we do not need to write it twice and more time. Except above point sheet and process is really good and helpful to me Regards, Ankit On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear All, I have a salary sheets where there are three column i.e. Name, Department and salary. I need department wise salary sheet but there is one issue.there are lots of employees whose salary is going in more then 1 department so I am confused how I bind up my salary. I mentioned my method in attached sheet.kindly give me better way to prepare it. Regards, Ankit -- 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.
Re: $$Excel-Macros$$ Query related to Salary binding up
Hello Ankit, Attached is a one way. This is not a best one, some one will have better options. I have added two columns. One is Dpmt% 2nd one is No: of Dpmt, which is return through a formula. No:of Dpmt column, MUST NOT be empty or zero. Better to use dynamic range or convert your range to Table. Table format will adjust the No:of Dpmt column when add new entries. Hope this helps Haseeb -- 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. Query related to salary.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query related to Salary binding up
Hi All, Can it be possible or I have to do same process which I am doing. Regards, Ankit On Mon, Oct 15, 2012 at 12:21 PM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear All, I have a salary sheets where there are three column i.e. Name, Department and salary. I need department wise salary sheet but there is one issue.there are lots of employees whose salary is going in more then 1 department so I am confused how I bind up my salary. I mentioned my method in attached sheet.kindly give me better way to prepare it. Regards, Ankit -- 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.
Re: $$Excel-Macros$$ Query
David - this still showing value error. On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.au wrote: Use =SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2) Regards David Grugeon On 28 September 2012 22:24, Aamir Shahzad aamirshahza...@gmail.com wrote: Dear Group, When I mannualy enter the C7 into the following formula, it has no problem, =SUMPRODUCT(($H$2:$H$9=$H13)*(C7)) but when I am trying to generate C7, it's given me #value error, however address function is creating the C7 ok seperaterly. =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2 Sample file is also attached, Please suggest. Regards, Aamir Shahzad -- 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. -- Regards, Aamir Shahzad -- 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$$ Query
Hi Aamir, Try this one. =INDEX(C2,MATCH($H12,$H$2:$H$9,0)) Regards, Kuldeep Singh On Sat, Sep 29, 2012 at 2:48 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: David - this still showing value error. On Sat, Sep 29, 2012 at 4:48 AM, David Grugeon da...@grugeon.com.auwrote: Use =SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2) Regards David Grugeon On 28 September 2012 22:24, Aamir Shahzad aamirshahza...@gmail.com wrote: Dear Group, When I mannualy enter the C7 into the following formula, it has no problem, =SUMPRODUCT(($H$2:$H$9=$H13)*(C7)) but when I am trying to generate C7, it's given me #value error, however address function is creating the C7 ok seperaterly. =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2 Sample file is also attached, Please suggest. Regards, Aamir Shahzad -- 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. -- Regards, Aamir Shahzad -- 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,
Re: $$Excel-Macros$$ Query
Use =SUMPRODUCT(($H$2:$H$9=$H12)*indirect((ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2) Regards David Grugeon On 28 September 2012 22:24, Aamir Shahzad aamirshahza...@gmail.com wrote: Dear Group, When I mannualy enter the C7 into the following formula, it has no problem, =SUMPRODUCT(($H$2:$H$9=$H13)*(C7)) but when I am trying to generate C7, it's given me #value error, however address function is creating the C7 ok seperaterly. =SUMPRODUCT(($H$2:$H$9=$H12)*(ADDRESS(MATCH($H12,$H$2:$H$9,0)+1,COLUMN(C2 Sample file is also attached, Please suggest. Regards, Aamir Shahzad -- 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.
RE: $$Excel-Macros$$ Query - Circle Invalid...
Not getting your problem??? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel Vba Sent: 13 September 2012 7:40 To: excelvbacli...@googlegroups.com Subject: $$Excel-Macros$$ Query - Circle Invalid... Hi Group, I want to know how Circle Invalid function works in excel and vba. Regards, Hemant. -- 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.
Re: $$Excel-Macros$$ Query - Circle Invalid...
Circle Invalid? Are you refering to a Circular Reference? I've never heard of a Circle Invalid 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: Excel Vba excelvba.lear...@gmail.com To: excelvbacli...@googlegroups.com Sent: Thu, September 13, 2012 10:11:28 AM Subject: $$Excel-Macros$$ Query - Circle Invalid... Hi Group, I want to know how Circle Invalid function works in excel and vba. Regards, Hemant. -- 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.
Re: $$Excel-Macros$$ Query - Circle Invalid...
I think it is excel 2010 version. When you goto Data tab, then select Data validation drop down. You will find second option. It automatically select the invalid data. On Thu, Sep 13, 2012 at 8:13 PM, Paul Schreiner schreiner_p...@att.netwrote: Circle Invalid? Are you refering to a Circular Reference? I've never heard of a Circle Invalid 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:* Excel Vba excelvba.lear...@gmail.com *To:* excelvbacli...@googlegroups.com *Sent:* Thu, September 13, 2012 10:11:28 AM *Subject:* $$Excel-Macros$$ Query - Circle Invalid... Hi Group, I want to know how Circle Invalid function works in excel and vba. Regards, Hemant. -- 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.
RE: $$Excel-Macros$$ Query - Circle Invalid...
There is a Data Validation option to Circle Invalid DAta -- data that does not match the data validation rule for its cell. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel Vba Sent: Thursday, September 13, 2012 8:46 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query - Circle Invalid... I think it is excel 2010 version. When you goto Data tab, then select Data validation drop down. You will find second option. It automatically select the invalid data. On Thu, Sep 13, 2012 at 8:13 PM, Paul Schreiner schreiner_p...@att.net wrote: Circle Invalid? Are you refering to a Circular Reference? I've never heard of a Circle Invalid 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: Excel Vba excelvba.lear...@gmail.com To: excelvbacli...@googlegroups.com Sent: Thu, September 13, 2012 10:11:28 AM Subject: $$Excel-Macros$$ Query - Circle Invalid... Hi Group, I want to know how Circle Invalid function works in excel and vba. Regards, Hemant. -- 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 mailto:excel-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 excel-macros+unsubscr...@googlegroups.com mailto:excel-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 excel-macros+unsubscr...@googlegroups.com. -- Join official facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES (1120
RE: $$Excel-Macros$$ Query - AutoNumber
Hi Hemant, Here is a workaround. Please change it accordingly Sub GenerateAutoNumber() Dim lngPreviousNo as long lngpreviousNo = 1 lngpreviousNo = lngpreviousNo + 1 MsgBox lngpreviousNo End sub Regards, Lalit Mohan +919711867226 [IM Only] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Excel Vba Sent: Tuesday, July 10, 2012 7:12 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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 -- 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$$ query for finding maximum and minimum values
Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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.
Re: $$Excel-Macros$$ query for finding maximum and minimum values
Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2))) On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comwrote: On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA vijayajith...@gmail.comwrote: Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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, Noorain Ansari http:// http://www.noorainansari.comnoorainansari.comhttp://www.noorainansari.com http:// http://www.excelvbaclinic.blogspot.comexcelvbaclinic.comhttp://www.excelvbaclinic.blogspot.comhttp://accesssqclinic.blogspot.in/ -- 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$$ query for finding maximum and minimum values
thank u vijayajith and noorain ansari for your reply, but i think u have mis understood my query. i have written my query with a comment in another cell again, Thanks and Regards. --- On Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: From: NOORAIN ANSARI noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 12:27 PM Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2))) On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.com wrote: On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA vijayajith...@gmail.com wrote: Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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, Noorain Ansari http://noorainansari.com http://excelvbaclinic.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
Re: $$Excel-Macros$$ query for finding maximum and minimum values
Dear Kenil, There is no attachment with this mail. Please send attachment with comment. On Tue, Aug 14, 2012 at 6:19 PM, Kenil Gala keni...@yahoo.com wrote: thank u vijayajith and noorain ansari for your reply, but i think u have mis understood my query. i have written my query with a comment in another cell again, Thanks and Regards. --- On *Tue, 8/14/12, NOORAIN ANSARI noorain.ans...@gmail.com* wrote: From: NOORAIN ANSARI noorain.ans...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 12:27 PM Dear Kenil, Without using ctrl+shfit+enter You can also use.. =SUMPRODUCT(MIN(($D2:$G20)*($D2:$G2))) =SUMPRODUCT(MAX(($D2:$G20)*($D2:$G2))) On Tue, Aug 14, 2012 at 5:38 PM, vijayajith VA vijayajith...@gmail.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=vijayajith...@gmail.com wrote: On Tue, Aug 14, 2012 at 5:32 PM, vijayajith VA vijayajith...@gmail.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=vijayajith...@gmail.com wrote: Hi kenil, Pls change accordg to your data. =MAX(IF(B1:B70,B1:B7)) =MIN(IF(A1:A70,A1:A7)) On Tue, Aug 14, 2012 at 5:24 PM, Kenil Gala keni...@yahoo.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=keni...@yahoo.com wrote: hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-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.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros@googlegroups.com . To unsubscribe from this group, send email to excel-macros+unsubscr...@googlegroups.comhttp://us.mc1144.mail.yahoo.com/mc/compose?to=excel-macros%2bunsubscr...@googlegroups.com . -- 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/ -- 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
Re: $$Excel-Macros$$ query for finding maximum and minimum values
Yes Sir, Perfect Thanks a Ton. Thanks Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 5:05 PM Should do it Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 10:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values Hello sir , i have explained my query more clearly again in the excel sheet. i hope u'll be able to understand the query. Thanks and Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 3:02 PM This is your question in i4 comment hi, I have daily data of high , low and close of a specific stock (BSE). But I want weekly high,low,close and also monthly high, low, close in their respective sheets. Eg. Stock market has 5 working days, so any value which can be highest and lowest withing the week and the closing price of friday. i tried doing this by taking 5 set of data( monday - friday) but at times of holiday, markets remain working only 4 or 3 days. so, can you help me finding weekly high, low, close and also monthly high, low, close( from 1st to 31st or 30th or 28th as per month) and also TO and from date i.e the time span of that week or month. that i have mentioned in the table in sheet 2 and sheet 3. i have taken all this data from www.nseindia.com Thanks. === Your query is not understandable. If you want the minimum low and the maximum high and the average close for the week, see attached. Maybe you really want the min CLOSE?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 6:54 AM To: excel macros Subject: $$Excel-Macros$$ query for finding maximum and minimum values hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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
Re: $$Excel-Macros$$ query for finding maximum and minimum values
I am available for custom excel projects at only $75 hourly . Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 12:20 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values Yes Sir, Perfect Thanks a Ton. Thanks Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 5:05 PM Should do it Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 10:45 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values Hello sir , i have explained my query more clearly again in the excel sheet. i hope u'll be able to understand the query. Thanks and Regards, --- On Tue, 8/14/12, dguillett1 dguille...@gmail.com wrote: From: dguillett1 dguille...@gmail.com Subject: Re: $$Excel-Macros$$ query for finding maximum and minimum values To: excel-macros@googlegroups.com Date: Tuesday, August 14, 2012, 3:02 PM This is your question in i4 comment hi, I have daily data of high , low and close of a specific stock (BSE). But I want weekly high,low,close and also monthly high, low, close in their respective sheets. Eg. Stock market has 5 working days, so any value which can be highest and lowest withing the week and the closing price of friday. i tried doing this by taking 5 set of data( monday - friday) but at times of holiday, markets remain working only 4 or 3 days. so, can you help me finding weekly high, low, close and also monthly high, low, close( from 1st to 31st or 30th or 28th as per month) and also TO and from date i.e the time span of that week or month. that i have mentioned in the table in sheet 2 and sheet 3. i have taken all this data from www.nseindia.com Thanks. === Your query is not understandable. If you want the minimum low and the maximum high and the average close for the week, see attached. Maybe you really want the min CLOSE?? Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Kenil Gala Sent: Tuesday, August 14, 2012 6:54 AM To: excel macros Subject: $$Excel-Macros$$ query for finding maximum and minimum values hi all, i have a query for finding maximum and minimum values. i have written my query in the excel sheet attached. pls help me solve my query. Thanks and Regards, -- 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
Re: $$Excel-Macros$$ Query- Global Variable
Dear Hemant, Lalit solution is nice You can also check.. http://www.ozgrid.com/forum/showthread.php?t=58969 On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.comwrote: Hi Group, How can i declare a global variable for below mentioned. Private sub abc() dim sh as worksheet dim rng as range set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub In my module i have 20 procedure and in future comes many more. So, my query how to declare a global variable and how to call in my procedure. Regards, excelvba.lear...@gmail.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
Re: $$Excel-Macros$$ Query- Global Variable
Dear If you want a variabler such that it will works for all the procedure in a module use below. dim sh as worksheet dim rng as range Private sub abc() set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub or else If you want it access from any module try below one.. Public sh as worksheet Public rng as range Private sub abc() set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub Regards, Lalit Mohan On Fri, Jul 13, 2012 at 4:51 PM, Excel Vba excelvba.lear...@gmail.com wrote: Hi Group, How can i declare a global variable for below mentioned. Private sub abc() dim sh as worksheet dim rng as range set sh = Thisworkbook.Sheets(Sheet1) set rng = sh.range(a1:csh.range(crows.count).end(xlup).row) End sub In my module i have 20 procedure and in future comes many more. So, my query how to declare a global variable and how to call in my procedure. Regards, excelvba.lear...@gmail.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$$ Query - AutoNumber
NEI Not enough information Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com From: Excel Vba Sent: Tuesday, July 10, 2012 8:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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$$ Query - AutoNumber
can u give a idea On Tue, Jul 10, 2012 at 7:52 PM, dguillett1 dguille...@gmail.com wrote: NEI Not enough information Don Guillett Microsoft Excel Developer SalesAid Software dguille...@gmail.com *From:* Excel Vba excelvba.lear...@gmail.com *Sent:* Tuesday, July 10, 2012 8:42 AM *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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$$ Query - AutoNumber
Sorry, not enough info. WHERE do you have the numbers? how do you tell what the last number used was? are the numbers actual NUMBERS or are they ALPHAnumeric? (like: A123456) For instance, if the numbers are all in column A, AND THEY'RE NUMERIC then you can use: NextNo = Application.WorksheetFunction.Max(Sheets(Sheet1).Range(A:A)) + 1 of course, this assumes that they're in column A of a sheet called Sheet1, and they're actual numbers. without more info, this is the best I can do. 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: Excel Vba excelvba.lear...@gmail.com To: excel-macros@googlegroups.com Sent: Tue, July 10, 2012 9:42:23 AM Subject: $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant.-- 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$$ Query - AutoNumber
Thnaks Paul. - On Tue, Jul 10, 2012 at 8:00 PM, Paul Schreiner schreiner_p...@att.netwrote: Sorry, not enough info. WHERE do you have the numbers? how do you tell what the last number used was? are the numbers actual NUMBERS or are they ALPHAnumeric? (like: A123456) For instance, if the numbers are all in column A, AND THEY'RE NUMERIC then you can use: NextNo = Application.WorksheetFunction.Max(Sheets(Sheet1).Range(A:A)) + 1 of course, this assumes that they're in column A of a sheet called Sheet1, and they're actual numbers. without more info, this is the best I can do. *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:* Excel Vba excelvba.lear...@gmail.com *To:* excel-macros@googlegroups.com *Sent:* Tue, July 10, 2012 9:42:23 AM *Subject:* $$Excel-Macros$$ Query - AutoNumber Hi Group, I am trying to get a automatically generate a Number using the last number used + 1, through vba. Regards, Hemant. -- 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$$ Query on Email via macro
*Someone please help me on this its important* On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: i just want to send a mail with a subject plz check to the email address in column C for the rows in column B which i mark as done. On Sun, Jul 1, 2012 at 10:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote: What do you want to send in mail??b ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri *Sent:* 01 July 2012 9:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query on Email via macro ** ** Hi, ** ** I have a query..suppose i put some thing in column B and i have mail id in column C i want to send the mail on that ID. ** ** In the example given below if i enter done in column B a mail should be send on address entered in column C ** ** ABC ram sham done *sham@xyzmail* rahim done *rahim@xyzmail* Abdul ** ** Can someone help me with this?? ** ** Regards ** ** Ashwani -- 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$$ Query on Email via macro
assuming you have table in sheet1 like name status email sham done a koul.ash...@gmail.com rahim done bkoul.ash...@gmail.com Abdul done c koul.ash...@gmail.com nAME IN cOL A status in col B email in Col C also visit http://www.rondebruin.nl/tips.htm to know more about oulook automation whenever you change the status to done it will send a email *add this to sheet1* Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Cells.Count = 1 And Target.Column = 2 And UCase(Target.Value) = UCase(Done) Then send_email (Target.Offset(0, 1).Value) End If Application.EnableEvents = True End Sub *add this to module1 or new module* Sub send_email(rec_add As String) ' refence choose outlook Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = rec_add .Subject = xx .Body = ff .Display '\ .send End With Set olApp = Nothing Set olMail = Nothing End Sub On Mon, Jul 2, 2012 at 8:08 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: *Someone please help me on this its important* On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: i just want to send a mail with a subject plz check to the email address in column C for the rows in column B which i mark as done. On Sun, Jul 1, 2012 at 10:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote: What do you want to send in mail??b ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri *Sent:* 01 July 2012 9:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query on Email via macro ** ** Hi, ** ** I have a query..suppose i put some thing in column B and i have mail id in column C i want to send the mail on that ID. ** ** In the example given below if i enter done in column B a mail should be send on address entered in column C ** ** ABC ram sham done *sham@xyzmail* rahim done *rahim@xyzmail* Abdul ** ** Can someone help me with this?? ** ** Regards ** ** Ashwani -- 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
Re: $$Excel-Macros$$ Query on Email via macro
thank you very much for the help ashish [?] On Mon, Jul 2, 2012 at 8:52 PM, ashish koul koul.ash...@gmail.com wrote: assuming you have table in sheet1 like name status email sham done a koul.ash...@gmail.com rahim done bkoul.ash...@gmail.com Abdul done c koul.ash...@gmail.com nAME IN cOL A status in col B email in Col C also visit http://www.rondebruin.nl/tips.htm to know more about oulook automation whenever you change the status to done it will send a email *add this to sheet1* Private Sub Worksheet_Change(ByVal Target As Range) Application.EnableEvents = False If Target.Cells.Count = 1 And Target.Column = 2 And UCase(Target.Value) = UCase(Done) Then send_email (Target.Offset(0, 1).Value) End If Application.EnableEvents = True End Sub *add this to module1 or new module* Sub send_email(rec_add As String) ' refence choose outlook Dim olApp As Outlook.Application Dim olMail As MailItem Set olApp = New Outlook.Application Set olMail = olApp.CreateItem(olMailItem) With olMail .To = rec_add .Subject = xx .Body = ff .Display '\ .send End With Set olApp = Nothing Set olMail = Nothing End Sub On Mon, Jul 2, 2012 at 8:08 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: *Someone please help me on this its important* On Sun, Jul 1, 2012 at 10:17 PM, ashwani agnihotri ashwani.agniho...@gmail.com wrote: i just want to send a mail with a subject plz check to the email address in column C for the rows in column B which i mark as done. On Sun, Jul 1, 2012 at 10:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote: What do you want to send in mail??b ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri *Sent:* 01 July 2012 9:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query on Email via macro ** ** Hi, ** ** I have a query..suppose i put some thing in column B and i have mail id in column C i want to send the mail on that ID. ** ** In the example given below if i enter done in column B a mail should be send on address entered in column C ** ** ABC ram sham done *sham@xyzmail* rahim done *rahim@xyzmail* Abdul ** ** Can someone help me with this?? ** ** Regards ** ** Ashwani -- 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
RE: $$Excel-Macros$$ Query on Email via macro
What do you want to send in mail?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashwani agnihotri Sent: 01 July 2012 9:49 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query on Email via macro Hi, I have a query..suppose i put some thing in column B and i have mail id in column C i want to send the mail on that ID. In the example given below if i enter done in column B a mail should be send on address entered in column C ABC ram sham done sham@xyzmail rahim done rahim@xyzmail Abdul Can someone help me with this?? Regards Ashwani -- 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$$ Query on Email via macro
i just want to send a mail with a subject plz check to the email address in column C for the rows in column B which i mark as done. On Sun, Jul 1, 2012 at 10:02 PM, Rajan_Verma rajanverma1...@gmail.comwrote: What do you want to send in mail??b ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *ashwani agnihotri *Sent:* 01 July 2012 9:49 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ Query on Email via macro ** ** Hi, ** ** I have a query..suppose i put some thing in column B and i have mail id in column C i want to send the mail on that ID. ** ** In the example given below if i enter done in column B a mail should be send on address entered in column C ** ** ABC ram sham done *sham@xyzmail* rahim done *rahim@xyzmail* Abdul ** ** Can someone help me with this?? ** ** Regards ** ** Ashwani -- 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$$ Query for Merging two excel sheets using Command Prompt
Dear Rakesh, Can you provide a sample sheet. Thanks Regards, Prajakt Pande +971551388482 ** On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt
Dear Rakesh, you can use following code Sub CommandButton1() Sheets(your sheet name).Select 'first sheet from you will copy the data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Sheets(your sheet name).Select ' where you want to paste Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets(your sheet name).Select 'second sheet from you will copy the data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Range(a1).End(xlDown).Offset(1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub regards, Prajakt Skype :- prajaktpande On Monday, May 14, 2012 10:46:03 AM UTC+4, Prajakt Pande wrote: Dear Rakesh, Can you provide a sample sheet. Thanks Regards, Prajakt Pande +971551388482 ** On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt
If all sheets have data in same format Sub CompileWOrksheets() Dim wksSheet As Worksheet With ThisWorkbook .Worksheets.Add.Name = Compiled For Each wksSheet In .Worksheets If wksSheet.Name Compiled Then wksSheet.UsedRange.Copy .Worksheets(Compiled).Range(A .Worksheets(Compiled).Range(A Rows.Count).End(xlUp).Row + 1) End If Next wksSheet End With End Sub Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Prajakt Pande Sent: 14 May 2012 12:32 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt Dear Rakesh, you can use following code Sub CommandButton1() Sheets(your sheet name).Select 'first sheet from you will copy the data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Sheets(your sheet name).Select ' where you want to paste Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False Sheets(your sheet name).Select 'second sheet from you will copy the data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Range(a1).End(xlDown).Offset(1).Select Selection.PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=False, Transpose:=False End Sub regards, Prajakt Skype :- prajaktpande On Monday, May 14, 2012 10:46:03 AM UTC+4, Prajakt Pande wrote: Dear Rakesh, Can you provide a sample sheet. Thanks Regards, Prajakt Pande +971551388482 On Mon, May 14, 2012 at 10:19 AM, Rakesh Kumar Sharma rakeshks@gmail.com wrote: Hi, Plz suggest me how i can merge two excel files data to single sheet using command prompt. -- Thanks Regards, Rakesh Kumar Sharma -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query
Hi Aamir, You can use SUBTOTAL formula accordingly. for ex.: Sum of visible cells :- =SUBTOTAL(A1:A100,109) Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Sat, May 12, 2012 at 8:39 PM, Aamir Shahzad aamirshahza...@gmail.com wrote: Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ query
CLTL+G ALT+S K Enter Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 12 May 2012 8:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query
pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote: CLTL+G ALT+S K Enter * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad *Sent:* 12 May 2012 8:40 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query
Your desire is not clear. Provide a file with a complete explanation and examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 10:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.com wrote: CLTL+G ALT+S K Enter Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 12 May 2012 8:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query
Example file is attached. On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote: Your desire is not clear. Provide a file with a complete explanation and examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com *From:* Aamir Shahzad aamirshahza...@gmail.com *Sent:* Saturday, May 12, 2012 10:31 AM *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ query pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.comwrote: CLTL+G ALT+S K Enter *Regards* *Rajan verma* *+91 7838100659 %2B91%207838100659 [IM-Gtalk]* *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Aamir Shahzad *Sent:* 12 May 2012 8:40 *To:* excel-macros@googlegroups.com *Subject:* $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- 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
Re: $$Excel-Macros$$ query
=SUMPRODUCT(SUBTOTAL(3,OFFSET($H$11:$H$100,ROW($H$11:$H$100)-MIN(ROW($H$11:$H$100)),,1)),--($H$11:$H$100=A2),--($I$11:$I$100)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 12:31 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query Example file is attached. On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote: Your desire is not clear. Provide a file with a complete explanation and examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, May 12, 2012 10:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.com wrote: CLTL+G ALT+S K Enter Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 12 May 2012 8:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group
RE: $$Excel-Macros$$ query
Hi Aamir, You can use =SUMPRODUCT(SUBTOTAL(9,OFFSET($I$10,ROW($I$11:$I$100)-ROW($I$10),)),--($A2=$ H$11:$H$100)) in C2 and copy down. It will work for a filtered list like SUMIF. change the SUBTOTAL type from 9 to 109 to have it ignore rows that are manually hidden as well. Best not to use it with an entire column, but to specify the exact range (I used rows 11:100) because it is an array formula and does a calculation for every row. It is also volatile, so it is recalculated at every calculation. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, May 12, 2012 10:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query Example file is attached. On Sat, May 12, 2012 at 9:04 PM, dguillett1 dguille...@gmail.com wrote: Your desire is not clear. Provide a file with a complete explanation and examples. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad mailto:aamirshahza...@gmail.com Sent: Saturday, May 12, 2012 10:31 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query pick the values by vlookup or sumif only on visible cells. On Sat, May 12, 2012 at 8:19 PM, Rajan_Verma rajanverma1...@gmail.com wrote: CLTL+G ALT+S K Enter Regards Rajan verma +91 7838100659 tel:%2B91%207838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 12 May 2012 8:40 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ query Dear Group, How to pick the values by formula of visible cells only? Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners
RE: $$Excel-Macros$$ Query.
Hi See the attached file Function DatedDiff(dtStart As Date, dtEnd As Date) As String Dim ArrStart Dim ArrEnd Dim ArrResult ArrStart = Array(Year(dtStart), Month(dtStart), Day(dtStart)) ArrEnd = Array(Year(dtEnd), Month(dtEnd), Day(dtEnd)) ArrResult = Array(0, 0, 0) If ArrEnd(2) ArrStart(2) Then ArrEnd(2) = ArrEnd(2) + Day(CDate(ArrEnd(1) -1- ArrEnd(0)) - 1) ArrEnd(1) = ArrEnd(1) - 1 End If ArrResult(2) = ArrEnd(2) - ArrStart(2) If ArrEnd(1) ArrStart(1) Then ArrEnd(1) = ArrEnd(1) + 12 ArrEnd(0) = ArrEnd(0) - 1 End If ArrResult(1) = ArrEnd(1) - ArrStart(1) ArrResult(0) = ArrEnd(0) - ArrStart(0) If dtEnd dtStart Then DatedDiff = StartDateEndData=TRUE Else DatedDiff = Year= ArrResult(0) | Month= ArrResult(1) | Day= ArrResult(2) End If Erase ArrStart Erase ArrEnd Erase ArrResult End Function http://excelpoweruser.blogspot.in/search?q=date+difference Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Shaik Waheed Sent: 01 May 2012 12:25 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query. Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.com wrote: Hi Experts, PLease solve my query. I need age betbeen in two dated like as 2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com mailto:e-mail%3a-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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 Copy of Book1(1) -Solved.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Query.
Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.comwrote: Hi Experts, PLease solve my query. I need age betbeen in two dated like as 2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com Book1(1) -Solved.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query.
Thanks... On Tue, May 1, 2012 at 12:25 PM, Shaik Waheed waheedb...@gmail.com wrote: Hi, PFA On Tue, May 1, 2012 at 11:53 AM, Pramod Kumar kumar.pramod03i...@gmail.com wrote: Hi Experts, PLease solve my query. I need age betbeen in two dated like as 2 year 3 Month) -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Pramod Kumar Technocare Solution(TCS) Rudrapur +91 9927033573 E-Mail:-kumar.pramod03i...@gmail.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query (Remove duplicate)
Go to data- remove duplicates Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Karan Singh karan1...@gmail.com Sender: excel-macros@googlegroups.com Date: Mon, 19 Mar 2012 13:07:52 To: excel-macros@googlegroups.com Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query (Remove duplicate) Dear All, I need you assistance, I want to remove duplicate value from column A to B. I'v attached the test file. Kindly help me in this. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query (Remove duplicate)
Dear Karan, Please use below code.. Dim i, j As Integer Application.ScreenUpdating = False For i = 1 To Range(A65536).End(xlUp).Row For j = 1 To Range(B65536).End(xlUp).Row If Range(A i).Value = Range(B j).Value Then Range(B j).Delete Shift:=xlUp End If Next j Next i Application.ScreenUpdating = True On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh karan1...@gmail.com wrote: Dear All, I need you assistance, I want to remove duplicate value from column A to B. I'v attached the test file. Kindly help me in this. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts -- 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 -- Thanks regards, Noorain Ansari *http://noorainansari.com/* http://excelmacroworld.blogspot.com/ *http://excelmacroworld.blogspot.com/*http://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 Query(Karan).xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Query (Remove duplicate)
Hi Karan, Try Advanced filter and select Unique records..And you can Copy and paste it in New Column.. [image: Inline image 1] *Best Regards,* *Venkat * *Chennai* *My Linked in profile http://in.linkedin.com/pub/venkatesan-c/21/492/a71* On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh karan1...@gmail.com wrote: Dear All, I need you assistance, I want to remove duplicate value from column A to B. I'v attached the test file. Kindly help me in this. Kaяan http://www.facebook.com/singhkarann http://twitter.com/#%21/karan1237 https://plus.google.com/43524614789164919/posts -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- * * * * -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com image.png
Re: $$Excel-Macros$$ Query
=IF(B2SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31=main,Greater than Main,) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Saturday, March 10, 2012 11:31 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Dear Group, If amount of specific id is grater then Main amount it should show comment. Please see the attached file and provide the formula for this. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query
=IF(B2SUMPRODUCT(MAX($B$2:$B$31*(($A$2:$A$31=A2)*($C$2:$C$31=main,Greater than Main,) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Sunday, March 11, 2012 1:27 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query Thanks Asa, thanks for your formula, if specific id has more then one Main it should consider the 1st main then 2nd main. Regards, Aamir Shahzad On Sun, Mar 11, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info wrote: Hi Aamir, Should there be only one main per ID? ID 1 has two mains. This formula will give your desired result based on the sum of the MAINs for a given ID: =IF($C2MAIN,IF($B2SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN),Greater than Main,),) This will use the average of the MAINs for a given ID: =IF($C2MAIN,IF($B2AVERAGEIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN),Greater than Main,),) This will use the maximum of the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$16)),Greater than Main,),) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 9:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Dear Group, If amount of specific id is grater then Main amount it should show comment. Please see the attached file and provide the formula for this. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss
RE: $$Excel-Macros$$ Query
Hi Aamir, You're welcome. The maximum version does that. Array enter on row 2 and copy down. =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$1 6)),Greater than Main,),) Don's sumproduct version should work too; to calculate his formula only for non-main rows, you could wrap it in an IF like I used above: =IF($C2MAIN,formula,) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 11:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query Thanks Asa, thanks for your formula, if specific id has more then one Main it should consider the 1st main then 2nd main. Regards, Aamir Shahzad On Sun, Mar 11, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info wrote: Hi Aamir, Should there be only one main per ID? ID 1 has two mains. This formula will give your desired result based on the sum of the MAINs for a given ID: =IF($C2MAIN,IF($B2SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN), Greater than Main,),) This will use the average of the MAINs for a given ID: =IF($C2MAIN,IF($B2AVERAGEIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN ),Greater than Main,),) This will use the maximum of the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$1 6)),Greater than Main,),) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 9:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Dear Group, If amount of specific id is grater then Main amount it should show comment. Please see the attached file and provide the formula for this. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive
Re: $$Excel-Macros$$ Query
Asa, My formula tested fine without the proposed change. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Asa Rossoff Sent: Sunday, March 11, 2012 11:28 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Query Hi Aamir, You're welcome. The maximum version does that. Array enter on row 2 and copy down. =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$16)),Greater than Main,),) Don's sumproduct version should work too; to calculate his formula only for non-main rows, you could wrap it in an IF like I used above: =IF($C2MAIN,formula,) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 11:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query Thanks Asa, thanks for your formula, if specific id has more then one Main it should consider the 1st main then 2nd main. Regards, Aamir Shahzad On Sun, Mar 11, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info wrote: Hi Aamir, Should there be only one main per ID? ID 1 has two mains. This formula will give your desired result based on the sum of the MAINs for a given ID: =IF($C2MAIN,IF($B2SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN),Greater than Main,),) This will use the average of the MAINs for a given ID: =IF($C2MAIN,IF($B2AVERAGEIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN),Greater than Main,),) This will use the maximum of the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$16)),Greater than Main,),) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 9:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Dear Group, If amount of specific id is grater then Main amount it should show comment. Please see the attached file and provide the formula for this. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may
RE: $$Excel-Macros$$ Query
No main will ever be than maximum main of course, but it will save calculation time. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Sunday, March 11, 2012 10:26 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query Asa, My formula tested fine without the proposed change. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Asa Rossoff mailto:a...@lovetour.info Sent: Sunday, March 11, 2012 11:28 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Query Hi Aamir, You're welcome. The maximum version does that. Array enter on row 2 and copy down. =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$1 6)),Greater than Main,),) Don's sumproduct version should work too; to calculate his formula only for non-main rows, you could wrap it in an IF like I used above: =IF($C2MAIN,formula,) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 11:28 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query Thanks Asa, thanks for your formula, if specific id has more then one Main it should consider the 1st main then 2nd main. Regards, Aamir Shahzad On Sun, Mar 11, 2012 at 1:06 AM, Asa Rossoff a...@lovetour.info wrote: Hi Aamir, Should there be only one main per ID? ID 1 has two mains. This formula will give your desired result based on the sum of the MAINs for a given ID: =IF($C2MAIN,IF($B2SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN), Greater than Main,),) This will use the average of the MAINs for a given ID: =IF($C2MAIN,IF($B2AVERAGEIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN ),Greater than Main,),) This will use the maximum of the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$1 6)),Greater than Main,),) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 9:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Dear Group, If amount of specific id is grater then Main amount it should show comment. Please see the attached file and provide the formula for this. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Regards, Aamir Shahzad -- 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
RE: $$Excel-Macros$$ Query
Hi Aamir, Should there be only one main per ID? ID 1 has two mains. This formula will give your desired result based on the sum of the MAINs for a given ID: =IF($C2MAIN,IF($B2SUMIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN), Greater than Main,),) This will use the average of the MAINs for a given ID: =IF($C2MAIN,IF($B2AVERAGEIFS($B$2:$B$16,$A$2:$A$16,$A2,$C$2:$C$16,MAIN ),Greater than Main,),) This will use the maximum of the MAINs for a given ID. Array formula, confirm entry with CSE (ctrl-shift-enter): =IF($C2MAIN,IF($B2MAX(IF(($A$2:$A$16=$A2)*($C$2:$C$16=MAIN),$B$2:$B$1 6)),Greater than Main,),) Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: Saturday, March 10, 2012 9:32 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query Dear Group, If amount of specific id is grater then Main amount it should show comment. Please see the attached file and provide the formula for this. Regards, Aamir Shahzad -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ Query continuous copy paste
Try this : Sub Transformdata() Dim rngCEll As Range Dim rngRange As Range Dim wksOutput As Worksheet Set wksOutput = ThisWorkbook.Worksheets.Add Set rngRange = ThisWorkbook.Worksheets(Query).Rows(1) For Each rngCEll In rngRange.Cells Application.ScreenUpdating = False If rngCEll.Value = Then Exit For If rngCEll.Value = Name Then rngCEll.Resize(rngCEll.End(xlDown).Row, 2).Copy wksOutput.Range(A WorksheetFunction.CountA(wksOutput.Range(A:A)) + 1) End If Next With wksOutput .UsedRange.WrapText = False .Rows.AutoFit .Columns.AutoFit .Range($A$1:$B$114).AutoFilter Field:=1, Criteria1:=Name .Cells.SpecialCells(xlCellTypeVisible).EntireRow.Delete .Range(A1).EntireRow.Insert .Range(A1).Value = Name .Range(B1).Value = No End With Application.ScreenUpdating = False End Sub -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mukesh Kumar Sent: Jan/Tue/2012 01:10 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query continuous copy paste Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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 -- 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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,
Re: $$Excel-Macros$$ Query continuous copy paste
Try Option Explicit Sub copycolumstorowsSAS() Dim i As Long For i = 1 To Cells(1, Columns.Count).End(xlToLeft).Column Step 2 Cells(2, i).Resize(6, 2).Copy Cells(Rows.Count, 1).End(xlUp).Offset(1) Next i End Sub Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Mukesh Kumar Sent: Tuesday, January 31, 2012 1:40 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query continuous copy paste Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
@ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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 -- FORUM RULES (986+ members already BANNED for violation) 1) Use
Re: $$Excel-Macros$$ Query continuous copy paste
Always nice to tell us the ENTIRE problem at the FIRST post. It appears that, if you give proper info, then the last offering by Noorain should work. Don Guillett SalesAid Software dguille...@gmail.com From: Mukesh Kumar Sent: Tuesday, January 31, 2012 9:50 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Query continuous copy paste @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com
Re: $$Excel-Macros$$ Query continuous copy paste
Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Sub Consolidator() Dim rngSource As Range Dim lngCols As Long, lngRows As Long Set rngSource = Range(A1).CurrentRegion lngRows = rngSource.CurrentRegion.Rows.Count - 1 For lngCols = 3 To rngSource.Columns.Count - 1 Step 2 rngSource.Cells(2, lngCols).Resize(lngRows, 2).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next lngCols rngSource.Offset(, 2).Delete xlUp End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:10 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- 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
Re: $$Excel-Macros$$ Query continuous copy paste
Here's the working model. Have given a button for ease. Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:21 PM, Sam Mathai Chacko samde...@gmail.comwrote: Sub Consolidator() Dim rngSource As Range Dim lngCols As Long, lngRows As Long Set rngSource = Range(A1).CurrentRegion lngRows = rngSource.CurrentRegion.Rows.Count - 1 For lngCols = 3 To rngSource.Columns.Count - 1 Step 2 rngSource.Cells(2, lngCols).Resize(lngRows, 2).Copy Cells(Rows.Count, 1).End(xlUp)(2) Next lngCols rngSource.Offset(, 2).Delete xlUp End Sub Regards, Sam Mathai Chacko On Tue, Jan 31, 2012 at 10:10 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Kris, Following error is coming after macro execution Run time error '9': Subscript out of range. Please correct it. Regards, Mukesh kumar On Tue, Jan 31, 2012 at 10:00 PM, Kris krishnak...@gmail.com wrote: Sub kTest() Dim x, ka, k(), i As Long, n As Long, c As Long, j As Long, p As Long With Worksheets(Query) ka = .Range(a1).CurrentRegion End With With CreateObject(scripting.dictionary) .comparemode = 1 For c = 1 To UBound(ka, 2) If Not .exists(ka(1, c)) Then j = j + 1 .Add ka(1, c), j End If Next ReDim k(1 To UBound(ka, 1) * UBound(ka, 2), 1 To j) For c = 1 To UBound(ka, 2) Step j For i = 2 To UBound(ka, 1) n = n + 1 For p = 0 To j - 1 k(n, .Item(ka(1, c + p))) = ka(i, c + p) Next Next Next x = .keys End With If n Then With Worksheets(Sheet1).Range(a1) .Parent.UsedRange.ClearContents .Range(a1).Resize(, j) = x .Range(a2).Resize(n, j) = k .Parent.UsedRange.Columns.AutoFit End With End If End Sub Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- 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
Re: $$Excel-Macros$$ Query continuous copy paste
One of the header is 'No' instead of 'No.' Correct the headers, it should work Kris -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code for three similar headers another coding is required so on. Can u give common macro irrespective of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command Button On Tue, Jan 31, 2012 at 9:20 PM, Mukesh Kumar mukeshka...@gmail.comwrote: @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.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
Re: $$Excel-Macros$$ Query continuous copy paste
Thanks very very much Sam Mathai Chacko sir. This was the resultant code i was looking for. You are marvellous in excel sir. Thanks again. Regards, Mukesh Kumar On Wed, Feb 1, 2012 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote: The code I gave was exactly for assigning any number of header groups. Sam On Tue, Jan 31, 2012 at 11:44 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Thanks a lot for solving my queries Ansari ji. But still one problem knocking my mind that these macroes are suitable for respective problems i have given i.e for two similar headers separate code for three similar headers another coding is required so on. Can u give common macro irrespective of Header names or count ? Else i feels i am unable to make clear my query to you ! Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 11:18 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, See attached sheet Only procedure name is incorrect during calling under Command Button On Tue, Jan 31, 2012 at 9:20 PM, Mukesh Kumar mukeshka...@gmail.comwrote: @ Don Guillett Dear sir, your macro after running giving wrong results, please check. @ Noorain Ansari Sir, macro after running showing error compile error. Sub or function not defined. Please note, i am having different workbooks in which some workbooks contains 2 columns similar, some 3 columns headings similar other workbooks =5 similar column headings. So for all my workbooks, can you guys give common macro code or formulas. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:59 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please see attached sheet... I hope your query has been resolved... On Tue, Jan 31, 2012 at 8:48 PM, Mukesh Kumar mukeshka...@gmail.comwrote: Dear Ansari ji, Macro is running fine if sheet is having set of two similar header columns i.e let say a b. Problem occurs when header columns are more than two sets i.e a, b c. You can see in the attached file. You can also consider my query better as consolidate columns on basis of Column Titles. Hope you understand my query. Regards, Mukesh Kumar On Tue, Jan 31, 2012 at 8:24 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Can you provide that worksheet, where macro is not running... Please share workbook with group.. On Tue, Jan 31, 2012 at 7:17 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Thanks Noorain Ansari Ji for the solution but it works is working with this sheet only i.e if the column headings are having two same titles. If I have to transform three or four columns to first three or four columns then this macro will not work there. Please suggest any formula or user form according to variable number of columns titles. Waiting for the reply. Regards, Mukesh kumar On 1/31/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Mukesh, Please try it.. and see attached sheet. Sub mukesh() Dim i, c, j As Integer c = Application.WorksheetFunction.CountA(Sheet1.Range(1:1)) Sheet2.Range(A1:B1) = Array(Name, No) counter = 2 For j = 2 To c Step 2 For i = 2 To Sheet1.Cells(Rows.Count, j).End(xlUp).Row Sheet2.Cells(counter, 1).Value = Sheet1.Cells(i, j - 1) Sheet2.Cells(counter, 2).Value = Sheet1.Cells(i, j) counter = counter + 1 Next i Next j Sheet2.Columns.AutoFit Sheet2.Activate End Sub On Tue, Jan 31, 2012 at 1:10 PM, Mukesh Kumar mukeshka...@gmail.com wrote: Dear Sir, Please tell me the solution for the query given in the attached file. In it the data is distributed in the different columns. The solution is manually copy paste the data which is time consuming process. Please tell me the solution or formula to automate the process. Also please note that here two columns are having label i.e. Name No. There may be certain time the columns may having more than 2 or more labels. So please keep this situation too in mind. Thanks Regards, Mukesh 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 -- Thanks regards, Noorain Ansari
Re: $$Excel-Macros$$ query about translate
Hello group, there is other way to translate. Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query about translate
Dear Anil, Attached file format is same as you posted previous. All Fonts are in Hindi. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 1:40 PM, anil kumar kmr7a...@gmail.com wrote: hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query about translate
Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ query about translate
Do you want to translate data or just want to change format ?? From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Fri/2012 04:23 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query about translate Yes sir, this same file, How can i do plz tell me. I have to translate that data in english Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query about translate
I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query about translate
Dear Noorain Anil want to do like under written Jh yksds'k dqekj vxzoky to Shri Lokesh Kumar Aggarwal From: NOORAIN ANSARI noorain.ans...@gmail.com To: excel-macros@googlegroups.com Sent: Friday, 20 January 2012 2:13 PM Subject: Re: $$Excel-Macros$$ query about translate Dear Anil, Attached file format is same as you posted previous. All Fonts are in Hindi. -- Thanks regards, Noorain Ansari http://excelmacroworld.blogspot.com/ http://noorain-ansari.blogspot.com/ On Fri, Jan 20, 2012 at 1:40 PM, anil kumar kmr7a...@gmail.com wrote: hello group, How r all of u, I have a excel file in hindi has some name and add etc. I have to translate them in english, can we do that plz tell me. file attahced Anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
RE: $$Excel-Macros$$ query about translate
I think no way in excel without use of any other software Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of anil kumar Sent: Jan/Fri/2012 06:12 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ query about translate I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ query about translate
use http://translate.google.co.in/ On Fri, Jan 20, 2012 at 6:26 PM, Rajan_Verma rajanverma1...@gmail.comwrote: I think no way in excel without use of any other software ** ** Rajan. ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *anil kumar *Sent:* Jan/Fri/2012 06:12 *To:* excel-macros@googlegroups.com *Subject:* Re: $$Excel-Macros$$ query about translate ** ** I want to translate all name and add. in english anil -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- mujhay dukh is baat ka nahin kay meri zaat ko muntashir karny walay haath tairy thy mujhay dukh faqt is baat ka hay meri raiza raiza zaat ko samaitnay walay haath tairy na thy Thanks Regards Sourabh Contact Numbers: +91-94630-49202 Website:http://adhurapyaar.co.cc -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com
Re: $$Excel-Macros$$ Query from URL
Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Alberto Sent: Monday, January 02, 2012 8:32 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Query from URL Hi, I use VBA to retrieve wheather data. This work: With ActiveSheet.QueryTables.Add(Connection:= _ URL;http://www.osmer.fvg.it/~www/IT/SYN/ TabellaStazioniUltimOra.php, _ But with the address below it retrieves nothing ( and no error message too). The same with http://weather.uwyo.edu/cgi-bin/sounding?region=europeTYPE=TEXT%3ALISTYEAR=2012MONTH=01FROM=0200TO=0200STNM=16044 Some help? thanks Alberto Full query, with parameter: With ActiveSheet.QueryTables.Add(Connection:= _ URL;http://wwwold.meteoam.it/modules/DCP/infoStazione.php? locality=16409TypeMsg=SynopData=2012-01-01%2015:00:00, _ Destination:=Range(B2)) .TablesOnlyFromHTML = False .FieldNames = True .RowNumbers = False .FillAdjacentFormulas = False .PreserveFormatting = False .RefreshOnFileOpen = False .BackgroundQuery = True .RefreshStyle = xlOverwriteCell .SavePassword = False .SaveData = True .AdjustColumnWidth = False .RefreshPeriod = 0 .WebSelectionType = xlSpecifiedTables .WebFormatting = xlWebFormattingNone .WebTables = 4 .WebPreFormattedTextToColumns = True .WebConsecutiveDelimitersAsOne = True .WebSingleBlockTextImport = False .WebDisableDateRecognition = False .WebDisableRedirections = False .Refresh BackgroundQuery:=False End With -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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 WebFetchWeatherData.xls Description: MS-Excel spreadsheet
Re: $$Excel-Macros$$ Query on dd-mm mm-yy format
Thanks Sam, I think my problem is solved. Regards, Suyog On Wed, Nov 16, 2011 at 12:01 AM, Sam Mathai Chacko samde...@gmail.comwrote: =IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23) Regards, Sam Mathai Chacko On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni suyog.kulka...@yahoo.comwrote: Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.com wrote: Dear Suyog, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni suyog.kulka...@yahoo.com wrote: Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of Ft-In format in mm-dd-yy or mm-yy format. Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows 10/11/11. Somehow I need to keep all length either in text format or in Ft-inch format. I'm not importing file into excel so I can't fix the text type for particular column. Manual edition will be tedious as there are more than 75 pages (Each have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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 -- Suyog Kulkarni Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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
Re: $$Excel-Macros$$ Query on dd-mm mm-yy format
Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Suyog, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni suyog.kulka...@yahoo.com wrote: Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of Ft-In format in mm-dd-yy or mm-yy format. Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows 10/11/11. Somehow I need to keep all length either in text format or in Ft-inch format. I'm not importing file into excel so I can't fix the text type for particular column. Manual edition will be tedious as there are more than 75 pages (Each have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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 -- Suyog Kulkarni Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ 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 3042(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query on dd-mm mm-yy format
=IF(IFERROR(DATE(YEAR(G23),MONTH(G23),DAY(G23))=G23,0),MONTH(G23)-IF(DAY(G23)=1,0,DAY(G23)),G23) Regards, Sam Mathai Chacko On Tue, Nov 15, 2011 at 3:28 PM, Suyog Kulkarni suyog.kulka...@yahoo.comwrote: Hello Noorain, Thanks for quick response but I've added two problems in same excel. Please review advice. Suyog On Tue, Nov 15, 2011 at 3:14 PM, NOORAIN ANSARI noorain.ans...@gmail.comwrote: Dear Suyog, Please see attached sheet. -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/ On Tue, Nov 15, 2011 at 10:32 AM, Suyog Kulkarni suyog.kulka...@yahoo.com wrote: Hello Friends, Find attached excel file for ref. I'm using one software which list out required material for structure in excel. Output of that excel file converts some length of Ft-In format in mm-dd-yy or mm-yy format. Ex: For Length 10-11, excel shows Nov-11 For length 11-10, excel shows 10/11/11. Somehow I need to keep all length either in text format or in Ft-inch format. I'm not importing file into excel so I can't fix the text type for particular column. Manual edition will be tedious as there are more than 75 pages (Each have more than 1000 rows), If anybody can suggest any easy way to save time. Thanks regards, -- *Suyog Kulkarni* Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- FORUM RULES (934+ 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 -- Suyog Kulkarni Mailto:-suyog.kulka...@yahoo.com suyog.kulka...@hotmail.com Ph:-( +91 ) 9890123539 -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Cross-promotion of, or links to, forums competitive to this forum in signatures are prohibited. NOTE : Don't ever post personal or confidential data in a workbook. Forum owners and members are not responsible for any loss. -- To post to this group, send email to excel-macros@googlegroups.com -- Sam Mathai Chacko -- FORUM RULES (934+ 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.
Re: $$Excel-Macros$$ Query related to subtotal and condition
Dear Mr. Modi, Attached is the soln. pl chk if this is ok. Regards, Andy On Sat, Nov 12, 2011 at 12:09 PM, L.K. Modi ca.mod...@gmail.com wrote: Dear All members, I am attaching herewith a file regarding tds and the requirement is mention in that file related to subtotal and conditions. Please solve my problem . Thanks to all in advance Regards LKModi 9309243685 -- FORUM RULES (934+ 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 -- Warm Regards, Aindril De Ph: 9811300157 -- FORUM RULES (934+ 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 TDS 2011-12-Modi.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query regarding serial no.
HI Ankit, Find the attachment. On Tue, Oct 25, 2011 at 9:42 AM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear Expert, Plz solve out attached query. Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Solved by Maries_25.10.2011.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query regarding serial no.
Dear Ankit, Please try below formula... =LIQ/EE/INV/1112/SUMPRODUCT(--($C$5:C5=C5)) =LIQ/EE/INV/1112/COUNTIF($C$5:C5,C5) -- Thanks regards, Noorain Ansari *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/ *http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/ On Tue, Oct 25, 2011 at 11:12 AM, Ankit Agrawal ankit.agrawal...@gmail.comwrote: Dear Expert, Plz solve out attached query. Regards, Ankit -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel Query Regarding Control Sheet(Solved).xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Query
SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,) On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote: dear members, can any one solve my query with help of formula, i am very poor in MS excel. find the attachement, reply at the earliest. Thanks in advance, have a nice day. -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
Thanks a lot dear On 28 July 2011 18:32, ashish koul koul.ash...@gmail.com wrote: SUBSTITUTE(F1TEXT(G1,ddmmyyy), ,) On Thu, Jul 28, 2011 at 5:13 PM, Hari harisha.prabha...@gmail.com wrote: dear members, can any one solve my query with help of formula, i am very poor in MS excel. find the attachement, reply at the earliest. Thanks in advance, have a nice day. -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ http://akoul.posterous.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- Yours, Hari. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
=*LOOKUP* (D16,{3001,5001,6001,7001,8001,9001,15001,25001,40001},{30,40,45,50,60,110,130,150,200}) or.. =*VLOOKUP*(D16,$A$1:$B$9,2,TRUE) the above VLookUp fungtion refers to a table *tabel A1:B9* * 3001 30 * * 5001 40 * * 6001 45 * * 7001 50* * 8001 60* * 9001 110* *15001 130* *25001 150* *40001 200 * On Wed, Jul 6, 2011 at 6:26 PM, Kal xcel kalx...@gmail.com wrote: Dear Experts, For this chart 3001-5000 = 30 5001-6000 = 40 6001-7000 = 45 7001-8000 = 50 8001-9000 = 50 9001-15000 = 110 15001-25000 = 130 25001-4 = 150 40001= = 200 I use this formula: =IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001,D16=7000),45,IF(AND(D16=7001,D16=8000),50,IF(AND(D16=8001,D16=9000),90,IF(AND(D16=9001,D16=15000),110,IF(AND(D16=15001,D16=25000),130,IF(AND(D16=25001,D16=4),150,IF(AND(D16=40001),200,0) Is their any other short/intelligent way to get desired result? Please help Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel LOOKUP and VLOOUP (1_2_3_TRUE).xls Description: MS-Excel spreadsheet
RE: $$Excel-Macros$$ Query
You can use Vlookup formula as shown in attachment. Regards, Modh From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Kal xcel Sent: Wednesday, July 06, 2011 4:56 PM To: excel-macros@googlegroups.com Cc: Dave Bonallack; NOORAIN ANSARI; Ashish Koul Subject: $$Excel-Macros$$ Query Dear Experts, For this chart 3001-5000 = 30 5001-6000 = 40 6001-7000 = 45 7001-8000 = 50 8001-9000 = 50 9001-15000 = 110 15001-25000 = 130 25001-4 = 150 40001= =200 I use this formula: =IF(AND(D16=3001,D16=5000),30,IF(AND(D16=5001,D16=6000),40,IF(AND(D16=6001,D16=7000),45,IF(AND(D16=7001,D16=8000),50,IF(AND(D16=8001,D16=9000),90,IF(AND(D16=9001,D16=15000),110,IF(AND(D16=15001,D16=25000),130,IF(AND(D16=25001,D16=4),150,IF(AND(D16=40001),200,0) Is their any other short/intelligent way to get desired result? Please help Thanks in advance Kalyan -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.commailto:excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel This message has been scanned for viruses by ForeFront Online Protection -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel vlookup.xlsx Description: vlookup.xlsx
Re: $$Excel-Macros$$ Query: Seprate Row after every Semicolonq
Ww NOORAIN ANSARI noorain.ans...@gmail.com escreveu: Dear Experts.. Please find attached query sheet...I want to add a seperate row after every semicolon.. Please see attached sheet.. -- Thanks regards, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query: Seprate Row after every Semicolonq
There is no attachment On Thu, Feb 24, 2011 at 6:33 PM, Joao Matoso jcmat...@gmail.com wrote: Ww NOORAIN ANSARI noorain.ans...@gmail.com escreveu: Dear Experts.. Please find attached query sheet...I want to add a seperate row after every semicolon.. Please see attached sheet.. -- Thanks regards, Noorain Ansari -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
Thanks Ashish, Its nice, please explain how this formula is working On Thu, Feb 17, 2011 at 5:29 AM, ashish koul koul.ash...@gmail.com wrote: IF(MAX(SUMIFS(C:C,A:A,A4,B:B,Doubtful),SUMIFS(C:C,A:A,A4,B:B,Regular),SUMIFS(C:C,A:A,A4,B:B,Loss),SUMIFS(C:C,A:A,A4,B:B,Substandard))=SUMIFS(C:C,A:A,A4,B:B,Doubtful),Doubtful,IF(MAX(SUMIFS(C:C,A:A,A4,B:B,Doubtful),SUMIFS(C:C,A:A,A4,B:B,Regular),SUMIFS(C:C,A:A,A4,B:B,Loss),SUMIFS(C:C,A:A,A4,B:B,Substandard))=SUMIFS(C:C,A:A,A4,B:B,Loss),Loss,IF(MAX(SUMIFS(C:C,A:A,A4,B:B,Doubtful),SUMIFS(C:C,A:A,A4,B:B,Regular),SUMIFS(C:C,A:A,A4,B:B,Loss),SUMIFS(C:C,A:A,A4,B:B,Substandard))=SUMIFS(C:C,A:A,A4,B:B,Substandard),Substandard,Regular))) type this in e4 On Wed, Feb 16, 2011 at 9:59 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Maximum 4 classifications 1) Regular 2) Substandard 3) Doubtful 4) Loss On Tue, Feb 15, 2011 at 8:34 PM, ashish koul koul.ash...@gmail.comwrote: will it be these three classifications only On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.com wrote: Thanks *Ashish *for reply but can you please provide formula without pivot. Condition you have understand that if sum of any classification is grater then others,it shows that value. On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.comwrote: On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profilehttp://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks
Re: $$Excel-Macros$$ Query
Maximum 4 classifications 1) Regular 2) Substandard 3) Doubtful 4) Loss On Tue, Feb 15, 2011 at 8:34 PM, ashish koul koul.ash...@gmail.com wrote: will it be these three classifications only On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Thanks *Ashish *for reply but can you please provide formula without pivot. Condition you have understand that if sum of any classification is grater then others,it shows that value. On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.comwrote: On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
IF(MAX(SUMIFS(C:C,A:A,A4,B:B,Doubtful),SUMIFS(C:C,A:A,A4,B:B,Regular),SUMIFS(C:C,A:A,A4,B:B,Loss),SUMIFS(C:C,A:A,A4,B:B,Substandard))=SUMIFS(C:C,A:A,A4,B:B,Doubtful),Doubtful,IF(MAX(SUMIFS(C:C,A:A,A4,B:B,Doubtful),SUMIFS(C:C,A:A,A4,B:B,Regular),SUMIFS(C:C,A:A,A4,B:B,Loss),SUMIFS(C:C,A:A,A4,B:B,Substandard))=SUMIFS(C:C,A:A,A4,B:B,Loss),Loss,IF(MAX(SUMIFS(C:C,A:A,A4,B:B,Doubtful),SUMIFS(C:C,A:A,A4,B:B,Regular),SUMIFS(C:C,A:A,A4,B:B,Loss),SUMIFS(C:C,A:A,A4,B:B,Substandard))=SUMIFS(C:C,A:A,A4,B:B,Substandard),Substandard,Regular))) type this in e4 On Wed, Feb 16, 2011 at 9:59 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Maximum 4 classifications 1) Regular 2) Substandard 3) Doubtful 4) Loss On Tue, Feb 15, 2011 at 8:34 PM, ashish koul koul.ash...@gmail.comwrote: will it be these three classifications only On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Thanks *Ashish *for reply but can you please provide formula without pivot. Condition you have understand that if sum of any classification is grater then others,it shows that value. On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.comwrote: On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow
Re: $$Excel-Macros$$ Query
Thanks *Ashish *for reply but can you please provide formula without pivot. Condition you have understand that if sum of any classification is grater then others,it shows that value. On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.com wrote: On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
will it be these three classifications only On Tue, Feb 15, 2011 at 8:35 PM, Aamir Shahzad aamirshahza...@gmail.comwrote: Thanks *Ashish *for reply but can you please provide formula without pivot. Condition you have understand that if sum of any classification is grater then others,it shows that value. On Tue, Feb 15, 2011 at 8:14 AM, ashish koul koul.ash...@gmail.comwrote: On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.com wrote: Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
Re: $$Excel-Macros$$ Query
On Tue, Feb 15, 2011 at 12:16 AM, Aamir Shahzad aamirshahza...@gmail.comwrote: Hi all experts, Please resolve my query by formula. sheet attached. Regards, Aamir Shahzad -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- *Regards* * * *Ashish Koul* *akoul*.*blogspot*.com http://akoul.blogspot.com/ *akoul*.wordpress.com http://akoul.wordpress.com/ My Linkedin Profile http://in.linkedin.com/pub/ashish-koul/10/400/830 P Before printing, think about the environment. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel amir.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ query for a solution
Hi Thamu, I don't know what is the need for the comparison of 2003 2007 excel column versions since the query is not very much related to the 2003 column issue. I agree that the column will be the issue in Excel 2003 when the repetition of UNIQUE IDNO goes beyond 127 times then we could not able to get the data of Bill No Amount in the continues columns because of the insufficient column space in Excel 2003, DescriptionRequired Columns Repetition Total Column UNIQUE IDNO -1 Column (Column A) 11 Bill No Amount -2 Columns127 (127 x 2 = 254) 254 -- Total 255 -- I hope the above data has given you the clear picture and have a look in the solution provided to the OP for the query. I request all of you don't take my SUGGESTIONS as CRITICISM I would like to add some more points to your post and make your knowledge get enriched. At the same time anyone find any error or anything better than my solution and I request you to keep me informed, so that I can also get learned from you. Thanks! --- Ms.Exl.Learner --- On Thu, Jan 27, 2011 at 4:59 PM, TG T viper@gmail.com wrote: Dear Ankur Pandey You cannot able to keep it in a single row If you have large amount of data. Because Excel 2003 has only 256 columns and excel 2007 has only 16384 columns. Thanks Regards Thamu On Thu, Jan 27, 2011 at 2:55 PM, ankur ankurpande...@gmail.com wrote: hi excel experts i need one help i need data in format like this unique id all bill no. coloumn wise all their respective amount all bill no. and their respective amount shoul come in single row. the data is attached with this mail..sheet 2 has format needed also urgent need -- Have A Nice Time Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel -- --- Ms.Exl.Learner --- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel