+ Reply to Thread
Results 1 to 2 of 2

Rows issues, when importing Data from SQL and manually entering data in next column

  1. #1
    Registered User
    Join Date
    03-06-2004
    Posts
    53

    Rows issues, when importing Data from SQL and manually entering data in next column

    I am encountering an issue with manually entered data, staying in the cell where its entered.
    For instance, the following is a sample data, imported from SQL. Column A,B,C is the imported dat aand column E is manually typed.

    https://1drv.ms/u/s!AmZNEQGYqg4VgxUroydK3GoK1jZ_

    The issue i am experiencing is that whenever new data is available in DB and the sheet is Refreshed, the manually entered data doesn't stick with the name it was entered for. It ends up moving to the last row

  2. #2
    Forum Moderator alansidman's Avatar
    Join Date
    02-02-2010
    Location
    Steamboat Springs, CO
    MS-Off Ver
    MS Office 365 Version 2404 Win 11 Home 64 Bit
    Posts
    23,860

    Re: Rows issues, when importing Data from SQL and manually entering data in next column

    Your file is indicated as no longer available. Suggest if you are still interested in help from this forum, then read the yellow banner at the top of this page.
    Alan עַם יִשְׂרָאֵל חַי


    Change an Ugly Report with Power Query
    Database Normalization
    Complete Guide to Power Query
    Man's Mind Stretched to New Dimensions Never Returns to Its Original Form

+ 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. Excel data table yielding incorrect values from entering them manually
    By mbx1443 in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-03-2018, 09:51 PM
  2. Replies: 7
    Last Post: 10-03-2014, 05:04 AM
  3. [SOLVED] vlookup - entering new data manually into data validation cell
    By rdd2 in forum Excel General
    Replies: 3
    Last Post: 03-12-2014, 03:09 PM
  4. Replies: 5
    Last Post: 02-09-2014, 11:04 PM
  5. Replies: 3
    Last Post: 03-24-2012, 08:18 PM
  6. Extract Data from Column to 1 Rows for Importing
    By Bubba Howell in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-02-2011, 08:34 PM
  7. Replies: 2
    Last Post: 06-27-2005, 12:05 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