$$Excel-Macros$$ Macro to create hyperlinks to the master-sheet items to link the Details-Sheet items in a workbook

same. Any help much appreciated. Thanks, Vijay Gande -- Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ https://www.facebook.com/discussexcel FORUM RULES 1) Use concise, accurate thread titles. Poo

$$Excel-Macros$$ Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Hi there, I'm amateur with excel macros and need help with the following task, I've an excel workbook with 16 sheets, all the sheets have same # of columns but different # of rows. My task is to copy the data from each of these 16 sheets and past in the consolidate sheet in the same workbook

$$Excel-Macros$$ Re: Copy all the dynamic rows from multiple sheets and past in the “Consolidated” sheet

Hi, The macro is doing exactly what I'm looking for, can you please add a condition to skip copy and past if the worksheetName = "RTA" Or worksheetName = "Pivot" Appreciate your help in advance. Thanks, Vijay On Monday, 22 July 2013 11:26:49 UTC-4, Vijay