selective cells
 

Hello
Please suppose that, the following is a matrix at my first file and on sheet1.
Column H is numbered iregularly and columns I to BP is labeled.

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,789,7700,....] and [age, job,tall,....]
then related data cell (28,stud,143,.....) copy to test.xls on sheet1 and set
to second row and column I.

best regards

selective cells
 

See suggestion in other post.
--
Thanks,
Shane Devenshire


"climate" wrote:

Hello
Please suppose that, the following is a matrix at my first file and on sheet1.
Column H is numbered iregularly and columns I to BP is labeled.

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,789,7700,....] and [age, job,tall,....]
then related data cell (28,stud,143,.....) copy to test.xls on sheet1 and set
to second row and column I.

best regards