Need help using data from UserForm

[joshhud]

Hi all, multi part question. I have a UserForm, where the user selects 1 or more of 52 fields and i need those fields pasted as headers on another file. Originally i accomplished this with the code below, but i fee like there is a better way.

Please Login or Register  to view this content.

Secondly, i need to perform a vlookup to another dataset based on the fields they select. Currently i cannot think of a way to dynamically have it identify which field was selected and perform the vlookup from there. My only thought is to do something like this. But again i feel like there is a better way since field BA could be any of the available 52 fields. ( i only included 7 of the 52 fields below as an example).

Please Login or Register  to view this content.

Xpost
on Mr.Excel
Not sure how much activity either sites get

[jolivanes]

I was going to have a look how far they got on the MrExcel post but There is no hyperlink to it.

[joshhud]

I was going to have a look how far they got on the MrExcel post but There is no hyperlink to it. Too bad

Not allowed to post links because I'm new, but it's also a new post. No progress.

[jolivanes]

Re: "Not allowed to post links because I'm new"
Sorry about that. I was not aware of that because in the Forum Rules (#3) it mentions to add a hyperlink.
Have you read the "Forum Rules"? There is more interesting stuff in there.

[joshhud]

Yeah i thought that was interesting too, but alas i cant post links.

[torachan]

see big yellow banner - upload your workbook.
far easier then to give you a case specific solution.

[joshhud]

see big yellow banner - upload your workbook.
far easier then to give you a case specific solution.

This is, hands down, the least helpful forum. Yes i see the BIG yellow banner. I am not able to do so due to security implimentations on my work computer.

[Marc L]

As guessing can't be coding so the help is at the level of the initial post …

[Sintek]

This is, hands down, the least helpful forum.

Hundreds of thousands of others will disagree...Mind Readers...We are Not...
AFAIK...No coder can look at your specified code supplied and supply a solution without seeing your actual data layout...

I am not able to do so due to security implimentations on my work computer.

Solution...Make use of your private PC...