I have attached 2 files
'standardinfo.xls' which contains Job Titles in column A and Regional rates (London column B, etc) which is updated centrally.
'info.xlm' which has a macro (working fine) to copy data from 'standardinfo'
I now need to amend the macro to only draw the column of data selected in combobox in cell B2 so that column A still has titles and column B has the selected regional rates.
Points awarded on the basis of value to me, not perceived complication