| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Selective on Name | Excel Discussion (Misc queries) | |||
| Selective Trendlines | Charts and Charting in Excel | |||
| Selective cell changes | Excel Worksheet Functions | |||
| Merging multiple worksheets (selective cells) | Excel Discussion (Misc queries) | |||
| Selective calculation | Excel Worksheet Functions | |||
Linear Mode
