Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Hlookup
Help please. I have 4 columns on a worksheet that are to be updated wit data when clicking a selection in a list box. The first 2 columns have the same data regardless of the selection. a it is common data. I have sorted this by following key strokes fo select, copy and paste through macro record and it works. The next 2 columns however require data specific to the selection, an this data is in multiple columns on another worksheet. When making th selection the reference number corresponding to the data column needed is entered into a cell from the list box source by using VLOOKU function. How do I code the next part of the macro so that the reference numbe is identified in this cell, compared by using HLOOKUP function agains all reference numbers on the other workwsheet, then selecting th corresponding column range of data, copy and paste back to column 3 (Repeat process for column 4). Regrds - Joh -- jo2389h ----------------------------------------------------------------------- jo2389hn's Profile: http://www.excelforum.com/member.php...fo&userid=2226 View this thread: http://www.excelforum.com/showthread.php?threadid=38835 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hlookup row 5 | Excel Worksheet Functions | |||
HLOOKUP Help | Excel Worksheet Functions | |||
hlookup | Excel Worksheet Functions | |||
HLookUp | Excel Worksheet Functions | |||
Hlookup/max value? | Excel Worksheet Functions |