I use Excel in a very basic function day to day.
I now have a task to do where by I need to put together a sheet of various information about an individual product.
I have a total of 700 finished products. Each product has its own individual recipe (which I can type in to cells) plus approx 20 limited variables which each have a choice of 10 or 20 fixed options.
What I want to do is to set up Sheet 1 with type in boxes which will automatically appear into a pre-prepared template in sheet 2 (cells merged etc.). This bit is easy enough.
In addition to this, I want information which can be selected from drop down lists in sheet 1 to also appear in sheet 2.
So, how can I create a drop down list and get the selected cell contents to appear in sheet 2?
For example. Drop down list with Monday Tuesday, Wednesday etc. Selected item to appear in sheet 2
Bookmarks