Hi, I would highly appreciate, if someone help me out in this problem.
I've 4 sheets in a workbook having formulae. sheet1 has dropdown list of "dates". Formulae stored in all the sheets are related to these dates. when i select a date from list, values in all sheets change accordingly. But when I'm seeing the data on a sheet which doesn't have dropdown list, I've to go back to sheet1 to change date & come back to see the corresponding data. I want each sheet to have same dropdown list of dates, but connected to each other with some formula or vba, so that when I change date in any one sheet, same date gets automatically selected in the dropdown lists of other sheets also. I want to be able to select date in all of the sheets.