Hi
Please suppose that, the following is a matrix at my first file and on sheet1.
Column H is numbered irregularly and has duplicate numbers and columns I to
BP is labled(age,gen,....).

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 numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....) copy to separate file(test.xls)and set on to sheet1 and
set extracted data to second row and column I.

Thank's for any help.

best regards

Re-reading your post:

I need to a macro, when i input numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....)

If you want to only select some of the labels then you could have up to 60
inputs. What it the maximum number of labels that you would want to input?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"climate" wrote in message
...
Hi
Please suppose that, the following is a matrix at my first file and on
sheet1.
Column H is numbered irregularly and has duplicate numbers and columns I
to
BP is labled(age,gen,....).

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 numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....) copy to separate file(test.xls)and set on to sheet1
and
set extracted data to second row and column I.

Thank's for any help.

best regards

Hi Sandy
Maximum number of lables is 10 .
Regards

"Sandy Mann" wrote:

Re-reading your post:

I need to a macro, when i input numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....)

If you want to only select some of the labels then you could have up to 60
inputs. What it the maximum number of labels that you would want to input?

--
HTH

Sandy
In Perth, the ancient capital of Scotland
and the crowning place of kings


Replace @mailinator.com with @tiscali.co.uk


"climate" wrote in message
...
Hi
Please suppose that, the following is a matrix at my first file and on
sheet1.
Column H is numbered irregularly and has duplicate numbers and columns I
to
BP is labled(age,gen,....).

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 numbers at column H [245,789,7700,...] and
input optional lables [age, job,tall,....] then related data cell
(28,stud,143,.....) copy to separate file(test.xls)and set on to sheet1
and
set extracted data to second row and column I.

Thank's for any help.

best regards