Ok, I think I understand. Tell me whether this is right:
Quote:
|
I have a worksheet name in A1, and some data in A2 and A3. In A4 is a button. I'd like the button to cause Excel to cut the data from A2 and A3, and paste it to cells in the worksheet named in A1.
|
Is that right so far? That doesn't sound too hard. But then you said that after the paste, "the line must go to next line I mean in order". What does that mean? By "the line", do you mean what's displayed to the user, or the data that's already been moved to another worksheet?