Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offset example wanted
I wish to click on a single cell and have a row of data shown elsewhere. i.e I have four rows of data in a worksheet. One is green one red one yellow and one white. When I click on the red cell I want the data from my red collection entered in a selected row. When I click on the green cell I want the green collection entered where the red collection was.etc etc Can this be done? TIA Regards from Africa Aussiemike -- aussiemike ------------------------------------------------------------------------ aussiemike's Profile: http://www.excelforum.com/member.php...o&userid=34653 View this thread: http://www.excelforum.com/showthread...hreadid=544838 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
offset example wanted
Hi, is there more than one row red or green, etc....
one way to do it is create one new column called ID or something, to use as a auto filter, than, a VBA project could auto filter for you. regards Marcelo from Brazil "aussiemike" escreveu: I wish to click on a single cell and have a row of data shown elsewhere. i.e I have four rows of data in a worksheet. One is green one red one yellow and one white. When I click on the red cell I want the data from my red collection entered in a selected row. When I click on the green cell I want the green collection entered where the red collection was.etc etc Can this be done? TIA Regards from Africa Aussiemike -- aussiemike ------------------------------------------------------------------------ aussiemike's Profile: http://www.excelforum.com/member.php...o&userid=34653 View this thread: http://www.excelforum.com/showthread...hreadid=544838 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Offset Function | Excel Worksheet Functions | |||
Offset Function works in cell, not in named range | Excel Worksheet Functions | |||
Question for use of offset and range | Excel Worksheet Functions | |||
OFFSET using ADDRESS for the reference argument | Excel Worksheet Functions | |||
Hyperlinks using R[1]C[1] and offset function in its cell referenc | Excel Worksheet Functions |