+ Reply to Thread
Results 1 to 4 of 4

Input Data from Separate Worksheets to Summary Sheet

  1. #1
    Registered User
    Join Date
    10-22-2012
    Location
    washington, dc
    MS-Off Ver
    excel 2010
    Posts
    4

    Input Data from Separate Worksheets to Summary Sheet

    Help! I am back to ask the Excel VBA Gods to help me with my issue.

    I am trying to import columns E (Element 1), F (Element 2), G (Element 3) and J (Comments) from worksheets DA01, DA02, DA03 and DA04 into Summar worksheet (same column order); however, are you ready for the kicker, the rows do not match. Oh, and I would like to use this code for other workbooks with more worksheets and names, but same problem.

    This is above my teeny tiny knowledge of VBA and I have had tons of success using this board, so I thought I'd try again and save what little brain cells I have for the fun stuff.

    I appreciate everyone's time and help.
    Attached Files Attached Files

  2. #2
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Input Data from Separate Worksheets to Summary Sheet

    Yes, this should work for you,
    Please Login or Register  to view this content.

  3. #3
    Registered User
    Join Date
    10-22-2012
    Location
    washington, dc
    MS-Off Ver
    excel 2010
    Posts
    4

    Re: Input Data from Separate Worksheets to Summary Sheet

    Dave,

    Thanks so much for the quick response. It is almost perfection. The code does bring all the worksheets back into the summary sheet (this I did ask); however, code adds the rows to the bottom of the Summary worksheet without deleting the originals. This would do the trick if I could only figure out how to delete the original rows and input the new data from the worksheets.

    I truly appreciate your time and patience.

  4. #4
    Forum Moderator davesexcel's Avatar
    Join Date
    02-19-2006
    Location
    Regina
    MS-Off Ver
    MS 365
    Posts
    13,475

    Re: Input Data from Separate Worksheets to Summary Sheet

    This will clear the contents first
    Please Login or Register  to view this content.

+ 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