+ Reply to Thread
Results 1 to 4 of 4

macro to copy column A from multiple sheets onto summary sheet

  1. #1
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    macro to copy column A from multiple sheets onto summary sheet

    hi guys,

    can't for the life of me figure this out.

    i need to copy entirety of column A on multiple worksheets and paste to a separate summary sheet, it'd be super awesome if the macro could create that summary sheet.

    I'm unable to upload the document due to work restrictions!

    any help would be much appreciated!

  2. #2
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: macro to copy column A from multiple sheets onto summary sheet

    Do you want each column A pasted into a seperate column on summary sheet? or do you want the data added to the end of the first column data etc?

  3. #3
    Forum Contributor
    Join Date
    02-01-2011
    Location
    london, england
    MS-Off Ver
    Excel 2016
    Posts
    179

    Re: macro to copy column A from multiple sheets onto summary sheet

    pasted onto the end of the list in the same column please sir!

  4. #4
    Valued Forum Contributor Sean Thomas's Avatar
    Join Date
    03-25-2012
    Location
    HerneBay, Kent, UK
    MS-Off Ver
    Excel 2007,2016
    Posts
    971

    Re: macro to copy column A from multiple sheets onto summary sheet

    Hi,
    try this.
    Sorry took so long, busy at work.

    Sean
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1