Using Excell how can you link a list in one sheet to a cell in another sheet so that you can pick from that list for that cell?

You can use the combo box control from the Forms menu. Go to the View menu and pick Toolbars. From there click on Forms to open that toolbar.

Then pick the combo box from the Forms toolbar. If you put the cursor over the tools, you'll find it Draw it out on the screen. Right click on it and pick Format Control.

Then pick Control. You will see an option with Input range. At the end of the text box beside it you'll see what is like a tiny grid with a red spot in the middle of it.

Click on that and you will be returned to the spreadsheet You can then click on any sheet and select your list. You'll see the range showing in a new pop-up. Close that when you have selected the cells you want and you will be back to the other box again.

Now do the same for "Input cell" and that will be the cell that will show the number of the object on the list you want, when you pick something from the dropdown list That will only give you a number, not show the actual object. If you want to show the actual object, like a month of the year, you could use a vlookup function to help you show it. Where your original list is, beside it put number values.So if it was months, you would put 1 beside January, 2 beside February and so on So say your list of months is in Sheet2 from B1 to B12, and your combo box on Sheet 1 references it as uses E22 on Sheet1 as the input cell.

So if you pick March off the list, in E22 it will put 3. Now you can use a Vlookup to use the 3 to show the word March. Back on Sheet2, in A1 to A12 put the values from 1 to 12.

So you'll have the numbers in column A and the months in column B Then on Sheet1 you'd have this formula. It looks at E22, which is getting the number from the list as a result of the dropdown.It then looks back at Sheet2, finds the number 3 in the first column and moves to the second column and finds March and displays that back in a cell on Sheet1 where you put the lookup formula: VLOOKUP(E22,Sheet2! A1:B12,2) There are a lot of instructions there, and it is a bit complicated, so hopefully you can make sense of them and get what you want.

I cant really gove you an answer,but what I can give you is a way to a solution, that is you have to find the anglde that you relate to or peaks your interest. A good paper is one that people get drawn into because it reaches them ln some way.As for me WW11 to me, I think of the holocaust and the effect it had on the survivors, their families and those who stood by and did nothing until it was too late.