Hi all!
I'm trying to create a table in workbook1 in which one of the columns shall have a data validation based on the name of the Sheet in workbook2. workbook2 has several sheets that has the exact same columns. (yes, why not consolidate all these sheets into one, making the sheet names the values in an extra column in that consolidated sheet? my colleagues insists on keeping the sheets separate since each list in each sheet are themselves very long).
Then, additional columns in workbook1 will be populated on the basis of the columns in each sheet of workbook2. How can this validation be achieved?
I'm trying to create a table in workbook1 in which one of the columns shall have a data validation based on the name of the Sheet in workbook2. workbook2 has several sheets that has the exact same columns. (yes, why not consolidate all these sheets into one, making the sheet names the values in an extra column in that consolidated sheet? my colleagues insists on keeping the sheets separate since each list in each sheet are themselves very long).
Then, additional columns in workbook1 will be populated on the basis of the columns in each sheet of workbook2. How can this validation be achieved?