+ 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 Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,433

    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?
    Please Avoid Joining My List Of Blocked Users by:

    Saying Please and Thank you.

    Making requests not demands.

    Checking back on your post. I will not edit any post after 4 days.

    Marking threads as closed once your issue is resolved. How? The tools at the top

    Any reputation (*) points appreciated. None of us gets paid here.

    If you found someone's input useful, please take a second to click the * at the bottom left to let them know

  3. #3
    Forum Guru
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    7,433

    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