Random list place in column order.

  • Thread starter Thread starter John
  • Start date Start date
J

John

Hi Everyone

I have a list, A3:I25 that you can select items. The selection is done with
a CheckBox at each items. I would like the items selected to be listed in
column order below the list,ex:A30,31,32 etc.Can you help me, I am not very
good with functions or macro.
Regards
John
 
One play to try .. something along the lines
illustrated in this sample:
http://www.savefile.com/files/1333415
Extract checkbox selections into col.xls

Assume 6 source items are listed in A3:B5, viz:

Item1 Item4
Item2 Item5
Item3 Item6

6 checkboxes are drawn from control toolbox,
with corresponding link cells in E3:F5
(these are set in Properties view.
In design mode, right-click on checkbox > choose Properties)

In E10:
=OFFSET($A$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3))

In F10:
=IF(OFFSET($E$3,MOD(ROWS($1:1)-1,3),INT((ROWS($1:1)-1)/3)),ROWS($1:1),"")

In G10:
=IF(ROWS($1:1)>COUNT($F$10:$F$15),"",SMALL($F$10:$F$15,ROWS($1:1)))
Select E10:G10, copy down to G15

Then in A10, copied down to A15:
=IF(G10="","",INDEX($E$10:$E$15,G10))

CF is applied to results range A10:A15 using formula is: =A10="",
formatted accordingly to mask with white font/borderless
 
I just sent another Request titled " Retrieving data from one form to
another "
Thinking that this request was not clear, please ignore the second request.
Thank you for your reply I will try it and let you know if I can make it
work.
Thanks Again
 
Hi Again
Just to say It works, Thank you Max

John said:
I just sent another Request titled " Retrieving data from one form to
another "
Thinking that this request was not clear, please ignore the second
request.
Thank you for your reply I will try it and let you know if I can make it
work.
Thanks Again
Click to expand...
 
Back
Top