VBA Copy/PasteSpecial Between Workbooks

  • Hello, I am having some difficulty with programming what I thought would be a simple macro. I require the following:

    While in an open workbook(a) I will manually select a certain row.

    I will then click a button called "Archive" that will Copy the entire rows contents including format and delete the row from workbook(a).

    The macro will then open workbook(b) and paste the copied row into the next empty row.

    Workbook(b) will then save and close.

    Focus will return back to Workbook(a).

    Thanks in advance for the ideas!

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!