$$Excel-Macros$$ Re: Doubt in Duplicates
so do you want to remove duplicates ? On Wednesday, 30 April 2014 11:27:23 UTC+5:30, pappu wrote: Dear Friends, Please find the attached file of excel, I have a doubt in that excel. I checked the excel there is no formula and VBA coding but it is showing duplicates. How to do this in other excel... Please help me -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Doubt in Duplicates
HI Kannan, There is In-build option in excel to show the duplicates. Please find the below steps. Home-conditional formatting-highlight cells rules-Duplicate value (you can create whatever format u want to show the duplicate values) Thanks Regards, Ganesh N On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel kannan.ex...@gmail.comwrote: Dear Friends, Please find the attached file of excel, I have a doubt in that excel. I checked the excel there is no formula and VBA coding but it is showing duplicates. How to do this in other excel... Please help me -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Doubt in Duplicates
Dear Ganesh, Thank you... Now i understood... On Wed, Apr 30, 2014 at 11:33 AM, Ganesh N ganeshg...@gmail.com wrote: HI Kannan, There is In-build option in excel to show the duplicates. Please find the below steps. Home-conditional formatting-highlight cells rules-Duplicate value (you can create whatever format u want to show the duplicate values) Thanks Regards, Ganesh N On Wed, Apr 30, 2014 at 11:27 AM, Kannan Excel kannan.ex...@gmail.comwrote: Dear Friends, Please find the attached file of excel, I have a doubt in that excel. I checked the excel there is no formula and VBA coding but it is showing duplicates. How to do this in other excel... Please help me -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ please help for consolidate in excel
Dear Ganesh Ravinder, I am also have this issue. I saw your attachments, i don't know how to use this... Kindly give a brief explanation. On Sun, Apr 27, 2014 at 11:48 AM, Ganesh N ganeshg...@gmail.com wrote: Hi Yadav, you can also use this. Just put the data files in separate folder and put the path in cell J2. Thanks Regards, Ganesh N On Sun, Apr 27, 2014 at 11:16 AM, Vaibhav Joshi v...@vabs.in wrote: Hi, You can try this excellent codes share by Ashish earlier this month: Sub merge() Dim fld As Object, fil As Object, fso As Object, fldpath With Application.FileDialog(msoFileDialogFolderPicker) .Title = Choose the folder .Show End With On Error Resume Next fldpath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If fldpath = False Then MsgBox Folder Not Selected Exit Sub End If Set fso = CreateObject(scripting.filesystemobject) Set fld = fso.getfolder(fldpath) Application.DisplayAlerts = False Application.ScreenUpdating = False For Each fil In fld.Files If Right(fil.Name, 4) = .xls And fil.Name ThisWorkbook.Name Then Call import_data(fil.Path) Next Application.DisplayAlerts = True Application.ScreenUpdating = True End Sub Sub import_data(filename As String) Dim wkb As Workbook Dim lastrow As Long lastrow = ThisWorkbook.Sheets(Sheet1).Range(a65356).End(xlUp).Row + 1 Set wkb = Workbooks.Open(filename) wkb.Sheets(Summary Sheet).Range(e2:j2).Copy Destination:=ThisWorkbook.Sheets(Sheet1).Range(a lastrow) wkb.Sheets(Summary Sheet).Range(b13:f13).Copy Destination:=ThisWorkbook.Sheets(Sheet1).Range(g lastrow) wkb.Close End Sub Thanks On Sun, Apr 27, 2014 at 9:44 AM, Jitendra Yadav jitendr...@gmail.comwrote: Hi All, I have some data for date wise but I want all excel file in one sheet through macro. Example. Regards, Jitendra//9650449202 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It's =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions
Re: $$Excel-Macros$$ Vlookup get numbers from different table
Dear Vabs Brother Its really cool formula which you have sent me… There was a glow in my face Thanks very very muchfor helping excel enthusiasts voluntarily !! Regards Amar On Tue, Apr 29, 2014 at 8:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, PFA Cheers!! On Tue, Apr 29, 2014 at 5:01 PM, amar takale amartak...@gmail.com wrote: Dear friends I required output through vlookup from different table but it is possible only for one table.How to get all numbers from each table with data validation.PFA sheet. Pls suggest me any idea or other formula. Thanks Amar -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
Dear Sir thanks alot... i have a one doubt i.e my client places they are using Lotus note we are used to send this dashboard to my client place is this macro would be work on that place. please suggest. On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote: Hi You can do so by creating UDF. See UDF sheet. Thanks On Wed, Apr 30, 2014 at 12:08 AM, renuka chari jva@gmail.comjavascript: wrote: Dear Sir, countif function creating more violation for huge data range. is there any possible to overcome or use any other function. please guide me... thanks... On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote: Dear sir, thank you so much.your given a great help.. On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote: Hi PFA alternate method using formula help sheet. Thanks On Tue, Apr 29, 2014 at 8:57 PM, renuka chari jva@gmail.comwrote: Dear sir, Thank you so much for your time and effort into problem. my dashboard having huge no of sheets and if i make pivot sheet then my workbook size is increasing more i was applied your formula earlier itself. but i need even better solution. and my dash board data range is not constant if this data set count increase or decrease on daily basis. that scenario every time we are going to apply refresh or expand data option for PIVOT it is time consuming process so kindly think even better output for this problem.. On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote: Its not possible to do without any help column. Another way out is shown in attached file. Ref col E F. Thx On Tue, Apr 29, 2014 at 2:34 PM, renuka chari jva@gmail.comwrote: Dear sir, i dont want to use pivot. i need only formula for offset or index is it possible... On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote: Hi You can do using Pivot Table, see attached file. 1. In the Pivot Table, click the drop down arrow in the RowLabels field heading. 2. In the pop-up menu, click Value Filters, then click Top 10 change it to 5. You can sort on Descending on Output by going thru More Sort option under filter Cheers! On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee jva@gmail.com wrote: Dear experts, please help me Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪ P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources. -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to
Re: $$Excel-Macros$$ Vlookup get numbers from different table
Dear Vabs, Super ... On Wednesday, 30 April 2014 12:23:46 UTC+5:30, amar takale wrote: Dear Vabs Brother Its really cool formula which you have sent me… There was a glow in my face Thanks very very muchfor helping excel enthusiasts voluntarily !! Regards Amar On Tue, Apr 29, 2014 at 8:56 PM, Vaibhav Joshi v...@vabs.in javascript: wrote: Hi, PFA Cheers!! On Tue, Apr 29, 2014 at 5:01 PM, amar takale amart...@gmail.comjavascript: wrote: Dear friends I required output through vlookup from different table but it is possible only for one table.How to get all numbers from each table with data validation.PFA sheet. Pls suggest me any idea or other formula. Thanks Amar -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript:. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders
Hello All, I am using Excel 2010 and have the following problem. I need a macro to look for x in Columns J to AX (Sample File Attached). If it finds x then it should go to the Folder “C:\Test\Macro” which contains the Folder names shown in J3 to AX3. It should open the file inside the respective Folders 1, 2, 3….etc and paste the values No1 to No5 shown in Cells A3, C3, E3, F3 H3 (see various possibility shown here). No1-No2-No3-No4-No5 No1-No2-No3 No1-No2-No3-No4 It should be concatenated with a hyphen. If any No is blank then it should not be concatenated (See Output Sheet on the sample file attached) Thanks in advance Rashid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Copy data problem for google groups.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
$$Excel-Macros$$ Value need to update as per master (excel sheet Attached)
Dear Team, Please advice on below query. I have one target% and as per target% value need to change. For example if my target% is 12.50 then next Coolum need to fill as per my target% just like 15.00 Attached excel sheet. if target % Need to take as per Target % 12.50 15.00 67.90 69.00 18.40 19.00 20.00 22.00 22.20 25.00 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Book3.xlsx Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Re: $$Excel-Macros$$ Vlookup get numbers from different table
Dear Vabs I have just idea for this issue but i dont know it is work or not.If we give name range each table then formula like = name range match then vlookup search that value into that specific table only. how to write formula as per my idea OR it is possible? Regards Amar On Wed, Apr 30, 2014 at 5:28 PM, renuka chari jva.ch...@gmail.com wrote: Dear Vabs, Super ... On Wednesday, 30 April 2014 12:23:46 UTC+5:30, amar takale wrote: Dear Vabs Brother Its really cool formula which you have sent me… There was a glow in my face Thanks very very muchfor helping excel enthusiasts voluntarily !! Regards Amar On Tue, Apr 29, 2014 at 8:56 PM, Vaibhav Joshi v...@vabs.in wrote: Hi, PFA Cheers!! On Tue, Apr 29, 2014 at 5:01 PM, amar takale amart...@gmail.com wrote: Dear friends I required output through vlookup from different table but it is possible only for one table.How to get all numbers from each table with data validation.PFA sheet. Pls suggest me any idea or other formula. Thanks Amar -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook
Re: $$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders
Do you know how to write macros and are asking for help? or are you asking for someone to write the macro? 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: Rashid Khan prkha...@gmail.com To: excel-macros excel-macros@googlegroups.com Sent: Wednesday, April 30, 2014 8:05 AM Subject: $$Excel-Macros$$ Macro to look for x in Columns and paste data in worksheet in various folders Hello All, I am using Excel 2010 and have the following problem. I need a macro to look for x in Columns J to AX (Sample File Attached). If it finds x then it should go to the Folder “C:\Test\Macro” which contains the Folder names shown in J3 to AX3. It should open the file inside the respective Folders 1, 2, 3….etc and paste the values No1 to No5 shown in Cells A3, C3, E3, F3 H3 (see various possibility shown here). No1-No2-No3-No4-No5 No1-No2-No3 No1-No2-No3-No4 It should be concatenated with a hyphen. If any No is blank then it should not be concatenated (See Output Sheet on the sample file attached) Thanks in advance Rashid -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Value need to update as per master (excel sheet Attached)
pls clear ur query On Wed, Apr 30, 2014 at 5:32 AM, rameshwari shyam rameshwarish...@gmail.com wrote: Dear Team, Please advice on below query. I have one target% and as per target% value need to change. For example if my target% is 12.50 then next Coolum need to fill as per my target% just like 15.00 Attached excel sheet. if target % Need to take as per Target % 12.50 15.00 67.90 69.00 18.40 19.00 20.00 22.00 22.20 25.00 -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ Re: VBA Macro for data split as per the specified format
kindly apologise for late response. Dear kapil gupta, here i didn't set any password for the code. please check. dear ashish, please check the image in the earlier post on that i was run the code yellow color marking record would not reflect in the T1 sheet and T2 Sheet. please check and confirm.. On Monday, 21 April 2014 16:39:40 UTC+5:30, kapil Gupta wrote: But what is the password in this code. Please reply On Saturday, March 22, 2014 7:03:12 PM UTC+5:30, renuka chari wrote: Dear Deepak, thanks for your great help... it would be working so great... but i was found a small problem from Output 2 here i am getting positive values twice and for output 1 and 2 negative value font colour must be in red colour kindly check this once and revert... thanks once again for your great help.. On Saturday, 22 March 2014 14:57:33 UTC+5:30, Deepak Pal Singh wrote: Try this one.. On Sat, Mar 22, 2014 at 1:33 PM, Renukachari Kasee jva@gmail.comwrote: Ashish Sir, your macro was working very good for specified criteria. i need one more criteria too i.e groups does not have any blank rows that time also it would be split as same. for example please check the workbook (¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪ P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources. On 22 March 2014 00:09, Renukachari Kasee jva@gmail.com wrote: Dear experts, please provide the vba macro for attached excel sheet format split into separate sheets those formats are mentioned in the excel kindly do the needful thanks alot. -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards, *Deepak Kumar** (Analyst Automation Expert) Contact: +91-399977* ……... *It's Never Too Late To Follow Your Dreams* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon
Please share your cv Regards Ashish Koul On Friday, 28 October 2011 21:36:28 UTC+5:30, Ayush Jain wrote: Dear members, EY(Gurgaon) looking out for VBA professionals with 1-2 years of experience. Refer your friends and send me resume @ jaina...@gmail.com javascript:. Please do not post any resume in forum and send it to me only. Thanks. -- Best regards, Ayush Jain -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ VBA Compare only visible rows
Hey everyone and thanks in advance for any help. I have a fairly simple macro, that worked wonders in my tiny test set, but is slogging along at an incredibly slow pace when I set it to run it's full scale application. The 'Cull_List' worksheet has already been filtered down somewhat from it's initial 1500 or so rows through a separate Macro, and the 'Static Pool Details' worksheet has been as well, but I'd love to figure out a way to have the compare only look at visible rows in each worksheet as it works through the compare. Thanks again for any help. And for the record, I program in VBA about once every 12 to 18 months, promptly forget everything I learned, and then have to try to struggle through it again the next time. So please assume that what I know would have trouble powering an ant's motorcycle around a bb. Ben Here's the code I'm working with Sub Check_Static() Dim CompareRange As Variant, x As Variant, y As Variant Set culllist = Worksheets(Cull_List).Range(a5:a1500) Set CompareRange = Worksheets(Static Pool Details).Range(a5:a1000) For Each x In culllist For Each y In CompareRange If x = y Then x.Select Selection.EntireRow.Hidden = True Next y Next x End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
Re: $$Excel-Macros$$ VBA Compare only visible rows
Hi Benjamin Can you please let us know are all your values unique? - Yes the values are unique. It's a list of invoice numbers. The first is a master list that has been culled to remove a certain group of clients. The second set is a list of clients that we've had difficulties with. The compare is designed to remove this second set of clients from the master list as well. Leaving me a new list of a certain grouping of clients. The reason I'm hiding instead of deleting is because the individual working with the new list won't always have access to the master list, and I'd like them to have the information available. Do you want to compare the same row nos or cell. Numbers ? - The idea is that if your invoice appears in the second set, I'd like to pull you from the master list as well. They are both in Column A of their respective worksheets Reason I m asking is if the values r unique and it is found you can use exit for as soon as condtion is met - That would be an excellent addition, but It would still be great to eliminate all the hidden rows from the compare. Also is it possible for you to share a sample file with dummy data - I've attached my tiny test file, but unfortunately due to sensitive information I can't attach the large master list. Hope this helps clarify for you. Ben Regards Ashish koul On Wednesday, April 30, 2014 11:56:06 AM UTC-7, ashish wrote: Hi Benjamin Can you please let us know are all your values unique? Do you want to compare the same row nos or cell. Numbers ? Reason I m asking is if the values r unique and it is found you can use exit for as soon as condtion is met Also is it possible for you to share a sample file with dummy data Regards Ashish koul Sent on my BlackBerry® from Vodafone -- *From: * Benjamin Gilberg gilberg@gmail.com javascript: *Sender: * excel-...@googlegroups.com javascript: *Date: *Wed, 30 Apr 2014 11:49:43 -0700 (PDT) *To: *excel-...@googlegroups.com javascript: *ReplyTo: * excel-...@googlegroups.com javascript: *Subject: *$$Excel-Macros$$ VBA Compare only visible rows Hey everyone and thanks in advance for any help. I have a fairly simple macro, that worked wonders in my tiny test set, but is slogging along at an incredibly slow pace when I set it to run it's full scale application. The 'Cull_List' worksheet has already been filtered down somewhat from it's initial 1500 or so rows through a separate Macro, and the 'Static Pool Details' worksheet has been as well, but I'd love to figure out a way to have the compare only look at visible rows in each worksheet as it works through the compare. Thanks again for any help. And for the record, I program in VBA about once every 12 to 18 months, promptly forget everything I learned, and then have to try to struggle through it again the next time. So please assume that what I know would have trouble powering an ant's motorcycle around a bb. Ben Here's the code I'm working with Sub Check_Static() Dim CompareRange As Variant, x As Variant, y As Variant Set culllist = Worksheets(Cull_List).Range(a5:a1500) Set CompareRange = Worksheets(Static Pool Details).Range(a5:a1000) For Each x In culllist For Each y In CompareRange If x = y Then x.Select Selection.EntireRow.Hidden = True Next y Next x End Sub -- 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...@googlegroups.com javascript:. To post to this group, send email to excel-...@googlegroups.comjavascript: . Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise,
$$Excel-Macros$$ Re: VBA Job @ Ernst and Young , Gurgaon
Hi, I am sending my resume. Kindly enclose the attached resume files and please forward. On Wednesday, April 30, 2014 11:35:23 PM UTC+5:30, ashish wrote: Please share your cv Regards Ashish Koul On Friday, 28 October 2011 21:36:28 UTC+5:30, Ayush Jain wrote: Dear members, EY(Gurgaon) looking out for VBA professionals with 1-2 years of experience. Refer your friends and send me resume @ jaina...@gmail.com. Please do not post any resume in forum and send it to me only. Thanks. -- Best regards, Ayush Jain -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Kapil Gupta _ Resume.docx Description: application/vnd.openxmlformats-officedocument.wordprocessingml.document
Re: $$Excel-Macros$$ Re: VBA Macro for data split as per the specified format
HI Renuka, No problem and no need to apologise with me. Actually i am trying to open example one sheet view code but there is requiring the password. Please if can possible to share the password with me. Thanks, Kapil Gupta On Wednesday, April 30, 2014 8:32:07 PM UTC+5:30, renuka chari wrote: kindly apologise for late response. Dear kapil gupta, here i didn't set any password for the code. please check. dear ashish, please check the image in the earlier post on that i was run the code yellow color marking record would not reflect in the T1 sheet and T2 Sheet. please check and confirm.. On Monday, 21 April 2014 16:39:40 UTC+5:30, kapil Gupta wrote: But what is the password in this code. Please reply On Saturday, March 22, 2014 7:03:12 PM UTC+5:30, renuka chari wrote: Dear Deepak, thanks for your great help... it would be working so great... but i was found a small problem from Output 2 here i am getting positive values twice and for output 1 and 2 negative value font colour must be in red colour kindly check this once and revert... thanks once again for your great help.. On Saturday, 22 March 2014 14:57:33 UTC+5:30, Deepak Pal Singh wrote: Try this one.. On Sat, Mar 22, 2014 at 1:33 PM, Renukachari Kasee jva@gmail.comwrote: Ashish Sir, your macro was working very good for specified criteria. i need one more criteria too i.e groups does not have any blank rows that time also it would be split as same. for example please check the workbook (¨`•.•´¨) Always `•.¸(¨`•.•´¨) Keep (¨`•.•´¨)¸.•´ Smiling!! `•.¸.•´ Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪ P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources. On 22 March 2014 00:09, Renukachari Kasee jva@gmail.com wrote: Dear experts, please provide the vba macro for attached excel sheet format split into separate sheets those formats are mentioned in the excel kindly do the needful thanks alot. -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Regards, *Deepak Kumar** (Analyst Automation Expert) Contact: +91-399977* ……... *It's Never Too Late To Follow Your Dreams* -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout.
$$Excel-Macros$$ Unique name requirement without use advance filter in macro
Hi, Please Unique name requirement using macro but without using advance filter. Regards, Kapil Gupta -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. Unique Name Requirement.xlsm Description: application/vnd.ms-excel.sheet.macroenabled.12
Re: $$Excel-Macros$$ Re: VBA Compare only visible rows
Sub macros_sample() Dim baserange As Range Dim cl As Range Set baserange = Sheets(Sheet1).Range(a2:a2500).SpecialCells(xlCellTypeVisible) Application.EnableEvents = False Application.Calculation = xlCalculationManual For Each cl In baserange If cl.Value Then If Application.WorksheetFunction.CountIf(Sheets(Sheet2).Range(a:A), cl.Value) = 1 Then cl.EntireRow.Hidden = True End If End If Next Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic End Sub On Thu, May 1, 2014 at 4:26 AM, Benjamin Gilberg gilberg.benja...@gmail.com wrote: I think I've taken a half step forward. But now I'm locked in a circular argument with Excel. It keeps telling me I have a next without a for. If I remove the offending next it tells me I have a for without a next. Here's where I am now: Sub Check_Static() Dim CompareRange As Variant, x As Variant, y As Variant Set culllist = Worksheets(Cull_List).Range(a5:a1500) Set CompareRange = Worksheets(Static_Cull).Range(a5:a600) For Each x In culllist If whateverrow.Hidden = False Then For Each y In CompareRange If whateverrow.Hidden = False Then If x = y Then x.Select Selection.EntireRow.Hidden = True End If Next y End If Next x End Sub On Wednesday, April 30, 2014 11:49:43 AM UTC-7, Benjamin Gilberg wrote: Hey everyone and thanks in advance for any help. I have a fairly simple macro, that worked wonders in my tiny test set, but is slogging along at an incredibly slow pace when I set it to run it's full scale application. The 'Cull_List' worksheet has already been filtered down somewhat from it's initial 1500 or so rows through a separate Macro, and the 'Static Pool Details' worksheet has been as well, but I'd love to figure out a way to have the compare only look at visible rows in each worksheet as it works through the compare. Thanks again for any help. And for the record, I program in VBA about once every 12 to 18 months, promptly forget everything I learned, and then have to try to struggle through it again the next time. So please assume that what I know would have trouble powering an ant's motorcycle around a bb. Ben Here's the code I'm working with Sub Check_Static() Dim CompareRange As Variant, x As Variant, y As Variant Set culllist = Worksheets(Cull_List).Range(a5:a1500) Set CompareRange = Worksheets(Static Pool Details).Range(a5:a1000) For Each x In culllist For Each y In CompareRange If x = y Then x.Select Selection.EntireRow.Hidden = True Next y Next x End Sub -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to excel-macros+unsubscr...@googlegroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- *Regards* *Ashish Koul* *Visit* http://www.excelvbamacros.in Like Us on Facebook https://www.facebook.com/excelvbacodes Join Us on Facebook http://www.facebook.com/groups/163491717053198/ P Before printing, think about the environment. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post
Re: $$Excel-Macros$$ VBA Compare only visible rows
Sub macros_sample() Dim baserange As Range Dim cl As Range Set baserange = Sheets(Sheet1).Range(a2:a2500).SpecialCells(xlCellTypeVisible) Application.EnableEvents = False Application.Calculation = xlCalculationManual For Each cl In baserange If cl.Value Then If Application.WorksheetFunction.CountIf(Sheets(Sheet2).Range(a:A), cl.Value) = 1 Then cl.EntireRow.Hidden = True End If End If Next Application.EnableEvents = True Application.Calculation = xlCalculationAutomatic End Sub On Thu, May 1, 2014 at 12:55 AM, Benjamin Gilberg gilberg.benja...@gmail.com wrote: Hi Benjamin Can you please let us know are all your values unique? - Yes the values are unique. It's a list of invoice numbers. The first is a master list that has been culled to remove a certain group of clients. The second set is a list of clients that we've had difficulties with. The compare is designed to remove this second set of clients from the master list as well. Leaving me a new list of a certain grouping of clients. The reason I'm hiding instead of deleting is because the individual working with the new list won't always have access to the master list, and I'd like them to have the information available. Do you want to compare the same row nos or cell. Numbers ? - The idea is that if your invoice appears in the second set, I'd like to pull you from the master list as well. They are both in Column A of their respective worksheets Reason I m asking is if the values r unique and it is found you can use exit for as soon as condtion is met - That would be an excellent addition, but It would still be great to eliminate all the hidden rows from the compare. Also is it possible for you to share a sample file with dummy data - I've attached my tiny test file, but unfortunately due to sensitive information I can't attach the large master list. Hope this helps clarify for you. Ben Regards Ashish koul On Wednesday, April 30, 2014 11:56:06 AM UTC-7, ashish wrote: Hi Benjamin Can you please let us know are all your values unique? Do you want to compare the same row nos or cell. Numbers ? Reason I m asking is if the values r unique and it is found you can use exit for as soon as condtion is met Also is it possible for you to share a sample file with dummy data Regards Ashish koul Sent on my BlackBerry® from Vodafone -- *From: * Benjamin Gilberg gilberg@gmail.com *Sender: * excel-...@googlegroups.com *Date: *Wed, 30 Apr 2014 11:49:43 -0700 (PDT) *To: *excel-...@googlegroups.com *ReplyTo: * excel-...@googlegroups.com *Subject: *$$Excel-Macros$$ VBA Compare only visible rows Hey everyone and thanks in advance for any help. I have a fairly simple macro, that worked wonders in my tiny test set, but is slogging along at an incredibly slow pace when I set it to run it's full scale application. The 'Cull_List' worksheet has already been filtered down somewhat from it's initial 1500 or so rows through a separate Macro, and the 'Static Pool Details' worksheet has been as well, but I'd love to figure out a way to have the compare only look at visible rows in each worksheet as it works through the compare. Thanks again for any help. And for the record, I program in VBA about once every 12 to 18 months, promptly forget everything I learned, and then have to try to struggle through it again the next time. So please assume that what I know would have trouble powering an ant's motorcycle around a bb. Ben Here's the code I'm working with Sub Check_Static() Dim CompareRange As Variant, x As Variant, y As Variant Set culllist = Worksheets(Cull_List).Range(a5:a1500) Set CompareRange = Worksheets(Static Pool Details).Range(a5:a1000) For Each x In culllist For Each y In CompareRange If x = y Then x.Select Selection.EntireRow.Hidden = True Next y Next x End Sub -- 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
Re: $$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts
Hi I am not sure of this. Thx On Wed, Apr 30, 2014 at 3:34 PM, renuka chari jva.ch...@gmail.com wrote: Dear Sir thanks alot... i have a one doubt i.e my client places they are using Lotus note we are used to send this dashboard to my client place is this macro would be work on that place. please suggest. On Wednesday, 30 April 2014 10:41:25 UTC+5:30, Vabz wrote: Hi You can do so by creating UDF. See UDF sheet. Thanks On Wed, Apr 30, 2014 at 12:08 AM, renuka chari jva@gmail.com wrote: Dear Sir, countif function creating more violation for huge data range. is there any possible to overcome or use any other function. please guide me... thanks... On Tuesday, 29 April 2014 23:39:09 UTC+5:30, renuka chari wrote: Dear sir, thank you so much.your given a great help.. On Tuesday, 29 April 2014 22:03:02 UTC+5:30, Vabz wrote: Hi PFA alternate method using formula help sheet. Thanks On Tue, Apr 29, 2014 at 8:57 PM, renuka chari jva@gmail.comwrote: Dear sir, Thank you so much for your time and effort into problem. my dashboard having huge no of sheets and if i make pivot sheet then my workbook size is increasing more i was applied your formula earlier itself. but i need even better solution. and my dash board data range is not constant if this data set count increase or decrease on daily basis. that scenario every time we are going to apply refresh or expand data option for PIVOT it is time consuming process so kindly think even better output for this problem.. On Tuesday, 29 April 2014 17:40:26 UTC+5:30, Vabz wrote: Its not possible to do without any help column. Another way out is shown in attached file. Ref col E F. Thx On Tue, Apr 29, 2014 at 2:34 PM, renuka chari jva@gmail.comwrote: Dear sir, i dont want to use pivot. i need only formula for offset or index is it possible... On Tuesday, 29 April 2014 11:20:39 UTC+5:30, Vabz wrote: Hi You can do using Pivot Table, see attached file. 1. In the Pivot Table, click the drop down arrow in the RowLabels field heading. 2. In the pop-up menu, click Value Filters, then click Top 10 change it to 5. You can sort on Descending on Output by going thru More Sort option under filter Cheers! On Mon, Apr 28, 2014 at 10:31 PM, Renukachari Kasee jva@gmail.com wrote: Dear experts, please help me Thanks Regards´¨) ¸ •´ ¸.•*´¨) ¸.•*¨) (¸.•´ (¸.•* ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪ P Let us do our best to save nature, save water, plant trees, protect greenery, keep our surroundings clean, reduce usage of plastics, and use renewable energy sources. -- 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...@googlegroups.com. To post to this group, send email to excel-...@googlegroups.com. Visit this group at http://groups.google.com/group/excel-macros. For more options, visit https://groups.google.com/d/optout. -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get quick attention or may not be answered. 2) Don't post a question in the thread of another member. 3) Don't post questions regarding breaking or bypassing any security measure. 4) Acknowledge the responses you receive, good or bad. 5) Jobs posting is not allowed. 6) Sharing copyrighted material and their links is not allowed. NOTE : Don't ever post confidential data in a workbook. Forum owners and members are not responsible for any loss. --- You received this message because you are subscribed to the Google Groups MS EXCEL AND VBA MACROS group. To unsubscribe from this group and stop receiving emails from it, send an email to
