Loop through multiple Columns on one sheet to compare with one column on another

[sspreyer]

hi ,

no sure if possible. i have attach a test file as so much easier to explain. but here goes i have sheet call Hit list it has list assets that need coming for service etc.. this sheet list length can change daily. i also have another sheet call Location , import the data from a tracker to find where the asset is which has around 12 different location (columns) and header for each location on the column this obviously changes daily too. all the asset are placed under the heading (column) where they are. using column B on "hit lis"t sheet loop through all the columns with headers on "Location" sheet if match found then place column header from "Location" sheet in which it was found on" hit list" sheet Column F where it match is For eaxmple... Currently At Tr Resources best to look at the test file so much easyier to explain lol currently i have to use CTRL F and type each asset in manally find it location so anything would be much apprecaited as it painfully numbing.

many thank in advance
Shane
TEST lOCATION fILE .xlsm

[jolivanes]

Before anything, 2 sheets have a trailing space in their name. Delete these as sure as heck, someone will give you a nice macro and you'll come back saying that it does not work.

[jolivanes]

In your attachment in result sheet, did you miss some on purpose?

Please Login or Register  to view this content.

[sspreyer]

In your attachment in result sheet, did you miss some on purpose?

Please Login or Register  to view this content.

Hi Jolivanes ,
sorry for the trailing spaces in their names my Bad as i quickly mock the example.sheet to makesure senstive data was out. regarding miss some wasnt on purpose just messing it up do it manually

thank for Marco much appreacited will definitely help me as you can see i muck up the example lol.

again thank you so much

[jolivanes]

Thanks for letting us know that all is well again in your Excel World.

You mentioned that the amount of locations can change.
Provided that the locations are going to be in Row5, change this line

Please Login or Register  to view this content.

to this

Please Login or Register  to view this content.

Some reading material in the following sites.
https://edu.gcfglobal.org/en/excel-t...rging-cells/1/
https://theexcelclub.com/stop-do-not...hy-with-fixes/
https://www.perfectxl.com/excel-tool...t-merge-cells/
https://www.atlaspm.com/toms-tutoria...merging-cells/