Copy Paste Transpose from one workbook to other without replacing existing data

[yprasto]

Dear Friends

I'm newbie in excel VBA script. i'm making a script that :
1. Copy data from one sheet of workbook to another sheet of work book
2. Paste the data and transpose the data ( from column to row)
3. i can copy data from multiple sheet of workbook and paste to the same sheet of work book
i have tried making a script, but everytime it paste new workbook, it replace the existing data. my wish is to not replace and add the data to the next empty row . Here is the script, i wish someone could help to take a look and advice the error. many thanks in advance and appreciate the help

Please Login or Register  to view this content.

[cubangt]

If you are wanting to "Append" the data everytime, you need to determine the last row in the column where you are pasting the data so that it starts from there.

Finding the last used row you can do something like this: Replace the "A" with the column you want to use.

Please Login or Register  to view this content.

Then depending on where you need it, you can use it like so

Please Login or Register  to view this content.

[alansidman]

Code Tags Added
Your post does not comply with Rule 2 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)