Ok, I think we're almost there. Let's try this new description:
Quote:
When I hit the Save button, I want it to do the following:
- Get the name of the target worksheet from A4
- Cut the data from A2 and A3.
- Go to the target worksheet.
- Find out which column is the next one available, and paste the data there. For example, if there's data already in column A through column E, then paste the data into F2 and F3.
|
How's that?