Windows 10: FORMULA HELP- Excel : Using 2 sheets

The website will not allow me to add any photo of any kind, so I have made charts. : SHEET 1Cell down Row ->DF6Enter Country NameEquals Load1CameroonRows go from 6-127DATA sheet 2's nameCell down Row ->BC29COUNTRYLOAD PERCENT30Burundi100%31Cameroon400%Rows go from 29-70I need the" load percent" info from "DATA" sheet2 to populate in "SHEET 1" "Equals load", once the users select a country.I have not been successful in my attempts, even with the help of AI. Help from the wise is much appreciated!

:)

 

Help needed with Excel Attendance Sheet

You use the Data tab, Data validation facility to do this.

If you want a coherent explanation then look in Excel Help. Here's the relevant extract from Excel 2007 Help. Excel 2007 Help - Data Validation.pdf

My example:
- I have written them in what seems to me to be the order of easiest explanation.
- You'd actually set them up in the reverse order - step 3, step 2, step 1.

1 The result - my dropdown list. I select the cell then click on the dropdown arrow that appears next to it.




2 To set this up, select the whole column [or individual cells] where you want the dropdown to appear then click on the Data tab then the Data validation control. You need to
- select In-cell dropdown
- set the Allow entry to List
- in Source, enter the worksheet name & cell range where you have written the allowable entries - you will generally want to use absolute cell references such as those shown [$ in a cell address means absolute and will not vary as you copy the formula all the way down your column - look this up if you are not familiar with it because it needs a bit of getting used to].




3 Write out the list of allowable entries that will appear in your dropdown list.




Job done.

Denis

 

skydrive excel formulas across multiple sheets

I own a lumia 920 and tried opening an excel file from skydrive as well as office. In the excel I have formulas that pulls figures from more than 1 sheet which it does not seem to be able to read. the cell just displays #VALUE!. however I have other formulas
which pull figures from the same sheet and that one displays with no problem. seems to be a problem when a formula spans across multiple sheets. any ideas?

 

Help needed with Excel Attendance Sheet

So I have this attendance sheet, with this formula for the days of the month, based on this “CONFIG” sheet, but id like to make the MONTH cell a drop down list, that would change the formula in F16 based on the selected month in the list.



ALSO
And this seems a bit greedy but id also like it if when I selected a month like February that has 28 days, or any month that has less than 31 days, the “31st day column” to be automatically hidden, and if after that I selected a month with 31 days, It should be un-hidden, which from my research the only way to do that would be to use a MACRO command which I have little to no understanding about.

Any help is greatly appreciated, and id settle for just the month drop down list!