sindhuja
12-22-2011, 09:19 AM
Hi,
Please assist with the below requirement.
Set of fields for which value to be retrieved based on the company code and the month.
Eg. Company code - 1000, month - Jan. These are the two condition fields for which values like Value 1, VAlue2, Value3.....Value 6 inputs to be retrieved in a sheet named consolidate. source data to retrieve the values will be in the same file with the sheets named as month. In this case, the criteria is "Jan" hence it should retrieve the values from the Jan sheet.
Similarly if i change the company code the field values should change accordingly
- Sindhuja
Please assist with the below requirement.
Set of fields for which value to be retrieved based on the company code and the month.
Eg. Company code - 1000, month - Jan. These are the two condition fields for which values like Value 1, VAlue2, Value3.....Value 6 inputs to be retrieved in a sheet named consolidate. source data to retrieve the values will be in the same file with the sheets named as month. In this case, the criteria is "Jan" hence it should retrieve the values from the Jan sheet.
Similarly if i change the company code the field values should change accordingly
- Sindhuja