+ Reply to Thread
Results 1 to 4 of 4

Automatically adjust cell reference when copy-pasting on multiple cells

  1. #1
    Registered User
    Join Date
    04-11-2020
    Location
    United States of America
    MS-Off Ver
    2007
    Posts
    29

    Automatically adjust cell reference when copy-pasting on multiple cells

    Hi,

    So I have 50 worksheets, and I want to paste link this to B15 of each worksheet: Sheet1!A15 .
    I know I can do multiple pasting using shift or Cntrl, but I don't want to copy the formula exactly the way it is.

    Instead, I want to paste it like a mixed cell reference,
    wherein the column reference will remain "A", but the row reference will change (15,16,17,18...)
    as it paste in B15 each worksheet.


    Is there a faster way to do this?


    Thank you for whoever will advise!

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Automatically adjust cell reference when copy-pasting on multiple cells

    You will need to use a Macro.

    How are your sheets numbered?

    Sheet1 to Sheet50?
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Automatically adjust cell reference when copy-pasting on multiple cells

    Please Login or Register  to view this content.
    Last edited by mehmetcik; 05-23-2020 at 07:34 PM.

  4. #4
    Registered User
    Join Date
    04-11-2020
    Location
    United States of America
    MS-Off Ver
    2007
    Posts
    29

    Re: Automatically adjust cell reference when copy-pasting on multiple cells

    Thanks for the advise!

    However I really prefer not to use VBA or macro,,,
    seems like not possible though

+ 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: 1
    Last Post: 02-04-2019, 09:17 AM
  2. automatically pasting one cell into multiple cells
    By pasercion in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-25-2015, 11:36 AM
  3. Copy pasting with reference from 2 cells and several workbooks.
    By looney in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-10-2013, 11:57 AM
  4. Replies: 2
    Last Post: 05-30-2012, 05:02 PM
  5. Replies: 11
    Last Post: 10-18-2008, 07:30 PM
  6. Copy cells containing $ sign but still adjust cell number?
    By oatfedgoat in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 07-17-2007, 05:41 AM
  7. [SOLVED] Automatically Changing Cell Reference's when Pasting in Excel
    By No I'm Spartacus in forum Excel General
    Replies: 0
    Last Post: 02-13-2006, 09:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1