Hi,
I have 2 workbooks "Team" and "1.10 Filename".
In the workbook "Team" - A4:A64 the list of all the teams, B4:K64 the Team's performance data
In the workbook "1.10 Filename" there are 10 Pivots having two columns A & B (Range varies for every pivot) in each sheet. Column A Of each pivot contains the Team name and the column B contains the performance data.
In the "Team" workbook i have put a vlookup for each pivot data in 1.10 Filename workbook. From B5:K64 i will have the Vlookup data from all the 10 pivots of "1.10 Filename" work book.
My Requirement is that everyday a new day file will be pasted in the folder where 1.10 Filename is present. That is system generated file and will contain the same team name which are in 1.10 filename but the data will be of the next day and the filename would be "2.10 filename".
Is there a way where in when i select the date (i.e., the filename through the validation drop down (B2)) the data of that Pivots should be displayed in B5:K64.
If i select 3.10 it has to pull the data from the "3.10 Filename" and so on...........
Is this possible through the spreadsheet snapshot which i have prepared in "Team" workbook or is there any way which i can present this in a attractive way.....
I have 2 workbooks "Team" and "1.10 Filename".
In the workbook "Team" - A4:A64 the list of all the teams, B4:K64 the Team's performance data
In the workbook "1.10 Filename" there are 10 Pivots having two columns A & B (Range varies for every pivot) in each sheet. Column A Of each pivot contains the Team name and the column B contains the performance data.
In the "Team" workbook i have put a vlookup for each pivot data in 1.10 Filename workbook. From B5:K64 i will have the Vlookup data from all the 10 pivots of "1.10 Filename" work book.
My Requirement is that everyday a new day file will be pasted in the folder where 1.10 Filename is present. That is system generated file and will contain the same team name which are in 1.10 filename but the data will be of the next day and the filename would be "2.10 filename".
Is there a way where in when i select the date (i.e., the filename through the validation drop down (B2)) the data of that Pivots should be displayed in B5:K64.
If i select 3.10 it has to pull the data from the "3.10 Filename" and so on...........
Is this possible through the spreadsheet snapshot which i have prepared in "Team" workbook or is there any way which i can present this in a attractive way.....
