Automatically changing cell numbers into names

[IGDT]

I am looking for some help on making a bit of code as I don't know how to do it.

I have cells for these variables: (so they can be easily edited)
ID1: 04e42adab35780 (used for Person1: customer)
ID2: 04944d8a126885 (used for Person2: chief)
...

The code needed would change the ID's from all the data into the persons name (the ones from above) once I click a button


I already have this code to import data from a different file:

Please Login or Register  to view this content.

[Richard Buttrey]

Would you confirm that when there are more people the data currently starting in row 10 simply moves further down and that the formula

=IFERROR(INDEX($D$5:$D$6,MATCH(F11,$B$5:$B$6,FALSE),1),"")

in G2 copied down gives you what you want

[IGDT]

Would you confirm that when there are more people the data currently starting in row 10 simply moves further down and that the formula

=IFERROR(INDEX($D$5:$D$6,MATCH(F11,$B$5:$B$6,FALSE),1),"")

in G2 copied down gives you what you want

The formula you gave has an error somewhere I think.

But yes, I want to be able to put more people as well, if its to many people then ill just change the A10 to a higher value to start pasting from.

I was thinking on something like this, but its not working:

Please Login or Register  to view this content.

[jindon]

If "ID tag" always stars from A5 and gap(blank row(s)) between last "ID tag" and "Session Number" then

Please Login or Register  to view this content.

[IGDT]

So I fixed the code from this reply on myself to this:

Please Login or Register  to view this content.

But as you can see, it's a bit sloppy and only works for 3 ids. How would I change it so that I can get up to 100 ids?
I added the excel file again as I changed some important things

[jindon]

Please Login or Register  to view this content.

[Richard Buttrey]

[QUOTE=IGDT;5636948]The formula you gave has an error somewhere I think.

Oops, I should have said copy it to G11 and then copy down of course.

WIth a generalised macro

Please Login or Register  to view this content.