+ Reply to Thread
Results 1 to 2 of 2

Merged queries not repeating matched data

  1. 09-14-2022, 11:21 AM #1
    badincite
    badincite is offline
    Registered User
    Join Date
    11-25-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    25

    Merged queries not repeating matched data

    Trying to merge queried data from sql with data from table excel date and it's not repeating the dates on the matching columns. It appears to be skipping around I need to repeat the dates for everything matching job and phase. Attached what the merged data looks like. Also attached my phase dates table.

    Dates.PNG
    1.PNG
    Skipping.PNG
    Attached Files Attached Files
    Last edited by badincite; 09-14-2022 at 11:27 AM.
    Reply With QuoteRegister To Reply
  2. 09-14-2022, 01:22 PM #2
    badincite
    badincite is offline
    Registered User
    Join Date
    11-25-2014
    Location
    United States
    MS-Off Ver
    2010
    Posts
    25

    Re: Merged queries not repeating matched data

    Nevermind I found my phase data format was messed up
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Apply conditional formatting to multiple cells merged on a row from a data merged row
    By Hillfias in forum Excel General
    Replies: 2
    Last Post: 06-12-2022, 12:28 PM
  2. [SOLVED] split data into two sheets matched & not matched based on matching sheet
    By abdo meghari in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 03-31-2022, 02:24 PM
  3. [SOLVED] Two criteria are matched to bring out the value (the cell has a merged cell)
    By rayhen in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-10-2021, 11:28 PM
  4. Repeating Text when Copying Table with Merged Cell to M-Word
    By Treeman_JF in forum Excel General
    Replies: 5
    Last Post: 12-15-2020, 05:49 PM
  5. Repeating Column A when Row 1 is Merged...?
    By justaddculture in forum Excel General
    Replies: 1
    Last Post: 03-31-2016, 04:20 AM
  6. How do you restrict user access to creating new queries & using existing Excel queries?
    By Excel_vba in forum Excel General
    Replies: 0
    Last Post: 01-21-2013, 12:47 PM
  7. [SOLVED] Repeating columns cuts off merged cells
    By mjones in forum Excel General
    Replies: 3
    Last Post: 04-02-2006, 08:00 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1