+ Reply to Thread
Results 1 to 3 of 3

Copy data from one spreadsheet to another

  1. #1
    Registered User
    Join Date
    11-05-2014
    Location
    Lancashire
    MS-Off Ver
    2007
    Posts
    6

    Copy data from one spreadsheet to another

    Hi
    I have two spreadsheets one I upload to the cloud for the sales team to use. The other is an ODBE spreadsheet from sage.
    I am hoping that the ODBE spreadsheet will update automatically from sage.

    Is there a formula I can use to get the relevant data from the OBDE to the upload sheet. Such as stock quantity and prices

    Both files are indexed on the product code but the ODBE file is likely not be constant as I add and remove codes.
    Any help would be appreciated
    David

  2. #2
    Registered User
    Join Date
    10-21-2012
    Location
    United States
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Copy data from one spreadsheet to another

    Is this a Vlookup candidate?

  3. #3
    Registered User
    Join Date
    11-05-2014
    Location
    Lancashire
    MS-Off Ver
    2007
    Posts
    6

    Re: Copy data from one spreadsheet to another

    Hi jasper90
    Thank you for pointing me in that direction.
    I have read up and watched a couple of tutorials. All I have to do now is put it into practice.
    Regards
    David

+ 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. Replies: 2
    Last Post: 12-15-2011, 02:10 PM
  2. Replies: 4
    Last Post: 02-27-2011, 03:58 PM
  3. Copy data from one spreadsheet to another...
    By dauren in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 11-05-2009, 05:54 PM
  4. Copy data from spreadsheet to new worksheet in different spreadsheet.
    By Davie1982 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2007, 11:38 AM
  5. Replies: 2
    Last Post: 08-07-2006, 04:45 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