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
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
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
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.
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
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
, 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
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
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
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
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
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
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
13 matches
Mail list logo