Add cell value to correct list in another Sheet

[Cammandk]

I have a list of Grades (Job Description). Each of them is allocated a SCH No = SCH1 / SCH2 etc
I need a macro that will go through this list and copy the Grade into the correct SCH Column on Sheet List2.
The columns in List 2 then need to be sorted A-Z.



Thanks.
DK




AddNamestolist.xlsx

[Richard Buttrey]

Hi,

You don't necesarily need a macro when a standard VLOOKUP will do the job. i.e. A2 in List2 copied across

Please Login or Register  to view this content.

If you really do need a macro then just get the macro to create this formula and copy it across.

Similarly with the sort. Just select all the data in list 2 and pick the Sort Left to Right in the sort Options.

[Hawkeye16]

I just recorded the sort macro but this should get you what you want I think. It sorts the names and then just uses an array formula to pull the correct stuff into the List2 tab.

[Cammandk]

Hi Hawkeye

This works. I've tried moving this across into the format/positions that I actually have for the data and it's now not working. I suspect it's because my actual layout doesn't start on A1. Could you kindly look at and see if there is a solution.

DK




AddNamestolist2-coded.xlsm

[Hawkeye16]

Put this in A5 on List2 and press CTRL + SHIFT + ENTER. Then you can just copy over and down.

Please Login or Register  to view this content.

*You may need to replace the ; with , depending on your excel setup.

[Cammandk]

Hi Hawkeye

That works great.
Thanks
DK