Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automating "paste Link" fuction using VBA
I am trying to replicate the paste link function to link data in 2 worksheets
together. The first sheet contains 1500 columns by 250 rows. The first 10 columns and 20 rows are headers only the rest is data. I need to link to a second worksheet such that every nth column of data is duplicated from the first sheet into sequential columns in the second. The second sheet is "read only" and only provides a condensed view of the main data sheet. I can achive this by manually selecting each nth set of data and "paste link" in the second sheet, but due to the size and volume of data this is impractical. as such I have been trying to automate using VBA with little success. Any ideas? Thanks, Mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I "paste link", and "transpose" at the same time? | Excel Discussion (Misc queries) | |||
What are the reasons for ""ActiveSheet.Paste Link:=True"" failure | Excel Programming | |||
problem with Linking workbooks via "copy" and "paste link" | Excel Discussion (Misc queries) | |||
"unable to paste link" Excel error message | Excel Discussion (Misc queries) | |||
Use "Paste Link" info in a cell to Jump to source? | Excel Programming |