Macro Linking, possibly if/and statements

**hodorhodorhodor** · 12-28-2017, 02:52 PM

Hi everyone,

I am a little confused on this.

I have a few workbooks with data i am trying to consolidate into one Master file. on one file have a "cheat sheet" that has a list of everything in the correct format i want but the problem is it is slightly different than the workbooks with the different data. So i want to do something like "If cell D7 in workbook 1 says "Big Cat 1", cell E10 in the Master file will say the word "Tiger" (which is Big Cat 1)."

There are 8 different possible types of Cats in my cheat sheet. is there a way to do this? Also if my request is confusing please let me know, because im confused by it too!

I attached a rough template of what im trying to do but put them on different sheets. would that make a difference?

**hodorhodorhodor** · 12-28-2017, 02:55 PM

I guess i couldnt attach the file

**Zer0Cool** · 12-28-2017, 03:02 PM

hit go advanced and scroll down there should be an upload/attachment option. Having a sample would greatly help.

**hodorhodorhodor** · 12-28-2017, 03:05 PM

When i click on the attachment option, i just get a white line and i cant attach anything.

**Zer0Cool** · 12-28-2017, 03:09 PM

hit go advanced, scroll down to manage attachments, then at the top is a button to choose file. Navigate to the file and hit ok. Then on far right hit upload button, then at the bottom close button. Then submit your post and the attachment should be there