+ Reply to Thread
Results 1 to 3 of 3

How to copy continous information into a linked worksheet with no so continous cells

  1. #1
    Registered User
    Join Date
    05-22-2013
    Location
    mexico
    MS-Off Ver
    Excel 2003
    Posts
    2

    How to copy continous information into a linked worksheet with no so continous cells

    Hi all

    I have the worksheet called "basic" and wich has the information listed from "A1-to Z1" in a continous way and I wan to link it to "worksheet 2" but i have to link it like this: Worksheet2 A1 = basic A1
    Worksheet2 D1 = basic B1
    Worksheet2 G1 = basic C1

    Is there a fast way to do this?

    Thanx in advance

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    Excel 2019
    Posts
    7,040

    Re: How to copy continous information into a linked worksheet with no so continous cells

    There's prob a better way but try this

    in Worksheet2!A1
    =IF(MOD(COLUMN(),3)<>1,"",INDIRECT("Basic!"&CHAR(64+(COLUMN()-1)/3+1)&"1"))

    and copy across the columns
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Registered User
    Join Date
    05-22-2013
    Location
    mexico
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: How to copy continous information into a linked worksheet with no so continous cells

    Hi Special-K

    Thnx for your replay! please guide me a litle bit more.
    if I paste =IF(MOD(COLUMN(),3)<>1,"",INDIRECT("Basic!"&CHAR(64+(COLUMN()-1)/3+1)&"1")) it gives me an error, I'm guessing I need to change the "COLUM()" part but with what?

    I also belive I have my first reference linked in Worksheet2!A1 with Basic!A1 and then paste the formula u gave me in Worksheet2!B1 ....is this right?

    Is there a formula I can use to sum with pasted links? IE $Basic!$A$1 + 1 so it goes $Basic!$A$2?

    Best regards!

+ 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