| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
cell copy related column lable
Hello
I have 60 files and any file consist of one matrix (500 * 60) on sheet1. column H is numbered irregularly. first row at column I to BP is labled (age,gen,.....). I need to a macro, when i input to a box 7700,age,gen,weight,... then related data cell(crossing cell) copy to a seperate file[test.xls] and set data to second row and column I of this file . please notice that 7700 is number at column H. Is this possible? Thank's for any help. best regards |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| find value on table and print column lable | Excel Worksheet Functions | |||
| click on one cell to find and highlight a related cell? | Excel Discussion (Misc queries) | |||
| Search for data in a column bring all related items in other colum | New Users to Excel | |||
| problem of copying column related to date | Excel Discussion (Misc queries) | |||
| move contents of column C based on criteria related to column A | Excel Discussion (Misc queries) | |||
Threaded Mode
