Transfer Data between sheets

**ryanb4614** · 07-21-2012, 01:29 AM

Hello. This may be confusing so I have made an attachment for everyone to view.
Basically I get a product spreadsheet that has thousands of products on it from my distributor. I also get a spreadsheet with my category names and id numbers. I have made a custom spreadsheet with the distributors default categories are for each product and then in the next column I put what my store will have the categories as. What I need to be able to do is transfer the id numbers to the product spreadsheet and replace the distributors category name with my category id number.

**Russell Dawson** · 07-21-2012, 02:17 AM

Hi

Why not use find and replace. Use a wildcard * and then identifying unique data in each product name replace with your code. Like this *flea* replaced by 251.

So, DOG FLEA POWDERS will be replaced by 251, the * will pick up "DOG" and "POWDERS" and recognise that "Flea" should be replaced by 251 and that's all that will appear.

Similarly, DOG HEALTH - BEHAVIOR AIDS can be picked up with *behavior* for 256

Etc . .

**ryanb4614** · 07-21-2012, 09:24 AM

That would be great to do. I usually have this done in macro. But with the new cart software this would not work because everytime I run a update the category id will change.

Please Login or Register  to view this content.

^^ what i would normally use.

**ryanb4614** · 07-21-2012, 11:25 PM

Is there a way if sheet 1 has this
Column A Aquarium Kits
Column B Fish Tank Kits

Sheet 2 has
Column A Fish Tank Kits
Column B 251

Can excel some way find the cell content in sheet1 "Fish Tank Kits" and replace in sheet 1 with 251 if they are in the same row in sheet 2?