| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Locate Value in a set Row, with Dynamic Column
Hi,
I have some data and the headers for the numbers are months. All the months are on row 7. I need to add some code to start looking in row 7 (cell A7) and look at each column to locate the relevant date entered in cell A1. Example: The code needs to look at cell A7, then B7, then C7 etc etc until it locates the right value. How can I do this please? Thanks, |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| locate a column, sum specific columns to the right of that column | Excel Discussion (Misc queries) | |||
| How to locate a cell with dynamic column value | Excel Programming | |||
| Locate data from 1 column in another | Excel Worksheet Functions | |||
| Locate last cell in column | Excel Discussion (Misc queries) | |||
| Locate a specific row or column | New Users to Excel | |||
Threaded Mode
