Validation Lists

Hi All,

Im trying to do something that ive done before but just cant remember how i did it.

Ive got a spreadsheet that has a list of requirements (audits) in column A.

To the Right of that i have 5 columns (B1-F1) with the heading of the score.

Then from column G1-R1 i have Jan-Dec

Therefore i currently have

Audit Item 0 1 2 3 4 J F M A M J J A S O N D
1
2
3
4
etc

Then in January when the audit is complete, the auditor will put the scores in the January Column. Now what i want to happen is through the Validation command if i select April from the drop now list is puts the values from the April column into the relevant scoring (0-4) column.

Thanks in advance
8

Firstly let me re write that sentence.

Now what i want to happen is through the Validation command, if i select April from the drop down list it puts the values from the April column into the relevant scoring (0-4) column.

but to answer your question. I can have the drop down list anywhere.

i would select April from the drop down list

the drop down list for example purposes will be in T1

Originally Posted by :) Sixthsense :)

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

Please see attached

so from the example spread sheet i have selected april from drop down list in T1.

This then transfers the numbers from Column J2-6 into the relevant scoring box (B-F). Therefore which ever month i pick it will transfer those numbers over into the scoring colmns

Originally Posted by AliGW

Try the attached file.

Thats the one i believe.

will have a proper look in abit.

Thanks a lot