Re: $$Excel-Macros$$ Workbooks Consolidation Macro
For a simple solution, simply record a macro while doing it manually. From: Satish Bandaru Sent: Wednesday, August 17, 2011 1:06 AM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro hi experts please help me.plz find the atachment thanks in advance -- -- 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$$ Workbooks Consolidation Macro
Try this Code : Sub Compile() On Error GoTo Err_Clear: Application.ScreenUpdating = False Application.DisplayAlerts = False Dim Fso As New Scripting.FileSystemObject Dim Path As String Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to Pick Downloaded Bills Application.FileDialog(msoFileDialogFolderPicker).Show Path = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If Path = Then Exit Sub Application.FileDialog(msoFileDialogFolderPicker).Title = Select Folder to Save Compiled File CompilePath = Application.FileDialog(msoFileDialogFolderPicker).Show compiledPath = Application.FileDialog(msoFileDialogFolderPicker).SelectedItems(1) \ If compiledPath = Then Exit Sub Dim Counter Dim File As File Dim FOlder As FOlder Dim wb As Workbook Dim ws As Worksheet Dim AcWb As Workbook Set AcWb = ActiveWorkbook ActiveWorkbook.Sheets.Add ActiveSheet.Name = Index Set FOlder = Fso.GetFolder(Path) For Each File In FOlder.Files Counter = Counter + 1 Set wb = Workbooks.Open(Path File.Name) wb.Sheets(Index).Activate ActiveSheet.UsedRange.Copy AcWb.Sheets(Index).Activate Range(A100).End(xlUp).Select ActiveSheet.Paste Application.CutCopyMode = False wb.Close Next If Counter 0 Then AcWb.SaveAs compiledPath Compiled, xlExcel12 AcWb.Close End If Err_Clear: Err.Clear Resume Next Application.DisplayAlerts = True Application.ScreenUpdating = True If Counter 1 Then MsgBox No File Found For Compile, vbInformation Else MsgBox Counter File Has been Compiled, Please Find your File at vbCrLf compiledPath, vbInformation End If End Sub http://excelpoweruser.blogspot.com/2011/07/compiling-workbooks.html Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: Wednesday, August 17, 2011 6:48 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro For a simple solution, simply record a macro while doing it manually. From: Satish Bandaru mailto:snband...@gmail.com Sent: Wednesday, August 17, 2011 1:06 AM To: excel-macros@googlegroups.com Subject: Re: FW: $$Excel-Macros$$ Workbooks Consolidation Macro hi experts please help me.plz find the atachment thanks in advance -- -- 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$$ Workbooks Consolidation Macro
Can someone help this is really urgent. Thanks Harish On 20 July 2011 23:06, Harish Sharma harishsharma...@gmail.com wrote: Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- Kind Regards, Harish Sharma -- -- 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$$ Workbooks Consolidation Macro
Sure Harish :) .. You will have it soon.. On Thu, Jul 21, 2011 at 3:45 PM, Harish Sharma harishsharma...@gmail.comwrote: Can someone help this is really urgent. Thanks Harish On 20 July 2011 23:06, Harish Sharma harishsharma...@gmail.com wrote: Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- Kind Regards, Harish Sharma -- -- 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$$ Workbooks Consolidation Macro
Harish, I forgot to ask you one thing. The column headers in the file you attached will be constant for all the 30-35 files which are there on your sharedrive, right? Cheers, Anish On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma harishsharma...@gmail.comwrote: Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- -- 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$$ Workbooks Consolidation Macro
Hi Harsih, Since you didnt reply about column headers I assumed that it's the same for every file on share drive. Please see the attached file with macro. You must populate the file path in Sheet2-A1. Do let me know if it works fine for you. Cheers!! Anish On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava anish@gmail.comwrote: Harish, I forgot to ask you one thing. The column headers in the file you attached will be constant for all the 30-35 files which are there on your sharedrive, right? Cheers, Anish On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- -- 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 Sample_Sheet_Harish_Solved_Anish.xlsm Description: Binary data
Re: $$Excel-Macros$$ Workbooks Consolidation Macro
Harish, PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK* in that macro. Use this attachment. On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava anish@gmail.comwrote: Hi Harsih, Since you didnt reply about column headers I assumed that it's the same for every file on share drive. Please see the attached file with macro. You must populate the file path in Sheet2-A1. Do let me know if it works fine for you. Cheers!! Anish On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava anish@gmail.comwrote: Harish, I forgot to ask you one thing. The column headers in the file you attached will be constant for all the 30-35 files which are there on your sharedrive, right? Cheers, Anish On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- -- 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
Re: $$Excel-Macros$$ Workbooks Consolidation Macro
Harish, Did you try it.. ?? On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava anish@gmail.comwrote: Harish, PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in that macro. Use this attachment. On Thu, Jul 21, 2011 at 5:09 PM, Anish Shrivastava anish@gmail.comwrote: Hi Harsih, Since you didnt reply about column headers I assumed that it's the same for every file on share drive. Please see the attached file with macro. You must populate the file path in Sheet2-A1. Do let me know if it works fine for you. Cheers!! Anish On Thu, Jul 21, 2011 at 4:00 PM, Anish Shrivastava anish@gmail.com wrote: Harish, I forgot to ask you one thing. The column headers in the file you attached will be constant for all the 30-35 files which are there on your sharedrive, right? Cheers, Anish On Wed, Jul 20, 2011 at 11:06 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.com wrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- -- 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
Re: $$Excel-Macros$$ Workbooks Consolidation Macro
One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.comwrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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$$ Workbooks Consolidation Macro
Hi Anish, Please find attached the sample file with one row filled. And Column C Column H concatenate should give us unique value so if this is repeated then we need to have below requested feature. Hope this would be more clear now. Thanks Harish On 20 July 2011 21:32, Anish Shrivastava anish@gmail.com wrote: One sample sheet would be helpful to us to see the data structure. However, for this *Also identifiy if there is any row duplicated and highlight them and paste them into another sheet * There must be any particular data field which has to be checked against others in order to find duplicates. Macro for consolidation is not a big deal. On Wed, Jul 20, 2011 at 7:35 PM, Harish Sharma harishsharma...@gmail.comwrote: Hi, I had a macro file which was able to consolidate small files but now I have a requirement to consolidate 30 workbooks saved in a share drive and this data may even cross 66000 row after consolidation. Can someone help me in creating a macro which picks all the file from shared folder and consolidates the one specific worksheet in all the workbook. This macro should also be capable of deleting any blank row in any of these 30 workbooks so that we donot miss any data if someone by error has missed a couple of row and entered the data in couple of row below. 30 workbooks in sharedrive one specific worksheet from all of these named as Tracker Should cover all the blanks and delete them so that no data missed Also identifiy if there is any row duplicated and highlight them and paste them into another sheet If data crosses excel 2003 limit of row it should move to next worksheet. Hope to get a solution from excel experts. -- Kind Regards, Harish Sharma -- -- 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 -- Kind Regards, Harish Sharma -- -- 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 Sample Sheet.xls Description: MS-Excel spreadsheet