Copy text from a cell by clicking on it?

**nulir** · 02-15-2016, 06:57 AM

Hi

I don't know if this is even possible?

I have a list of items, equipment for some devices that needs to be copied into a other cell or text field on click, so that i can copy just the actual equipment that is added with the device and copy that into SAP.
Something like this, the first block is all the equipment that is available for the unit and when i click one it should be copied so i can just transfer this to SAP instead of one item at a time

Can this actually be done in excel?

Thanks nulir

Case
Charger
Power Cord
Documentation-CD
IVIEWPC-PLUS
MDI-Software
Manual
USB Stick
Headguard
Tip Case

Textfield to be copied
Case
Documentation-CD
Manual

**Special-K** · 02-15-2016, 08:14 AM

Just place a value ("x" perhapsin a blank cell in column B to signify whether the item is to be copied or not.
Then in C1
=IFERROR(INDEX($A$1:$A$1000,SMALL(IF($B$1:$B$1000<>"",ROW(INDIRECT("1:"&ROWS($A$1:$A$1000)))),ROW(A1)),1),"")
Array formula, use Ctrl-Shift-Enter
and copy down the column

Select the values in column C
and Paste Values to where you want the actual list to appear.