Copying and pasting links within the same workbook

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.
 

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 to other worksheets within the same work 0
Syncing between source worksheet and dependent worksheets 0
VBA code for pasting links -- modifying RDB code for summary workbook 11
Merging worksheets within the same workbook 4
Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Compare data (2 columns) from 2 worksheets within a workbook 2
summary values across worksheets within the same workbook 2
Sorting a Workbook w/ Links 0

Top