Home » Forums » Open Source Learning Center » Question and Answer

Multiple files

Submitted by dewy on 27 January, 2012 - 14:07

Hi ,
My english not very weel, but i wiil try to ask.

I have a lot of excel files with worker names.

And i need to create automaticly a excel file which one will filled up the from multiple excels to one excel.

with containing information

File name1: =sheet2!N9; =sheet3!N15; sheet4!k7 ; =sheet4!K39
File name2: =sheet2!N9; =sheet3!N15; sheet4!k7 ; =sheet4!K39

and utc

‹ formula to insert rows based on a range of Nos. then copy contents down Whats the best way to learn VBA ? ›
»
Nick's picture

the best way to do this is

Submitted by Nick on 27 January, 2012 - 14:37.

the best way to do this is with a pivot table using multiple sources

»

re

Submitted by Anonymous on 30 January, 2012 - 07:02.

Mybe you have some examples!

»
Vishesh's picture

Check the

Submitted by Vishesh on 30 January, 2012 - 19:11.

Check the blog
http://excelexperts.com/simple-multiple-source-pivot

»