Automated Order Form From Selections on an Item List

[rmathew]

Hi There,


I have a few sheets of items.


I want a person to be able to put x's in the cell to the left of any one of those items on any one of those sheets, and have the selected items appear one after the other on a final sheet, i.e. an order form.


Any idea how I might be able to accomplish this?


Thanks,


Raj

 

[Special-K99]

You'll have to amend this to reflect your spreadsheet of which the only info we have is you have a list in at least the second column of the spreadsheet.
I'm assuming the list of items is in Sheet1 column B and data starts at B2

in Sheet2!A2 (the final sheet)
=IFERROR(INDEX(Sheet1!$A$2:$B$1000,AGGREGATE(15,6,ROW(Sheet1!$A$2:$B$1000)/((Sheet1!$A$2:$A1000="X")),ROWS(A$2:A2))-(2-1),column()+1),"")
copy down for as many items as you have on Sheet1

If you change where the data resides you will have to change these values
=IFERROR(INDEX(Sheet1!$A$2:$B$1000,AGGREGATE(15,6,ROW(Sheet1$!A$2:$B$1000)/((Sheet1!$A$2:$A1000="X")),ROWS(A$2:A2))-(2-1),column()+1),"")