+ Reply to Thread
Results 1 to 4 of 4

Query update/refresh only certain field

  1. #1
    Registered User
    Join Date
    05-20-2020
    Location
    UK
    MS-Off Ver
    Office 16
    Posts
    33

    Query update/refresh only certain field

    Hi
    I posted a query but I'm guessing it can't be done in Excel (query to upload and manage in an existing other purpose database) as I didnt get any suggestions yet, so I've re-thought how I can simplify.
    So DB1 on on source worksheet contains say 7 columns, I want the data in columns A, D and F to update and change in DB2 destination worksheet in say columns E, J and K (where EJK have same column headers as ADF and D is a unique reference). The other columns in DB2 are manually entered/dropdowns to manage the data and must not change if EJK are refreshed. I can do a simple macro to re-paste special the datavalidation if necessary in the manual cells.
    thanks
    Last edited by Bazbuyer; 05-26-2020 at 09:45 AM. Reason: correct typo

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

    Re: Query update/refresh only certain field

    It may help somebody to better understand what you want if you could upload a small sample utilizing the instructions 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.

  3. #3
    Registered User
    Join Date
    05-20-2020
    Location
    UK
    MS-Off Ver
    Office 16
    Posts
    33

    Re: Query update/refresh only certain field

    Thanks JeteMc. The answer came to me at 3am! I create another sheet where I have all my columns set out as I desire. With the db relevant columns equal/linked to the relevant refreshed query columns. Very simple in the end just needed to think laterally.

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

    Re: Query update/refresh only certain field

    You're Welcome. Thank You for the feedback and for marking the thread as 'Solved'. I hope that you have a blessed day.

+ 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 Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:16 AM
  2. Converted hyperlinks to urls, return back after query update/refresh.
    By akinofotkap in forum Access Tables & Databases
    Replies: 0
    Last Post: 12-08-2014, 08:55 PM
  3. Replies: 2
    Last Post: 09-29-2013, 06:15 AM
  4. Replies: 1
    Last Post: 09-28-2013, 07:11 PM
  5. Formulas do not update after Web Query Refresh
    By caliann49 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-29-2013, 09:31 AM
  6. Adding a run/refresh button to update MS Query script?
    By KOOOP in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2013, 02:58 PM
  7. Problems Populating Null Table-Field Values With an Update or Append Query
    By NSTurk725 in forum Access Tables & Databases
    Replies: 3
    Last Post: 06-11-2009, 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