El_Diabolo
11-11-2013, 05:52 PM
Hi all,
This is a resurrection of a question I had three years ago with which I gave up, because despite help and assurances from some very good people, I simply could not get it to work.
I don't propose posting any data or code at this stage as I believe the issue is purely a technical one, which I am clearly too dumb to solve.
Back then I was using Excel 2003,but now use Excel 2010. I believe 2003 may not have supported what I was/am trying to do, as follows:
I have a combo box on Sheet 2 which is validated against data on Sheet 1, BUT what I had to do was copy and paste the Sheet 1 data into Sheet 2 using VBA on Worksheet_Activate.
It all works just fine except that the fly in the ointment is that whenever I create a new data row on Sheet 2, after having used the combo box and populated the other fields on that row, the newly added row causes the pasted Sheet 1 data to move down a row, which beheads the pasted data. This means that the next time I use the combo box the top entry has disappeared. Ad infinitum. So, my question is how do I get my combo box pointed to the data on Sheet 1 so that I can stop the copying/pasting. I have been trying all day to solve it, but just keep going round in circles. This just MUST be so simple, but I cannot see how to do it. I have searched the net and forums and still cannot manage it. Any help would be greatly appreciated, no matter how stupid it may make me look and feel.
Best regards.
This is a resurrection of a question I had three years ago with which I gave up, because despite help and assurances from some very good people, I simply could not get it to work.
I don't propose posting any data or code at this stage as I believe the issue is purely a technical one, which I am clearly too dumb to solve.
Back then I was using Excel 2003,but now use Excel 2010. I believe 2003 may not have supported what I was/am trying to do, as follows:
I have a combo box on Sheet 2 which is validated against data on Sheet 1, BUT what I had to do was copy and paste the Sheet 1 data into Sheet 2 using VBA on Worksheet_Activate.
It all works just fine except that the fly in the ointment is that whenever I create a new data row on Sheet 2, after having used the combo box and populated the other fields on that row, the newly added row causes the pasted Sheet 1 data to move down a row, which beheads the pasted data. This means that the next time I use the combo box the top entry has disappeared. Ad infinitum. So, my question is how do I get my combo box pointed to the data on Sheet 1 so that I can stop the copying/pasting. I have been trying all day to solve it, but just keep going round in circles. This just MUST be so simple, but I cannot see how to do it. I have searched the net and forums and still cannot manage it. Any help would be greatly appreciated, no matter how stupid it may make me look and feel.
Best regards.