+ 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
    22

    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,414

    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,414

    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
    22

    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)

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