VBA Identify code to make information box not appear

[Spear86]

Hi,

The below code runs perfectly well for the 10 people that I have in my main file, I am now going to be doing same things for over 4.5k people and do not want to sit and do that for this many rows of data, essentially it is a vlookup through vba that needs to be done but cannot work it out anyone able to assist?

Please Login or Register  to view this content.

[mehmetcik]

Please Login or Register  to view this content.

[Spear86]

Hi Thanks for the response although that seems to not work when the one is matched to the column.

The Range on Home page is the one Cell as that is pulling through Username but within data source this is the 4.5k range

[zbor]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title go to your first post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)

[Spear86]

That is the post changed over

[Spear86]

Can you let me know if this is back online?

[zbor]

Yes, it's OK now.