Help me to Generate templates if cells are matched

I have described my forum thread to get solution for my task,i hope i can get help here



https://www.mrexcel.com/forum/excel-...statement.html

#14 thread from the above link

I have 4 Templates
i have a code which is working for only one template
i want my code to work with my multiple templates.(Input 1,Input 2,Input 3,input 4) this are the sheet tab names
only input 1 is working

E5:96+56 F5:65+68
E6:INPUT 1 F6:INPUT 2

If E5=E6 matched then INPUT 1 need to generate sheet
if F5=F6 matched then INPUT 2 need to generate sheet..similary 4 sheets
cells are from E5:AH6
here is my code for working for only 1 Template

Please Login or Register  to view this content.

Thanks for looking into my Thread, I hope i can get solution

Attaching a sample workbook enables others to work on your problem:

To attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

Click on GO ADVANCED and click "manage attachments" to open the upload window.


To add a file to a post

Here i have attached my workbook

I am not sure what you are asking for, are you just asking how to loop through those 4 sheets?

yes exactly when the cells are matched
INPUT 1,INPUT 2,INPUT 3,INPUT 4(These are Templates)
E6:AH6 have data validation check the cell in my workbook(USER CAN CHANGE (E6:AH6) ANY TEMPLATE THEN RUN MACRO)
E5:E6 matched with INPUT 1--->INPUT 1 Sheet (template) need to open for 40+652(Sheet tab name) rest of the sheets need to hide(its already written in code)
F5:F6 matched with INPUT 2--->INPUT 2 Sheet (template) need to open for 40+652(Sheet tab name) rest of the sheets need to hide(its already written in code)

You need to make it easier for people to understand what you are trying to do

i will solve it.