Results 1 to 1 of 1

Thread: copy and paste (only values) macro

  1. #1
    Acolyte toony's Avatar
    Join Date
    Mar 2014
    Excel Version
    Excel 2016

    Unhappy copy and paste (only values) macro

    Register for a FREE account, and/
    or Log in to avoid these ads!

    I need to automate an everyday action, to copy and paste the values of random columns from another worksheet. The headings (don't want to copy paste them) are the same. The copied workbook I populated every day and I require these column values into an annual workbook. So, they have the columns in different order one to another, and the row numbers also differ. I don't know anything about macros and all I did was to press Record Macro (chosed relative references), but when I run it the values are pasted very randomly anywhere. I have attached the VBA code. I would be sooooo grateful if somebody can help me with this.
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts