+ Reply to Thread
Results 1 to 3 of 3

help loading data from 2 different sheets on one workbook

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

    help loading data from 2 different sheets on one workbook

    Im creating a backup macro for my workbook. My program saves data to a new workbook on sheet1 and sheet2 because they come from 2 different sheets. I'm trying to now load that data back in again and cant figure out how to transfer them back. I can load form one sheet just fine, i can even load from one sheet from 2 or more different workbooks fine but i'm having issues loading from one workbook on 2 different sheets. Here is my load code:

    Please Login or Register  to view this content.
    here is the other code it calls on to open worbooks or .txt files

    Please Login or Register  to view this content.
    I know i'm not telling it what sheet to look at and cant figure out how to do that.

    The original is too big to upload but here is a simplified example on one workbook. Remember sheet1 and sheet2 are going to be on a different workbook than 'importdata' and 'start page'.
    I want to select everything on sheet1 to goto sheet 'import data' from a1 to ca71821, and everything on sheet2 to goto sheet 'start page' starting at c5 to g131.

    If there is an easier way to do this them i'm all ears as to how to do it.
    Attached Files Attached Files
    Last edited by kevinu; 12-11-2018 at 12:10 PM.

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

    Re: help loading data from 2 different sheets on one workbook

    in case you need it. Here is the code i use to export the data to begin with.

    Please Login or Register  to view this content.
    I basically want to put the data back where it came from
    Last edited by kevinu; 12-11-2018 at 12:15 PM.

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

    Re: help loading data from 2 different sheets on one workbook

    i figured a way around the problem. I now save everything on one export.

+ 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. [SOLVED] Power Query loading sheets inconsistently
    By armlegx in forum Excel General
    Replies: 9
    Last Post: 05-08-2018, 01:24 PM
  2. Replies: 2
    Last Post: 11-28-2017, 04:58 AM
  3. [SOLVED] Loading amounts from various sheets into another sheet
    By Alac61 in forum Excel General
    Replies: 4
    Last Post: 11-12-2015, 03:58 AM
  4. [SOLVED] Multiple excel data loading to seperate workbook
    By ranjan20 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-09-2015, 06:15 PM
  5. Replies: 1
    Last Post: 07-23-2015, 10:15 PM
  6. Macro for saving / loading values between sheets
    By bell123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-25-2011, 02:41 PM
  7. Replies: 4
    Last Post: 08-17-2006, 01:30 AM

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