+ Reply to Thread
Results 1 to 2 of 2

Automate data download into a tab (update data)

  1. #1
    Registered User
    Join Date
    01-12-2020
    Location
    Chicago
    MS-Off Ver
    Microsoft? Excel? for Microsoft 365 MSO (Version 2302 Build 16.0.16130.20378) 64-bit
    Posts
    19

    Automate data download into a tab (update data)

    I have a workbook that I use daily and I have to download, copy, and, paste data into a few different tabs to get the sheet to update.

    Is there any way to automate this?

  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: Automate data download into a tab (update data)

    Yes there is.
    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...

+ 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] Data Prep by Filling in Data Gaps from a Report Download
    By BobZZ in forum Excel General
    Replies: 3
    Last Post: 04-03-2018, 05:30 AM
  2. Google Trend, Automate Download CSV URL
    By AZ007 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-27-2015, 01:15 PM
  3. Download massive economic data and run correlations with data points.
    By dbravo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-09-2015, 06:06 PM
  4. Link and Automate(update) Template with data from different spreadsheets
    By AnaM21 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-09-2014, 05:25 AM
  5. how can i download user details from mysql on date basis
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-19-2014, 07:31 AM
  6. i can download data from the mysql but it downloading data in descending order
    By baig123 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-01-2014, 05:47 AM
  7. Automate Download Bhavcopy
    By vivekchha in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-25-2011, 02:47 AM

Tags for this Thread

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