help with VBA codes to extract selected data from worksheet on specific conditions

Hello to all

I am new to this forum so first of all "A very warm hello" and I really really apologise if i am duplicating this OR posting this into a wrong thread..

Now, i have attached a datasheet which has got lots of column. (see Sheet1)

Want i want to achieve is, I have got a button on sheet2 called "Sue Hendry". I want my users to click on the button and wherever (on sheet1), Sue Hendry on column Y has got "Y", i want it to retrieve all the data for that. which is from column A to column S

Is this possible?

Eventually , i want to have a button for each heading from column T to column AC and it needs to do the exact same thing.

PLease, any help be appreciated

Hi, HarryC,

welcome to ExcelForum.

Just take a second to reflect on your thread title and image you yourself would do a search on that title: what would you expect as a result? Maybe take your time and change it according to the forum rules to something a bit more reflecting your problem, and I´m sure we will be able to help you with your problem.

Ciao,
Holger

@yudlugar

Hello there

Thanks a lot for helping me out

One last query please. Probably being thick here. How can i allow the second macro to retrieve the data for Dawn Gray for example. I have given the thought of retrieving the data in the same sheet. If you see on Sheet 2, I have got the data retrieved for Sue Hendry. What i would like to do now is click on "Dawn Gray" and it clears the data for Sue and retrieves the data for Dawn?

Is this possible. For example. i am attaching the latest sheet.

Thanks

Hi, yudlugar,

green light is on for you to help

jeffreybrown has requested a change of title, HarryC has responded to that and altered the thread title, so jeffrey deleted his post as he had stated in it because their no longer was a need for it.

Ciao,
Holger

Hi, yudlugar,

because some posts still have the old title.

From what I remember the posts are written into the database with the thread title that was relevant the moment they were posted keeping the identying number of the starting post. The database will update the thread title accordingly to keep the record set together but the change of thread title may only be achieved by Admins/Mods changing them manually. Any new post will feature the altered or actual thread title.

This procedure should be the same on all vBulletin boards.

Ciao,
Holger