+ Reply to Thread
Results 1 to 4 of 4

Migrating data to last row after table update (queries and connections)

  1. #1
    Registered User
    Join Date
    03-15-2022
    Location
    Poland
    MS-Off Ver
    365
    Posts
    2

    Question Migrating data to last row after table update (queries and connections)

    Hello, I'm new on this forum. I need help from experienced/wiser people in Excell:
    I download table (two columns) from another excel (query to sharepoint) third column is added locally. When new row is downloaded, value from last row in local column is migrate to new last row. Why and how can I prevent to migrate this data?

    movie to show exactly where is my problem: im5.ezgif.com/tmp/ezgif-5-fb6bf8a8cd.mp4 (I cannot normally post link)

    Thanks advance for help

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Migrating data to last row after table update (queries and connections)

    Hi and welcome to the forum.

    Is a macro involved anywhere that could be shifting this?

    Upload the workbook for a more considered response
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    03-15-2022
    Location
    Poland
    MS-Off Ver
    365
    Posts
    2

    Re: Migrating data to last row after table update (queries and connections)

    Attachment 772573 picture before and after - as You can see "value2" migrate automatically from cells C3 to C4

  4. #4
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2019
    Posts
    17,559

    Re: Migrating data to last row after table update (queries and connections)

    Selecting attachment 772573 results in the following message: "Invalid Attachment specified. If you followed a valid link, please notify the administrator".
    Information on attaching an Excel file to your next post is provided in the banner at the top of the page.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ 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. Queries and connections, click on a record to open new table
    By hendrikbez in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-26-2021, 01:41 AM
  2. Data Queries and Connections fail
    By Mal Ba in forum Excel - New Users/Basics
    Replies: 0
    Last Post: 08-09-2021, 01:13 PM
  3. [SOLVED] Query about Queries and Connections
    By steveal in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 04-17-2021, 07:07 PM
  4. Queries and Connections Ribbon
    By common763 in forum Excel General
    Replies: 0
    Last Post: 01-20-2021, 01:28 PM
  5. Refresh all data connections and queries
    By purlo in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 09-14-2020, 09:57 AM
  6. Replies: 0
    Last Post: 08-07-2018, 08:22 AM
  7. [SOLVED] Excel queries and connections
    By jrtaylor in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 02-07-2018, 01:51 PM

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