Hi,
I need your opinion on if similar Vlookup funciton can work for the problem listed here.
I would like to create several automated excel reports based on the master data sheet-sheet1 . The master data sheet has three/four variable that gets populated in the reports(sheet2); one for each...
Thanks for your help. This is very structurered and well organized forum and has a great knowledgebase. I am very impressed.
I am attaching the link to the sample sheets. The field highlighted in the sheet1 needs to appear in sheet2. sheet2 is needed for all the data rows in sheet1...
I would like to create several automated excel sheet(reports) based on the master data sheet. The master data sheet has three/four variable that gets populated in the reports; one for each employee.
I am totally new to Excel and this forum. Please help. Not sure where to attach the sample data...