Hello everyone.
I have been searching for days with now succes on how to conditionally pull the data from one workbook1 to workbook2 with a named range, depending what data cell C4 contains in the workbook2. C4 would have the name range wich would be CHART, and that range is in another workbook from cell C3:F14. Is there a way a formula or a macro could paste that range onto workbook2?
Best regards. John