+ Reply to Thread
Results 1 to 2 of 2

Referencing rows where rows gets added/deleted

  1. 11-29-2018, 02:21 AM #1
    Bezzie
    Bezzie is offline
    Forum Contributor
    Join Date
    12-06-2012
    Location
    South Africa
    MS-Off Ver
    Excel 2010
    Posts
    201

    Referencing rows where rows gets added/deleted

    I have a Names worksheet with bunch of rows with names and addresses in columns. In this worksheet rows gets added and deleted all the time.

    On a second worksheet (lets call it Labels) I want to make two columns combining some of the cells in Names worksheet to make something like address labels.

    For instance, Labels!A1 will have the address that is on row 1 in Names worksheet. Labels!B1 will have the address that is on row 2 in the Names worksheet. Labels!A2 will have the address that is on row 3 in the Names worksheet and Labels!B2 will have the address that is in row 4 in the Names worksheet etc.

    How do I reference the Names worksheet cells in the Labels worksheet so that I don't get reference errors when rows gets added or deleted in the Names worksheet?
    Reply With QuoteRegister To Reply
  2. 11-29-2018, 02:31 AM #2
    FDibbins
    FDibbins is offline
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,936

    Re: Referencing rows where rows gets added/deleted

    Howzit Bessie

    1st option would be to not delete the rows in the 1st place, just delete the data in them.
    2nd option would be to use INDIRECT
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford
    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. Wanting formula to adjust if rows are added/deleted
    By lmoffat in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-23-2018, 02:58 PM
  2. [SOLVED] code to auto number rows - that will update when rows are added/deleted
    By dkitzerow in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 08-12-2015, 10:45 AM
  3. Sum values in cell from variable rows (rows are added and deleted)
    By drewship in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 12-06-2010, 08:38 AM
  4. the colours to be changed when rows are added or deleted
    By mtgman in forum Excel General
    Replies: 6
    Last Post: 03-27-2008, 06:47 PM
  5. compare and find added or deleted rows
    By helpwithXL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 05-10-2005, 02:55 PM
  6. [SOLVED] compare sheets for added or deleted rows
    By helpwithXL in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 05-10-2005, 01:06 PM
  7. [SOLVED] how to detect added or deleted rows in compare
    By helpwithXL in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-29-2005, 09:06 AM

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