Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
question on macro
Hi,
I have a spreadsheet at hand that is an output from a lab computer. Until now, I had to do some simple calculations with excel on this sheet. But in future I want to do more. For this I need a simple (I think) solution for a problem. But it seems I cannot find how to do that :-) In essence it comes down to this: -I have a workbook with two sheets. -In sheet one is the output file (xls) from a laboratory machine. This consists mainly of multiple colums with each a unique text header in the top row. Each column has a variable number of cells depending on what analysis is done by the lab machine. It can be 10 cells or 100 cells under each header. In practice this means that sheet one can consist of anything from 2 to 400 rows with all numbers possible in between. -In sheet two I have a list in one column of all possible column headers that could be found in sheet 1 (this is made up by an total output list from the lab machine). Note that not from every analysis, all header names are put in sheet one. That depends on the analysis again. So the total list on sheet two can be 200 names long while the output from the labmachine to sheet one could consist of e.g. only of these 20 headers with a variable number of cells under each header. -I want a macro that takes every name from sheet two and checks if it is in the current header row of sheet one. IF SO, I want the macro to select the cells under that column header for as far the column is filled with values. -With this selection made by the macro, I than want to perform another action (maybe copying it to another section of the workbook or maybe give the selected range a name - but that is something I have to look at later). Anybody able to help? Regards, Harry |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Quick Macro question - How to delete two rows then skip one - and repeat | Excel Discussion (Misc queries) | |||
Excel Macro Question | Excel Worksheet Functions | |||
using a macro question revisited | Excel Discussion (Misc queries) | |||
Excel Macro Question about Conditional Formatting | New Users to Excel | |||
Attn: Dave P. Question re Pix Calls via Macro | Excel Discussion (Misc queries) |