+ Reply to Thread
Results 1 to 5 of 5

Macro to populate summary sheet

  1. #1
    Registered User
    Join Date
    03-18-2011
    Location
    Dayton, ME, USA
    MS-Off Ver
    Excel 2004 for MAC 11.5.4
    Posts
    77

    Macro to populate summary sheet

    Hi,

    I am trying to crate a macro to populate a summary sheet so that I can compare several Publishers results together. (see attached file).

    Within the summary sheet the columns starting "400" all denote a publisher who has their own sheet within the workbook. All of the publishers sheets follow the same layout exactly.

    I need Cell B3 to populate from the last cell (with data) in Row 10 (of that respective pubs sheet)
    I need Cell B4 to populate from the last cell (with data) in Row 11(of that respective pubs sheet)
    I need Cell B5 to populate from the last cell (with data) in Row 12(of that respective pubs sheet)

    If somebody could get me this far I can certainly do the rest myself.

    Many thanks for any and all help.

    Cheers

    Jon
    Attached Files Attached Files

  2. #2
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Macro to populate summary sheet

    hi, endoskeleton, please check attachment, run code "test"
    Attached Files Attached Files
    Last edited by watersev; 05-03-2011 at 05:10 PM.

  3. #3
    Registered User
    Join Date
    03-18-2011
    Location
    Dayton, ME, USA
    MS-Off Ver
    Excel 2004 for MAC 11.5.4
    Posts
    77

    Re: Macro to populate summary sheet

    Watersev.

    That is excellent, thanks so much,

    One small glitch is that if a row is empty except for the header column in row A, the summary sheet populates as the text of the header row.

    How would I get it to ignore Column A and if a row is blank either populate nothing or '0'?

    Cheers

    Jon

  4. #4
    Forum Expert snb's Avatar
    Join Date
    05-09-2010
    Location
    VBA
    MS-Off Ver
    Redhat
    Posts
    5,646

    Re: Macro to populate summary sheet

    Please Login or Register  to view this content.



  5. #5
    Forum Guru
    Join Date
    11-29-2010
    Location
    Ukraine
    MS-Off Ver
    Excel 2019
    Posts
    4,168

    Re: Macro to populate summary sheet

    the code has been amended, please check it out
    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