Results 1 to 13 of 13

copy/paste a dynamic sheet/cell formula using INDIRECT, cell not incrementing

Threaded View

randallrosa copy/paste a dynamic... 02-19-2021, 10:31 PM
maniacb Re: copy/paste a dynamic... 02-19-2021, 10:44 PM
randallrosa Re: copy/paste a dynamic... 02-20-2021, 01:38 AM
MarvinP Re: copy/paste a dynamic... 02-19-2021, 11:24 PM
randallrosa Re: copy/paste a dynamic... 02-20-2021, 01:39 AM
FDibbins Re: copy/paste a dynamic... 02-20-2021, 01:57 AM
randallrosa My file has confidential data... 02-20-2021, 02:07 AM
randallrosa Re: copy/paste a dynamic... 02-20-2021, 12:32 PM
FDibbins Re: copy/paste a dynamic... 02-20-2021, 02:12 AM
kvsrinivasamurthy Re: copy/paste a dynamic... 02-20-2021, 02:37 AM
randallrosa Re: copy/paste a dynamic... 02-20-2021, 12:33 PM
randallrosa Re: copy/paste a dynamic... 02-20-2021, 12:58 PM
kvsrinivasamurthy Re: copy/paste a dynamic... 02-20-2021, 11:39 PM
  1. #1
    Registered User
    Join Date
    05-18-2017
    Location
    Vancouver
    MS-Off Ver
    OS X
    Posts
    25

    copy/paste a dynamic sheet/cell formula using INDIRECT, cell not incrementing

    Hi folks,

    Im using a basic INDIRECT formula that references a cell on another sheet, using a a drop down list for the prefix of the sheet name. I can get the formula to work, but then Im wanting to copy that formula incrementing the cell address, and Im having no luck. Any help appreciated!

    first row formula is

    =INDIRECT(M4&"_Sheet!N4") *works for row 4*

    when I cut/paste the formula to the next row, I get

    =INDIRECT(M5&"_Sheet!N4"), BUT I need N4 to also increment to N5 so the paste result is:
    =INDIRECT(M5&"_Sheet!N5")

    I think I need to get the Nx outside the quotes, but I havent found anything that works....

    TIA

    Randall
    Last edited by randallrosa; 02-20-2021 at 01:00 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA Copy/paste data based on cell reference (indirect)
    By dunder in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 02-18-2019, 12:57 PM
  2. [SOLVED] INDIRECT sheet name and dynamic cell
    By memoe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 07-11-2016, 10:26 PM
  3. Copy data and paste to another column incrementing that column to next empty cell
    By edens2021 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-29-2015, 11:43 AM
  4. want to copy and paste cell from using vba but cell # is dynamic
    By daveyc18 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-28-2015, 09:49 AM
  5. VBA Copy from another sheet & paste in cell where the formula is
    By ch_abs in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 01-16-2014, 11:30 AM
  6. Incrementing Cell Reference Within INDIRECT function
    By IronDogg in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-05-2013, 01:33 AM
  7. [SOLVED] Drag a formula that references a cell from another Sheet (Skipping a cell incrementing 1)
    By DixieDiver in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 09-05-2013, 06:25 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1