+ Reply to Thread
Results 1 to 2 of 2

How to force rows to stick together

  1. #1
    Registered User
    Join Date
    01-08-2021
    Location
    UK
    MS-Off Ver
    365 16.0.13426.20306
    Posts
    1

    How to force rows to stick together

    Hi there,

    I am using a tool to sync data from my online database with excel (Jira). In my work sheet, every row is a new item in the database. The first 3 columns are auto-populated from the cloud. I use the columns after that to add my own comments and details. The problem I have is that when a new item enters the database and is synced to my worksheet, the item rows are bumped down, but the comments i have added dont move down with them. Hence I would like to know if anyone has any tips for forcing rows to stick together - so that no matter what items are added or removed from the database, my worksheet comments stay attached to their corresponding item.

    Thanks in advance!

  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,861

    Re: How to force rows to stick together

    Please 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. Replies: 3
    Last Post: 10-27-2016, 06:25 PM
  2. Force destination formatting
    By krumel in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-13-2013, 11:31 PM
  3. Way to count rows in print out and force page break?
    By SDBoca in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-07-2011, 12:12 PM
  4. formulas to stick?
    By excellentexcel in forum Excel Formulas & Functions
    Replies: 13
    Last Post: 03-07-2009, 08:02 AM
  5. Force Date Entry with Variable Rows, Fixed Columns
    By rlw in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 12-12-2007, 08:36 AM
  6. Force condition on all Rows
    By afmullane in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-17-2006, 03:35 PM
  7. Format won't stick
    By tallyman00 in forum Excel General
    Replies: 2
    Last Post: 01-19-2006, 11:10 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