How to extract a specific data range form multiple sheets in excel : I have an excel sheet with four additional sheets
sheet1
sheet2
sheet3
summary (sheet4)
The first three sheets have a column of age. At the summary sheet i want to age data as age group ( 18 to 25, 26 to 33 etc..). I know how to get age group range from single sheet, but don't know how to get (exmp:18 to 25 from sheet1+sheet2+sheet3)a range from multiple sheet.
Please try to understand my question and please answer without VB code.
Thanks