Thread: data selecting
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
climate climate is offline
external usenet poster
 
Posts: 91
Default data selecting

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