Thread: Find text within cell and return column and row title next to the name on a new sheet.
View Single Post
 
Old 03-17-2015, 07:05 AM
tanyabowring@live.co.uk tanyabowring@live.co.uk is offline Windows 7 32bit Office 2010 32bit
Novice
  
Join Date: Mar 2015
Posts: 2
tanyabowring@live.co.uk is on a distinguished road
Default Find text within cell and return column and row title next to the name on a new sheet.
I am looking for help with the following;

I have two sheets;

1. Skill Map
2. Person Map

I would like to create a macro to look up each name in column A on 'Person Map', in sheet 'Skill Map'. If it finds a result, I would like it to return the row AND column name, within the same cell, next to the name on 'Person Map'. The complication is that there could be multiple names in one cell on 'Skill Map'.

I have tried to pull something together but my knowledge isnt substantial enough. Help would be much appreciated.
Attached Files
File Type: xlsx Macro example.xlsx (10.6 KB, 14 views)
Reply With Quote