+ Reply to Thread
Results 1 to 2 of 2

Table copying formula but want changing reference

  1. 04-30-2014, 12:10 AM #1
    HaroonSid
    HaroonSid is offline
    Forum Contributor HaroonSid's Avatar
    Join Date
    02-28-2014
    Location
    india
    MS-Off Ver
    Excel 2013
    Posts
    2,080

    Table copying formula but want changing reference

    hello
    i m using below formula to get unique name 
    Please Login or Register  to view this content.
    when i insert a new row, i want 
    Please Login or Register  to view this content.
    this one also change the reference
    e.g
    my table range is C10:BN100, and i insert a new row in my table now range is C10:BN101
    i want also change in 
    Please Login or Register  to view this content.
    thanx
    Reply With QuoteRegister To Reply
  2. 04-30-2014, 04:31 AM #2
    hemesh
    hemesh is offline
    Forum Expert
    Join Date
    02-19-2013
    Location
    India
    MS-Off Ver
    07/16
    Posts
    2,386

    Re: Table copying formula but want changing reference

    can you upload a sample book?
    -------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------

    WANT TO SAY THANKS, HIT ADD REPUTATION (*) AT THE BOTTOM LEFT CORNER OF THE POST

    More we learn about excel, more it shows us, how less we know about it.

    for chemistry
    https://www.youtube.com/c/chemistrybyshivaansh
    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. Macro -- Copying Pivot Table and Changing Row Labels
    By andcarro in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 12-04-2013, 02:25 PM
  2. Reference the number of changing data in a formula from pivot table
    By jonathan.haynes in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-23-2013, 07:57 AM
  3. Copying a formula but changing a row reference.
    By Glayva in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-08-2013, 11:36 AM
  4. Copying a formula without changing a part of the reference
    By bengaluru in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-04-2009, 12:13 PM
  5. Pivot Table with changing reference.
    By Michael.H. in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-23-2009, 08:32 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