-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:snban
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
Hey Satish,
please see the below link and follow instructions
http://support.microsoft.com/kb/214081
On Wed, Aug 17, 2011 at 11:36 AM, Satish Bandaru wrote:
> hi experts
> please help me.plz find the atachment
> thanks in advance
>
> --
>
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 LinkedI
ks for the help.
>
> Pankaj Chawla
> 9911104968
> -Original Message-
> From: vikas gupta [mailto:vikas.63...@gmail.com]
> Sent: 13 August 2011 18:39
> To: pankaj.chawl...@gmail.com
> Cc: tech_pankajcha...@rediffmail.com
> Subject: Fwd: $$Excel-Macros$$ Workbook
ail.com]
> Sent: 13 August 2011 18:39
> To: pankaj.chawl...@gmail.com
> Cc: tech_pankajcha...@rediffmail.com
> Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro
>
> -- Forwarded message --
> From: ashish koul
> Date: Fri, 22 Jul 2011 05:41:02 +0530
Consolidation Macro
-- Forwarded message --
From: ashish koul
Date: Fri, 22 Jul 2011 05:41:02 +0530
Subject: Re: $$Excel-Macros$$ Workbooks Consolidation Macro
To: excel-macros@googlegroups.com
try this see if it helps
On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava
wrote:
> Har
requirement.
Thanks for the help.
Pankaj Chawla
9911104968
-Original Message-
From: vikas gupta [mailto:vikas.63...@gmail.com]
Sent: 13 August 2011 18:39
To: pankaj.chawl...@gmail.com
Cc: tech_pankajcha...@rediffmail.com
Subject: Fwd: $$Excel-Macros$$ Workbooks Consolidation Macro
try this see if it helps
On Thu, Jul 21, 2011 at 10:12 PM, Anish Shrivastava wrote:
> Harish,
>
> Did you try it.. ??
>
> On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:
>
>> Harish,
>>
>> PLease ignore the earlier attachment as I forgot to add *DUPLICATE CHECK*in
>> that macro.
>>
Harish,
Did you try it.. ??
On Thu, Jul 21, 2011 at 5:19 PM, Anish Shrivastava wrote:
> 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
> wrote:
>
>> Hi Harsi
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 wrote:
> Hi Harsih,
>
> Since you didnt reply about column headers I assumed that it's the same for
> every file on share driv
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
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
wrote:
> Hi Anish,
>
> Please find attached the sample file with one
Sure Harish :) ..
You will have it soon..
On Thu, Jul 21, 2011 at 3:45 PM, Harish Sharma wrote:
> Can someone help this is really urgent.
>
> Thanks
> Harish
>
>
> On 20 July 2011 23:06, Harish Sharma wrote:
>
>> Hi Anish,
>>
>> Please find attached the sample file with one row filled.
>> And C
Can someone help this is really urgent.
Thanks
Harish
On 20 July 2011 23:06, Harish Sharma 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 r
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
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.
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
conso
18 matches
Mail list logo
