+ Reply to Thread
Results 1 to 3 of 3

Transferring data to Point of Sale System

  1. #1
    Registered User
    Join Date
    05-10-2017
    Location
    Hunter Valley Australia
    MS-Off Ver
    excel 2010
    Posts
    2

    Transferring data to Point of Sale System

    Hi, new to forum, hoping for help with this, not a competent Excel user. Looking at setting up a new Point of Sale system and need to upload supplier pricelists which have been supplied in Excel format.
    The problem I have is that when I copy the supplier pricelist through to Vend, which is the POS system, it copies all the formulas from the back end of the suppliers spreadsheet. Wondering whether it is possible to transfer just the information that is visible on the spreadsheet only. Will make a start with this question, see if anyone understands where I am coming from. Appreciate any feedback.

  2. #2
    Forum Expert Olly's Avatar
    Join Date
    09-10-2013
    Location
    Darlington, UK
    MS-Off Ver
    Excel 2016, 2019, 365
    Posts
    6,284

    Re: Transferring data to Point of Sale System

    Make copies of the files. In the copy versions, copy / paste values all the data. Save, and upload those file versions.
    let Source = #table({"Question","Thread", "User"},{{"Answered","Mark Solved", "Add Reputation"}}) in Source

    If I give you Power Query (Get & Transform Data) code, and you don't know what to do with it, then CLICK HERE

    Walking the tightrope between genius and eejit...

  3. #3
    Registered User
    Join Date
    05-10-2017
    Location
    Hunter Valley Australia
    MS-Off Ver
    excel 2010
    Posts
    2

    Re: Transferring data to Point of Sale System

    Thanks Olly, will try that. Tommo

+ 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. Point of Sale using microsoft excel
    By ranuj in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-15-2016, 02:09 AM
  2. Point of sale
    By Steamellar in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-10-2013, 02:18 PM
  3. Point System HELP!
    By mfoley9723 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 03-14-2013, 03:47 PM
  4. [SOLVED] define exact number of products sale from multiple sale and returned sale orders
    By maabadi in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2012, 06:14 AM
  5. Simple Point of Sale Solution in Excel
    By ahsanzafar in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 08-10-2012, 03:57 PM
  6. Excel as a Simple Point of Sale application?
    By john744 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-24-2012, 05:22 AM
  7. Excel & Point of Sale
    By busnut in forum Excel General
    Replies: 0
    Last Post: 08-04-2009, 07:24 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