Hi Peter,
Sure soon I will send you that consolidation macro.
Regards,
Deepak Rai
On Mon, Oct 4, 2010 at 11:08 PM, Peter Konijn wrote:
> Hi,
>
> It works, thanks a lot for your support.
>
> I am still curious for the macro of Deepak Rai.
>
>
>
> Regards Peter
>
> 2010/10/3 P.VIJAYKUMAR
>
> De
Hi,
It works, thanks a lot for your support.
I am still curious for the macro of Deepak Rai.
Regards Peter
2010/10/3 P.VIJAYKUMAR
> Dear Peter,
>
> You can Import Data From Data Menu.In DATA Menu Go to Get External Data,
> then select Existing Connections,then you will get a dialog box,in t
Dear Peter,
You can Import Data From Data Menu.In DATA Menu Go to Get External Data,
then select Existing Connections,then you will get a dialog box,in that
select browse for more then select the file you need to import, then press
ok. Then you will get a query about what sheets of the workbook yo
Peter,
I have this macro I will customize it as per your need & will soon share the
same with you.
Regards,
Deepak Rai
On Fri, Oct 1, 2010 at 11:35 PM, Deepak Rai wrote:
> Hi Peter,
>
> For this you need to have a common folder where you can store all your Data
> files after that through VBA m
Hi Peter,
For this you need to have a common folder where you can store all your Data
files after that through VBA macro you can consolidate all those N numbers
of Data files into a consolidated excel file. You would not able to do this
by manual approach.
Regards,
Deepak Rai
On Fri, Oct 1, 2010
Dear Vijay,
In the DATA menu of Excel I have options for Web, Text, Acess, and other
source, I do not have a button for excel-files.
I already tried several option in the menupath but I couldn't let it work
.
In the attachment an example. In practice there are several 100's of
datafiles. The prob
Hi,
You Can import Data from Web ,Other Excel sheets ,Text, etc by using Get
External Data in The DATA MENU of Excel.
Regards,
Vijay Kumar
--
--
Some important links for excel users:
1. Follow us on TWITTER for ti
Hi,
I am quit new to excel. I like to know if it is possible to import
data from one excel document into another. The most ideal solution
would be that after starting up an excel file you can somehow specify
another excel file and import the data from that file into the file
you opened. The data o