| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
search column for specific cell using vba
as a novice I need help trying to set up a billing system for my club
although I have done this using VLOOKUP, I would prefer to set it up in programming with vba. 0n sheet 2, I wish to search down column A1 for a number equivalent to a number in a particular cell in sheet 1, then select and ofset to adjacent cell in column B to copy the value and paste to anther cell on sheet 1 any help would be appreciated |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
search column for specific cell using vba
Try a VLOOKUP formula or index/match formulas or FIND in VBA
-- Don Guillett SalesAid Software "dave91" wrote in message ... as a novice I need help trying to set up a billing system for my club although I have done this using VLOOKUP, I would prefer to set it up in programming with vba. 0n sheet 2, I wish to search down column A1 for a number equivalent to a number in a particular cell in sheet 1, then select and ofset to adjacent cell in column B to copy the value and paste to anther cell on sheet 1 any help would be appreciated |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Find & Replace - Limit search to a specific column | Excel Worksheet Functions | |||
| search column of text cellto identify those cells with specific w | Excel Worksheet Functions | |||
| search a column for a specific piece of data using vba | Excel Programming | |||
| search column for a specific piece of data using vba | Excel Programming | |||
| Macro to search a column for a specific word and replace with | Excel Programming | |||
Linear Mode
