B
Bunny
Hi. I would apprecaite any help I can get on this. I have an existing
spreadsheet of training courses, taking an old course number and replacing
it with a new format. Additionally, I have four extra cells of info per
course code that needs to be incorporated into a revised spreadsheet. for
example:
Existing Spreadsheet:
Column A - Course Code (old)
Column B - Course Code (new)
Column C - Course Name (remains unchanged)
New Spreadsheet:
Column A - Course Code (new)
Column B - Course Name (remains unchanged)
Column C - New Category Code 1
Column D - New Category Code 2
Column E - New Category Code 3
Column F - New Category Code 4
Where the real problem is is that I have another spreadsheet of history
records of individuals listed in terms of the old structure.
The current history spreadsheet is:
Column A - Person's Name
Column B - Person's ID Number
Column C - Course Code (old)
Column D - Course Name
There are also columns listing dates etc, but these won't change at all..
I need somehow to run a conversion formula that will recognise the contents
of each line of Column C in the current history spreadsheet, and will
populate five columns with the information in Columns A, C, D, E & F in the
'New' spreadsheet.
Any advice on how to write the conversion formula will be gratefully
accepted.
spreadsheet of training courses, taking an old course number and replacing
it with a new format. Additionally, I have four extra cells of info per
course code that needs to be incorporated into a revised spreadsheet. for
example:
Existing Spreadsheet:
Column A - Course Code (old)
Column B - Course Code (new)
Column C - Course Name (remains unchanged)
New Spreadsheet:
Column A - Course Code (new)
Column B - Course Name (remains unchanged)
Column C - New Category Code 1
Column D - New Category Code 2
Column E - New Category Code 3
Column F - New Category Code 4
Where the real problem is is that I have another spreadsheet of history
records of individuals listed in terms of the old structure.
The current history spreadsheet is:
Column A - Person's Name
Column B - Person's ID Number
Column C - Course Code (old)
Column D - Course Name
There are also columns listing dates etc, but these won't change at all..
I need somehow to run a conversion formula that will recognise the contents
of each line of Column C in the current history spreadsheet, and will
populate five columns with the information in Columns A, C, D, E & F in the
'New' spreadsheet.
Any advice on how to write the conversion formula will be gratefully
accepted.