Need spreadsheet to find similar names and copy/paste to another page

**bellicusa** · 12-15-2011, 11:48 AM

Hello everyone.

I am looking to automate what has become a very time consuming task.
My company makes a lot of different products. Most end up good and are sold.
Some end up with problems and we have a process to blend in a predetermined amount of the old bad with a new batch.
Keeping track of our production schedule compared to the inventory we have to work off is daunting.

I have attached a sample of our production schedule (Sheet 1 attached) along with a sample of our out of spec material (Sheet 2).
What I would like is the ability to paste in a copy of the production schedule to overwrite what is there and have it automatically recalculate to sheet 3.
I would also like the ability to copy and paste a new list of out of spec material over top of sheet 2 as it changes.

The way I think it could work would be to look at each product name on the schedule. Compare that name to the list of out of spec material. If an out of spec material has the same name (except whatever is in parenthesis), copy the relevant information to sheet 3.

The columns on the production schedule are (A) the date we plan to manufacture the product. (B)The day of the week that falls on. (D,F,H,K,M,O) The product name sometimes with parenthesis after it and (E,G,I,L,N,P)the amount to produce.

Please let me know if there is other information that is needed.

Thanks in advance,
Anthony

**bellicusa** · 12-16-2011, 10:51 AM

If what I was looking for before was too much/not realistic/impossible to understand based on how I explained it...maybe I could reduce the request.

1. On the schedule (sheet1) and Rework list (sheet2) the same products can show up with different names. In other words "Diexter-G TF-52" is the same as "TF-52" is the same as "TF-52 (B)". Is there a way to look inside each cell to make it possible for excel to see each of those as the same item?

2. If it is possible, how would/could I use that item from sheet1 to look for a match on sheet2?

Thanks again,
Anthony

**bellicusa** · 12-19-2011, 09:55 AM

Pushing this up again in hopes that someone can help or give a direction for me to go.

Thanks,

Anthony

**Fotis1991** · 12-19-2011, 11:21 AM

Hi Anthony

Which are the columns that you want to compare??(Sheet1--column?>>>>>>Sheet2--column??)

**bellicusa** · 12-19-2011, 11:59 AM

I would like to compare every cell from Sheet 2, column B with every cell from Sheet 1, columns D,F,H,K,M,O.
The names are only similar though. There are differences like I explained in another post.

If a match is found, copy the Sheet 2 row and the Sheet 1 row to Sheet 3 so I can see the match.

Sheet 3 would then be a list of every time a match is found.

Example:
Sheet 2, B114 is "DIEXTER-G TF-52 2500 LB TOTE"
The only part of this that will remain constant is the TF-52.
Sheet 1, F8 is "TF-52 (B)"
The part of that that I need to match again is the TF-52.

I would like to have the spreadsheet see that match, then copy over the rows from each Sheet to Sheet 3.
This would allow me to see the matches so I will know which day they will happen.

Sorry if this is hard to understand. I know what I would like to see, but am having a hard time explaining it.

Thanks,
Anthony

**bellicusa** · 12-20-2011, 01:12 PM

Ok, not having a lot of luck looking at this process the other way...so possibly from a different direction.

What I do manually every day...sometimes a few times a day is:

Look at every item one at a time on the schedule page. I then try to find that matieral on the material page. If I find it I write down every date we are making so I can pass that information to someone else.

The logic I am trying to get excel to use:

Look at the first entry on the schedule page.
In this case it is 6600-37 (D)
Look for 6600-37 to appear on the materials page in column B.
If it is found, put the date when it is on the scheduled on the materials page in H118.
So, using this sample I would like to have June 2 put in H118.

Let me know if that makes sense.

Thanks again,
Anthony