Hi all,
I have attached an .xls which will make more sense.
I have a sheet where people input data into a worksheet. On this worksheet there is a combobox populated with a named range.
On another sheet I wish to house a 'report' where all ansers are collated. Obviously I can use the standard '=A1' for the cells, but how do I reference info housed in a combobox?
Thanks
Bookmarks