+ Reply to Thread
Results 1 to 1 of 1

Userdefined column in table that updates via a query [Attached file shows the issue]

  1. #1
    Registered User
    Join Date
    09-30-2021
    Location
    Sweden
    MS-Off Ver
    Office 16 (Microsoft 356)
    Posts
    1

    Question Userdefined column in table that updates via a query [Attached file shows the issue]

    I have a simple time report created in Excel that basicly looks this.

    Project 2021-10-01 2021-10-02 2021-10-03 Row total
    A 1 1 4 6
    B 3 1 1 5
    C 4 3 2 9
    d 1 1 2
    E 2 2
    Column total 8 8 8 24

    The user defines the project and amount of worked hours for each day. I have one sheet per month. The next step is that I generates a "diary-table" with Power Query with a "User defined note"-field based on the values in all time-report sheets.

    Project Date Value Diary entry
    A 2021-10-01 1 Text edited by user
    B 2021-01-01 3 Text edited by user
    C 2021-01-01 4
    A 2021-10-02 1
    B 2021-10-02 3
    D 2021-10-02 1
    E 2021-10-02 2

    When I add new projects and time on myc time-report sheets and then update the query the values in my user-defined diary entry randomly jumps around and I can not have it like that.

    So my question is:
    Can I solve this problem with either Power Query or VBA?
    Attached Files Attached Files

+ 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. Replies: 2
    Last Post: 02-13-2019, 07:39 AM
  2. [SOLVED] Dynamic Range w/ Chart Issue - Reference Problem (attached file)
    By Wrathard in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-20-2018, 10:44 AM
  3. [SOLVED] Create an UPDATE query in Excel that updates ACCESS table
    By cliff.clayman in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-25-2016, 10:14 AM
  4. [SOLVED] query issue in Access database attached
    By flashy79 in forum Access Tables & Databases
    Replies: 5
    Last Post: 09-05-2015, 10:08 PM
  5. Please help me for the query of attached file.
    By sunofsush in forum Hello..Introduce yourself
    Replies: 1
    Last Post: 09-16-2014, 06:56 AM
  6. A macro that shows updates - PLEASE HELP!
    By Sapphire69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-08-2006, 09:55 AM
  7. A macro that shows updates - OVER MY HEAD
    By Sapphire69 in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-06-2006, 10:25 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