Suhail
01-27-2013, 12:49 PM
I have a workbook with daily collection sheets. In Master sheet, I have some bank instruments numbers and amount. I have to find the customers name in Master Sheet. These customers are lying in difference sheets. The title of the sheet are based on date of collection i.e. 01.01.2013 represents collection of 01-Jan-2013
Please help me to find the customers name without consolidating all collection sheets. I want to write one formula on customers name column which find customers name from all sheets. If one formula not work, then it would be not possible to write 30 formula to find customers from 30 days collection sheet.
Please help me to find the customers name without consolidating all collection sheets. I want to write one formula on customers name column which find customers name from all sheets. If one formula not work, then it would be not possible to write 30 formula to find customers from 30 days collection sheet.