Hi Fellows
My question for todays post is how to consolidate the referencing in Excel. For example if you have mixed data in 3 sheets and you want to consolidate these 3 sheets into one sheet with relevant sheet reference how we do it in Excel 2003.
All sheets have following head rows...