Copying and pasting links to other worksheets within the same work

G

GEwan

Hi,
I'm trying to link one of my worksheets to other worksheets within the same
workbook. The source data on the other worksheets is not in a set structure
of rows/columns. Is there a quick and easy way to do this?
Example1, the Destination for one set of data is B4:B11 and the source data
is on a separate worksheet D4:K4. When I try to use Transpose, the ability to
Link goes away...
Example2, the Destination for another set of data is C4:C11 and the source
data is on a separate worksheet F2, H2, J2, L2, N2, etc.
Thanks!
G
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copying and pasting links within the same workbook 0
Trace links between worksheets within one workbook 4
Syncing between source worksheet and dependent worksheets 0
Copying Worksheets 2
Creating multiple links between worksheets within a single workboo 1
Trying to create a dynamic filepath within VB 3
Creating multiple links between worksheets within a single workboo 1
move 2 worksheets & keep the links 0

Top