+ Reply to Thread
Results 1 to 6 of 6

save date from 2 different tabs to one new excel file??

  1. #1
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    save date from 2 different tabs to one new excel file??

    I'm trying to create a backup macro that copies data from 2 different sheets in my program onto one new workbook. Then be able to later load the saved data back in. I'm working on the saving part now and I'm stuck getting the data out. Im using

    Please Login or Register  to view this content.
    workRng2 isnt copying or pasting onto tab 2 of the new workbook. Any ideas? I dont want to have to save the data on 2 seperate workbooks if possible.

  2. #2
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: save date from 2 different tabs to one new excel file??

    Please Login or Register  to view this content.
    does new workbook come with two worksheets?
    i know that default changed to 1 from 3 with Excel 2010 on wards
    If you are satisfied with the solution(s) provided, please mark your thread as Solved.
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

  3. #3
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    Re: save date from 2 different tabs to one new excel file??

    the end file only has one. Not sure how to make it 2

  4. #4
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: save date from 2 different tabs to one new excel file??

    if its only your computer you can just simply change your default settings to be 2 sheets instead of 1

    alternatively add Worksheets.add into your code
    something like

    Please Login or Register  to view this content.

  5. #5
    Forum Contributor
    Join Date
    03-10-2017
    Location
    USA
    MS-Off Ver
    office 2016
    Posts
    393

    Re: save date from 2 different tabs to one new excel file??

    Brilliant thanks

  6. #6
    Forum Expert
    Join Date
    08-12-2012
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    5,637

    Re: save date from 2 different tabs to one new excel file??

    Cheers
    Thanks for the rep

+ 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. Macro to PDF multiple tabs and save in same file as the template is saved in
    By kdobler in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-21-2018, 11:16 PM
  2. [SOLVED] Macro to save file - save name from cell containing a date using different date formatting
    By d_max_c in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-15-2014, 12:18 PM
  3. Replies: 2
    Last Post: 05-06-2013, 06:41 PM
  4. What to save a text file in to preserve all tabs
    By almilw in forum Excel General
    Replies: 0
    Last Post: 11-09-2012, 05:39 PM
  5. [SOLVED] How to save an excel file to PDF with previous day's date?
    By alexgempesaw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 10-28-2012, 02:34 PM
  6. [SOLVED] Macro to save Excel file with date and time in the file name?
    By sonic_d_hog in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 01-05-2006, 02:00 PM
  7. Save excel file as current date
    By webbey21 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-16-2005, 11:06 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