Macro file to search CSV and then re save

[Michael!]

Hello,

Not sure if this is even do-able but worth asking as it would make my life a lot easier....

I have a program that sends out questionnaires (for staff appraisals) Users fill in their answers and then submit the form.

I then download the submitted answers in csv format. Once it is downloaded I need to find one specific person from the list and move them to the top row then save the file as an excel spreadhsheet.

At the moment I am doing this manually. Can anyone think of a way to run something so I basically select the file I want to run it on then type in the name of the person to move and it moves it and saves the file as an .xls?

Any ideas?

Cheers guys

[Michael!]

I think I have actually done most of this with a macro but I want to have the search box come up each time! At the moment the macro is recorded with the word test as what it searches for.

Is there a way to prompt for it to ask what to search for?

[Michael!]

p.s here is the Macro:

Please Login or Register  to view this content.

[JBeaucaire]

Try this:

Please Login or Register  to view this content.

You should edit the post above and change those [QUOTE] tags to [CODE] tags.

[Michael!]

[QUOTE=JBeaucaire;2411686]Try this:

Please Login or Register  to view this content.

You should edit the post above and change those

tags to [CODE] tags.

That's the exact find of thing I am after

Although it is deleting the row rather than moving it to the location and I cannot work out which bit of the code is doing that?

[JBeaucaire]

It's copying the cells with data in them on that row to cell AX3, look over in AX3.

Using words, can you describe what it's supposed to a little more clearly? Or post a sample worksheet with a BEFORE/AFTER example?

[Michael!]

It's copying the cells with data in them on that row to cell AX3, look over in AX3.

Using words, can you describe what it's supposed to a little more clearly? Or post a sample worksheet with a BEFORE/AFTER example?

I know its been a while but this ahs cropped up again I will try and explain in the easiest of bullet points

Open Spreadshet
There will be about 6 rows of data each of which is assigned to a specific person

I will have a specific person from that 6

I need to move the row that specific person is on to the top of the list

File then needs to be saved as an .xls

The person is different each time so I will need to be prompted each time on who/what to search for.

I have attached a spreadsheet you can see John Smith in the middle of the list before then at the top of the list after.

Thanks for the help

[Michael!]

Any help at all on this?

[snb]

I dont think the tread title matches your question anymore.
See the attachment.
Enter an 'a' in column G adjacent to the person you want to be 'promoted'., Enter