Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Selecting Data | Excel Discussion (Misc queries) | |||
Selecting data for report | Excel Discussion (Misc queries) | |||
Selecting most recent data within several lines of data | Excel Discussion (Misc queries) | |||
Pivot charts - data disappear after selecting or data are static | Excel Worksheet Functions | |||
Selecting data | Excel Worksheet Functions |