Add new cell value to list in another sheet

[Cammandk]

I have a list of Grades in Sheet"Setup". This list will be added to by user. They will select which SCH it belongs too.

I need a macro that will take the new entry in Sheet"Setup") and add to the correct column in Sheet"List2".

Ideally the lists should be sorted.

Thanks
DK

 

[Deepak]

Try this....




http://www.excel-easy.com/examples/transpose.html

 

[Cammandk]

Hi Deepak

Thanks for this but for what I need it won't work.
The list of grades in SETUP could be given any SCH from 5 to 20 and not in order
I need a macro that will look at the SCH No and copy the name to the right of it to the end of the list in each SCH in the List2.
DK

 

[Debraj]

Hi DK,

In case of multiple SCH in the list..

Which one you want to paste in List 2 sheet..