Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-28 Thread Kuldeep Singh
Woh... Great Noorain Sir. Regards, Kuldeep Singh On Tue, Aug 28, 2012 at 3:53 PM, NOORAIN ANSARI wrote: > Dear Kuldeep, > > We can also use below alternative solution in pivot table.. > > Manually Create a Union Query > > If you can't combine your data on a single worksheet, another solution is

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-28 Thread NOORAIN ANSARI
Dear Kuldeep, We can also use below alternative solution in pivot table.. Manually Create a Union Query If you can't combine your data on a single worksheet, another solution is to create named ranges in an Excel file, and use MS Query to combine the data. There are sample files here: http://www

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-28 Thread Kuldeep Singh
Yes Noorain Sir, Pivot Table is great solution for this query. Code 16-08-12 17-08-12 18-08-12 4656113 7402 8231 7231 4656114 7403 8232 7232 4656115 7404 8233 7233 4656116 7405 8234 7234 4656117 7406 8235 7235 4656118 7407 8236 7236 4656119 7408 8237 7237 4

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-18 Thread Kuldeep Singh
Dear Sagar, No Problem, You can create link to data enlarge paste for column. and you can do it Regards, Kuldeep Singh On Sat, Aug 18, 2012 at 3:19 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > > Dear Friends, > > I want the total of 4 columns of all the sheets. > > Ex.

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-18 Thread SAGAR KASANGOTTUWAR
Dear Friends, I want the total of 4 columns of all the sheets. Ex. I want total of COLUMN B,C, D & E in same way. Thanks & Regards, CA KSAGAR On Sat, Aug 18, 2012 at 9:52 AM, Kuldeep Singh wrote: > > Hi Sagar, > > Any Changes for any excel sheet, you can go the DATA Menu & Click Edit > Links

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread Kuldeep Singh
Hi Sagar, Any Changes for any excel sheet, you can go the DATA Menu & Click Edit Links & Select All then Update Value & Refresh All Sheets. Regards, Kuldeep Singh On Sat, Aug 18, 2012 at 12:00 AM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Kuldeep, > > But if the location

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread Paul Schreiner
, 2012 2:40:11 PM Subject: Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets Dear Kuldeep, But if the location of any code is change then linking will not showing correct results. Can you give me other solution for the same. Thanks & Regards, CA KSAGAR On Fri, Au

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread SAGAR KASANGOTTUWAR
Dear Kuldeep, But if the location of any code is change then linking will not showing correct results. Can you give me other solution for the same. Thanks & Regards, CA KSAGAR On Fri, Aug 17, 2012 at 11:27 PM, Kuldeep Singh wrote: > > Dear Sudhir, > > Kindly see the attached file. > > Regards

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread SUDHIR VERMA
Hi, Kuldeep, This is very interesting can u explain. thanks regards sudhir On 17/08/2012, Kuldeep Singh wrote: > Simple Create a pivot table. All files paste link & create a new pivot you > can combine all 2000+++ Sheets Database. > > Regards, > Kuldeep Singh > > On Fri, Aug 17, 2012 at 8:50

RE: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread Rajan_Verma
Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of dguillett1 Sent: 17 August 2012 8:41 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ combining data in one worksheet from other workshe

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread Kuldeep Singh
Simple Create a pivot table. All files paste link & create a new pivot you can combine all 2000+++ Sheets Database. Regards, Kuldeep Singh On Fri, Aug 17, 2012 at 8:50 PM, Paul Schreiner wrote: > I made a few assumptions. > Like: What to do if there is a "Code" in one of the sheets that is NOT

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread Paul Schreiner
I made a few assumptions. Like:  What to do if there is a "Code" in one of the sheets that is NOT represented in the Required Data sheet. Or:  if not ALL codes in the Required Data sheet are repredented in each of the other sheets. With this macro, if there are new codes in one of the detail she

Re: $$Excel-Macros$$ combining data in one worksheet from other worksheets

2012-08-17 Thread Kuldeep Singh
You can use Pivot Table. Regards, Kuldeep Singh On Fri, Aug 17, 2012 at 7:41 PM, SAGAR KASANGOTTUWAR < sagarkasangottu...@gmail.com> wrote: > Dear Friends, > > I want combine the data from other worksheets to one specific worksheet so > kindly give me the fastest way to do same task. > > Note. I