macro that deletes certain results

[dfrank]

I am making a macro that deletes #N/A's, but i want to add a few things to it
that should be deleted:

the phrases "total board", "total metal" and "Item", and any non-text (i.e. any
number) that appears.

this is what i have so far:

Please Login or Register  to view this content.

what do i add to meet my specifications? Any help is greatly appreciated.

[shg]

Please read our Forum Rules about thread titles, and then edit your thread title to be descriptive of your problem.

[dfrank]

Please Login or Register  to view this content.

I was given this code from a guy somewhere else, but it doesnt work and he dissapeared.

i basically want to delete the phrases "total board", "total metal" and "Item", and any number.

also, this is supposed to pertain to the entire worksheet, so i think his 'Selection' part of the code is not correct.

any help?

[shg]

Assuming that otherwise does what you want, then maybe like this:

Please Login or Register  to view this content.

[dfrank]

appreciate the response, but i get an error doing this. here is what i have:
\1
[URL=http://g.imageshack.us/g.php?h=389&i=midstep1hy0.jpg[/URL]

here is what happens when i use the code provided:

\1
\1 do not click second link. it is nothing.
i get an mismatch error 13.

any idea on how to fix this?

[shg]

Try this. If it doesn't work, please post a workbook with the code in it.

Please Login or Register  to view this content.

[dfrank]

eh, that deleted the whole worksheet

here is a synopsis of this workbook:

So the basic premise of this is that i need to transfer items from sheet Material to Proposal. think of Material as an inventory order list, and Proposal the invoice. The way i was able to construc this was to use a code given to me from someone else to copy the ones selected on Material over to 'MidStep.' This is found in column B. in column A, i detect the duplicates, and in column D I tell it to return the value from columb B IF Column A reads 'Original.'



this is where im at right now. i need to get rid of all the excess stuff other than the item names in columns D and F. once that is taken care of, i have a macro in line to sort them so they are all bunched together, then another macro to copy them over to Proposal. THEN I have a macro that runs both of the macros. And that is where i need it to end.



I know this might be confusing, and i greatly appreciate your efforts. Thanks a lot.

here is a link to my .xls, it was too big to attach to the message.

http://www.datafilehost.com/download-65edb2b0.html

[shg]

I'm not sure I followed all that, but try this:

Please Login or Register  to view this content.

[dfrank]

got it. thanks.

[shg]

You're welcome, glad it worked for you.