Anyone help with a simple excel macro

Efour · 4 Oct 2006 at 16:25

Im editing a mailing list, ive exported it from outlook to excel.

basically i have a list of people i want taken out on A4 paper, i dont have the original .doc

all i am doing is searching for names then deleteing the entire row

can anyone help me with a 1 key macro type thing that will hightlight the entire row where the cell containing the name is, delete it and shift the cell up one.

I dont think its hard but Ive completely forgotten everything but some of the most basic stuff.

thanks

Efour · 4 Oct 2006 at 16:26

oh the row width is upto CJ i think you need to know that

I appreciate this ill buy you a beer one day.

Efour · 4 Oct 2006 at 16:43

ah, thanks for the offer call me a sad case but its the companies client database and as much as i know theres no way on earth that you would copy it , its all this frigging company is worth

ehehe.

any other way of doing this or i'll do a qwik crash course in excel over dinner.

Sorry if i come across as a cowardly jobsworth idiot

.

Efour · 4 Oct 2006 at 20:43

thanks chaps, yeah i didnt word the original post that well

Im searching using the "find" tool thing for an email address then deleteing the entire rows worth of data. Its an export of the contacts address book from Outlook 2003. theres about 20 or so coloumns worth of junk im not interested that im getting rid of too.

Most of my time is taken up by highlighting the entire row right clicking delete and shift cells up.

so wanted a shortcut i could press that after i have found the offending row that simply selects all of it, deletes it and shifts the cells up one.

ill try this in the morning it sounds promosing

appreciate the help !