Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you link cells?
I am looking to link cells horizontally so that when a drop down box (list
box) is used and it locates a particular entry that has been selected, it subsequently populates all the cells for that entry horizontally as well as the the selected entry from the drop down box. Say the list box is in A1...it selects an entry from the list below which might be in A45, how can i set it to populate B45, C45 D45 etc in boxes B1 C1 D1 Any ideas would be appreciated Justin Kline |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do you link cells?
Try using Vlookup() in *each* of the cells along Row1.
Enter this in B1: =VLOOKUP($A1,$A$2:$H$100,COLUMNS($A:B),0) And drag across to copy to Column H. -- HTH, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- "Justin Kline" wrote in message ... I am looking to link cells horizontally so that when a drop down box (list box) is used and it locates a particular entry that has been selected, it subsequently populates all the cells for that entry horizontally as well as the the selected entry from the drop down box. Say the list box is in A1...it selects an entry from the list below which might be in A45, how can i set it to populate B45, C45 D45 etc in boxes B1 C1 D1 Any ideas would be appreciated Justin Kline |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating only non-empty cells... | Excel Worksheet Functions | |||
How do I easily link a block of cells in one spreadsheet to anothe | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
link multiple cells to multiple cells | Excel Discussion (Misc queries) | |||
How do I link many cells to one particular cell? | Excel Discussion (Misc queries) |