PDA

View Full Version : Hyperlink and copy sheet based on specific criteria



fatalcore
01-20-2012, 05:42 AM
Hi,
I have a sheet called "before" and another maping sheet called "Metal Master".
And I have another three sheets called "Quotation A", "Quotation B", "Quotation C".
Now I want to generate links in column L in "before" sheet.
The problem is that I want to generate the links on the condition based on sheet "before" and "Metal Master".
If the value on column E and F from sheet "before" is equal to "Metal master" in column A and B then the templete of column C from "Metal master" ie Sheet "Quotation A" will be duplicated as "1 - Quotaion A" then "2 - Quotaion A" like this without disturbing the the original sheets ie."Quotation A", "Quotation B", "Quotation C" and so on
But the new sheets that are getting populated will need to also duplicate the row number 25 as per the samples given in Column K in the before sheet.
Basically the sheets to duplicate is mapped in sheet named "Metal Master". and the columns that need to be generated is given in column K in the "before" sheet.
I have uploaded a dummy sheet with before and after tabs for your reference.
Thanks in advance for all your help.