+ Reply to Thread
Results 1 to 15 of 15

copy additional data

  1. #1
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    copy additional data

    Hello Forum, I use the following VBA to open each file in a specified location and copy certain data from each file to a new File.

    Please Login or Register  to view this content.

    I need it to also copy from each file, when opened, additional data and save as shown in the example attached. The data from each file's cells noted in red. Please let me know if that makes sense. Thanks for your help.
    Attached Files Attached Files
    Last edited by Pepe Le Mokko; 02-06-2020 at 03:36 AM. Reason: We knwo you are looking for help. title amended

  2. #2
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Hoping I explained this well enough. Please let me know if it makes sense as what I need. Thank you for looking at it.

  3. #3
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copy additional data

    What is the organization of the data in the workbooks you are going to open and copy this data from? Can you provide a corresponding sample of one of those files?
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  4. #4
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Hello, Here is one of the files, all files will be the same format. They will all have a different number of House Bills, But row 35 would be the last row used in each file.
    Attached Files Attached Files

  5. #5
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copy additional data

    Testing a solution to this now.

  6. #6
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Quote Originally Posted by 6StringJazzer View Post
    Testing a solution to this now.
    Thank you very much!

  7. #7
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copy additional data

    You will need to tweak the formatting in the New file to be how you want it. I only tested this with one sample file. It does not appear that your code replicates the column headings for each new file, and that the ones in your New file were put in manually. Not quite sure what you wanted to do there.
    Attached Files Attached Files

  8. #8
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Thanks Again, I really appreciate your time. I will be testing it out today in a little bit.

  9. #9
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Quote Originally Posted by 6StringJazzer View Post
    You will need to tweak the formatting in the New file to be how you want it. I only tested this with one sample file. It does not appear that your code replicates the column headings for each new file, and that the ones in your New file were put in manually. Not quite sure what you wanted to do there.
    Hello, In testing this is working with a few issues. I may not have been clear on the end results. For each file opened I need it to copy the data as shown below. I know this code will not work but this is the additional needed data from each file. The heading would be replicated for each new file on the next row down. Hope that explains a bit more.

    Please Login or Register  to view this content.

  10. #10
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Sorry this may explain a bit more the end result I am trying to get to. Please see the attached
    Attached Files Attached Files

  11. #11
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copy additional data

    My version didn't repeat the headings for each new file, but it did pick up all the rows of data. What am I missing?

  12. #12
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    That is what I am needing to get to, is the headings for each new file. It did pickup all the rows, but not the split between each.

  13. #13
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copy additional data

    Take a look at this.

    I put in conditional formatting that adds the top and bottom borders for the headings, but you still need to adjust the other formats the way you want them (red colors, date formats, etc.).
    Attached Files Attached Files

  14. #14
    Forum Contributor
    Join Date
    09-28-2016
    Location
    Seattle, washington
    MS-Off Ver
    2016
    Posts
    330

    Re: copy additional data

    Quote Originally Posted by 6StringJazzer View Post
    Take a look at this.

    I put in conditional formatting that adds the top and bottom borders for the headings, but you still need to adjust the other formats the way you want them (red colors, date formats, etc.).
    Excellent! Great work as usual. I really thank you very much for this. Have a great weekend.

  15. #15
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: copy additional data

    Happy to give you a freebie after all the paid threads

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. VBA copy header to all additional worksheets
    By Dahlia in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-23-2016, 09:27 PM
  2. [SOLVED] VBA to return to last ACTIVE Worksheet to copy additional data
    By Seaplane Jack in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-25-2016, 07:01 PM
  3. [SOLVED] VBA Need help with additional loop to copy range to different worksheet
    By Old-One in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-14-2014, 05:19 PM
  4. Replies: 1
    Last Post: 02-06-2014, 03:00 PM
  5. [SOLVED] Auto save additional copy with date as name
    By alfgrey in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-13-2013, 06:38 PM
  6. Copy/insert additional data entry rows
    By CLEE7093 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-25-2012, 08:57 AM
  7. Copy an additional row based on another sheet
    By Mindie in forum Excel General
    Replies: 5
    Last Post: 10-18-2005, 10:05 PM

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