Process: You need to populate the data from the Overnight fund file and from the Liquid fund file to the base file (Performance Report.xls) in the corresponding sheets.
For Overnight fund data: Retrieve all details from the Overnight file then paste it from the I to V column in the base file(Sheet Name: Overnight Fund). Before populating the data, you must verify the scheme name column of both files(base file and overnight file), Once verified, then populate all column details to the base file(Sheet Name: Overnight Fund). Also need cell color for each rank column which is in less than 5. Maintain the same design & structure and cell colors for your output file.
Likewise,
For Liquid fund data: Retrieve all details from the Liquid file then paste it from K to Z column in the base file(Sheet Name: Liquid Fund). Before populating the data, you must verify the scheme name column of both files(base file and Liquid file). Once verified, then populate all column details to the base file(Sheet Name: Liquid Fund). Also need cell color for every rank column which is in less than 5. Maintain the same design & structure and cell colors for your output file.
Liquid File.xlsx (13.3 KB)
Overnight File.xlsx (13.8 KB)
Performance Report.xls (64.5 KB)