Hi
I have a cell in my first tab say C2 that contains a drop-down list in it that looks at data. This data for example could be a set of years e.g. 1920, 1930, 1940, 1950 and so on.
I have a second tab (a1) that is updated from a database.
And a third tab (a1) that will update the same database usnig the data in c2.
Here's my problem: I want to import data into my second tab. If the data is different to what is in C2 I want C2 to automatically default to it, without touching it.
i.e. if it was shownig 1920 and the new data in the second tab is showing 1935 etc then C2 must show without clicking into it the new data i.e. 1935.
I need this automated in such a way that there is no need to press any buttons to run a macro. It just does it the moment that data arrives in the second tab.
If the data is changed by the user then it should update the third tab A1.
Any answers much appreciated.
I have a cell in my first tab say C2 that contains a drop-down list in it that looks at data. This data for example could be a set of years e.g. 1920, 1930, 1940, 1950 and so on.
I have a second tab (a1) that is updated from a database.
And a third tab (a1) that will update the same database usnig the data in c2.
Here's my problem: I want to import data into my second tab. If the data is different to what is in C2 I want C2 to automatically default to it, without touching it.
i.e. if it was shownig 1920 and the new data in the second tab is showing 1935 etc then C2 must show without clicking into it the new data i.e. 1935.
I need this automated in such a way that there is no need to press any buttons to run a macro. It just does it the moment that data arrives in the second tab.
If the data is changed by the user then it should update the third tab A1.
Any answers much appreciated.
