Hello
I have 60 files and any file consist of one matrix (500 * 60) on sheet1.
column H is numbered irregularly. first row at column I to BP is labled
(age,gen,.....).
I need to a macro, when i input to a box 7700,age,gen,weight,... then
related data cell(crossing cell) copy to a seperate file[test.xls] and set
data to second row and column I of this file . please notice that 7700 is
number at column H.
Is this possible?
Thank's for any help.
best regards

On Oct 31, 9:24*am, climate wrote:
Hello
I have 60 files and any file consist of one matrix (500 * 60) on sheet1.
column H is numbered irregularly. first row at column I to BP is labled
(age,gen,.....).
I need to a macro, when i input to a box 7700,age,gen,weight,... then
related data cell(crossing cell) copy to a seperate file[test.xls] and set
data to second row and column I of this file . please notice that 7700 is
number at column H.
Is this possible?
Thank's for any help.
best regards

It sounds possible, with a lookup of some sort. But I confess I can't
quite follow your comments. Are you saying the data is already stored
in one file? And you want it to show in the 60 others?

Hi Spiky
No, any file has a special data. i want to run a macro that based on number
in column H,then related data on each cell and lable on first row, copy to
test.xls.
And again, run macro for second file and third .... to 60 files. all of data
of each file copy to test.xls only(sheet1) separatly. and as a result,
finally, i will have one file[test.xls] which consist of data selective of 60
files.

best regards

"Spiky" wrote:

On Oct 31, 9:24 am, climate wrote:
Hello
I have 60 files and any file consist of one matrix (500 * 60) on sheet1.
column H is numbered irregularly. first row at column I to BP is labled
(age,gen,.....).
I need to a macro, when i input to a box 7700,age,gen,weight,... then
related data cell(crossing cell) copy to a seperate file[test.xls] and set
data to second row and column I of this file . please notice that 7700 is
number at column H.
Is this possible?
Thank's for any help.
best regards

It sounds possible, with a lookup of some sort. But I confess I can't
quite follow your comments. Are you saying the data is already stored
in one file? And you want it to show in the 60 others?

Hi Spiky
Please suppose that, the following is a matrix at my first file and on sheet1.
H I J K L ........... BP
age gen weight job tall
245 28 F 42 stud 143
789 14 M 33 stud 111
7700 56 F 63 artist 164
1289 31 F 61 dentist 165
..... ... . .. ........ ...
..... ... . .. ........ ...
I need to a macro, when i input 245,age, job,tall,.... then related data
cell (28,stud,143,.....) copy to test.xls on sheet1 and set to second row and
column I.

regards


"climate" wrote:

Hi Spiky
No, any file has a special data. i want to run a macro that based on number
in column H,then related data on each cell and lable on first row, copy to
test.xls.
And again, run macro for second file and third .... to 60 files. all of data
of each file copy to test.xls only(sheet1) separatly. and as a result,
finally, i will have one file[test.xls] which consist of data selective of 60
files.

best regards

"Spiky" wrote:

On Oct 31, 9:24 am, climate wrote:
Hello
I have 60 files and any file consist of one matrix (500 * 60) on sheet1.
column H is numbered irregularly. first row at column I to BP is labled
(age,gen,.....).
I need to a macro, when i input to a box 7700,age,gen,weight,... then
related data cell(crossing cell) copy to a seperate file[test.xls] and set
data to second row and column I of this file . please notice that 7700 is
number at column H.
Is this possible?
Thank's for any help.
best regards

It sounds possible, with a lookup of some sort. But I confess I can't
quite follow your comments. Are you saying the data is already stored
in one file? And you want it to show in the 60 others?