Userform to Export Certain Data

Hi All

Can anyone help?

Im new to userforms but i think this is the best way to approach this?....

I have a spreadsheet which has data dumped into it on a daily basis. The key feature of this spreadsheet is the column containing a week no (1-52)

Because of the amount of data being stored each week What I would like to do is create a user form where the user could select a Week No from a dropdown list, or type it into an input box and then click a command button which would send all the data for the required week into a seperate sheet.

Is this possible? If so could you possibly help point me in the right direction?

Hello RicRec,

Will the data on the new sheet be in a single column also?

Thanks,
Leith Ross

Hi Leith

Well the spreadsheet data is actually formed of 5 columns, i was hoping that the column containing the week no could be used in a way similar to a vlookup if that makes sense?

So by entering or selecting say week number "42" all the data with week no "42" in the relevant column would be sent across to the new sheet.

Hello RecRic,

Could you post your workbook so I can better understand what data is where?

Thanks,
Leith Ross

Thanks for that Roy

I will post the spreadsheet in the morning Leith as its on my other laptop at the moment

Roy i will let you know how i get on!

Thanks guys

Hi Rob/Leith

Rob that code you provided worked a treat, the week number wasnt in Column A but i managed to change the code easily.

Just one quick follow up, if you dont mind, if i wanted have a list in the combobox of say names instead of a number range what would the code look like

i.e

For i = 1 To 52 (As it currently is) would change to something like For i = North,South,East,West ??

Thanks again chaps

Thanks Very Much Rob

Have a good xmas :-)