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

1. ## 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?

2. ## 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

3. ## 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!

##### Users Browsing this Thread

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

#### 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