build user list from spreadsheet

[lordriel]

I am looking the vba code to loop through a column (say column H) on sheet1 and output them in column A on sheet2.

The data in column H on sheet1 will contain multiple instances of the same usernames; I need to build a list of unique names.

I've tried a couple bulky methods be nothing seems to work the way I want it to.

any help will be appreciated

 

[SanjayGMusafir]

Update your current Excel Version and platform in your profile to help you in a better way. You can use link from my signatures to quickly navigate.

 

[lordriel]

Update your current Excel Version and platform in your profile to help you in a better way. You can use link from my signatures to quickly navigate.

Done. Thank you.

 

[SanjayGMusafir]

Done. Thank you.

I believe you did it but forgot to save - As it is still not appearing...

Request you to do again and Remember to save.

 

[lordriel]

redone and checked

 

[SanjayGMusafir]

The data in column H on sheet1 will contain multiple instances of the same usernames; I need to build a list of unique names.

Rather than using a VBA I suggest use formula that will be dynamic -

=UNIQUE(Sheet1!H:H)

Just in case you want it sorted then try this -

=Sort(UNIQUE(Sheet1!H:H))

 

[lordriel]

Unfortunately I can't easily post sample data, since I can't install the necessary files due to IT restrictions.

I'm attempting to build a macro that will create a list of all users (with multiple instances) listed in one column, and build relevant data from that list from the report.

I'll continue slugging through until I find the right answer.

Thank you for your input!