Copy Sheet if data matches fanction

**mesutcan** · 10-05-2015, 06:15 PM

Hey everyone

I am working in a marketing agency where we focus on social media ads. As you can guess we have several ad formats in an example; for facebook- page like page post, flyer etc. For Twitter, promoted account, promoted Tweet etc..
Therefore, every ad format requires different banner sizes or character limits.

In my sheet 1 I have a drop down menu. In my sheet 2 I have banner sizes and creative specs for page post ad format. In my sheet 3 I have banner sizes for promoted tweet. However, these banner specs can fill more than 40 cells since its highly technical. So I can not say that for sheet 2 my formula needs to be from A1 to z 13. (It is better If I select almost the whole sheet by mouse)
What I want to do is; in my first sheet if I select Page like ad format from my drop down, I want to see automatically ad specs for that specific ad format only. Is this possible? I hope I was managed to explain myself clearly.

Thanks in advance.

**skywriter** · 10-05-2015, 11:58 PM

Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic

**mesutcan** · 10-13-2015, 02:47 PM

I have attached an example excel.
We have various ad formats that we use for campaigns which require different ad specifications. For example, for Facebook; in order to use “page like” advertisement we need 300x250 banner size with max 150KB size limit. To be honest, it’s a pain to find and send every creative spec to agencies since there are more than 30.

As I mentioned before, before starting campaigns we need to send creative specifications to the agency and they are start working on the banners. What I want to do is to create an excel file where everyone can find banner specs for every ad format.

When a person selects the campaign type I want to show that campaign type’s creative specs below. I want to import from other sheets of that excel. Is it possible? I added two more sheets ( Flyer and page post) to excel. So for example; if I select “flyer” from campaign type menu, I want to see the content from flyer sheet in my first sheet.

Many thanks,
Mesut