hello,

I have to make a excel table every week which contains data that made by our several stations in factory in everyday. so when friday comes nightmare starts for me and weekend as well(like today ). actually I have to da a simple table but there are lots of data so i couldnt handle with it.

I ll try to explain my situation with my horrible english

I have 2 excel files. One of them is data excel(close) and one of them is open excel which i have to make a table. In our factory we have several station and several processes, I try to explain with an example I have attached the 2 files demo(simple ver.)

In closed file close.xlsx in "Main" Sheet Starts with "F2" cell and continious to horizontal(G3,H3,I3 . . . ) are model numbers and there are "0" and "1" values below that model numbers For ex. in closed file main sheet F2 cell "1xxx" model number and "F3" cell value is "1" so that i have to get data A3,B3,C3,D3,E3 to my open excel Open.xlsx / when i put the model number of "1xxx" to "A3" cell in open.xlsx or when I started the macro or fonction or etc it will automaticly fill B3,C3,D3,E3,F3 in open.xlsx with the data of close.xlsx.

I hope i can explain my problem simply and waiting a very good favor that i ll not forget years and years.

BR
close.xlsxopen.xlsx