Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Range to Another Spreadsheet
Hey All,
How do I link specific column ranges from one spreadsheet (A11:[End of Data] through F11:[End of Data]) to another spreadsheet where it automatically refreshes data each time it's opened. TIA... |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Range to Another Spreadsheet
=if(Sheet1!A1="","",Sheet1!A1)
in a1 of the other sheet, then drag fill down the column. Select the formulas and drag fill to the right -- Regards, Tom Ogilvy "MeTed" wrote in message ... Hey All, How do I link specific column ranges from one spreadsheet (A11:[End of Data] through F11:[End of Data]) to another spreadsheet where it automatically refreshes data each time it's opened. TIA... |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Range to Another Spreadsheet
Thanks Tom,
Is there a way to automate this process since the original spreadsheet is constantly growing? "Tom Ogilvy" wrote in message ... =if(Sheet1!A1="","",Sheet1!A1) in a1 of the other sheet, then drag fill down the column. Select the formulas and drag fill to the right -- Regards, Tom Ogilvy "MeTed" wrote in message ... Hey All, How do I link specific column ranges from one spreadsheet (A11:[End of Data] through F11:[End of Data]) to another spreadsheet where it automatically refreshes data each time it's opened. TIA... |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linking Range to Another Spreadsheet
Sub CopyDataAsLink()
Dim rng as Range set rng = Worksheets("Source").Range("A1").CurrentRegion rng.copy With worksheets("Dest") .Activate .Range("A1").Select .PasteSpecial Link:=True .Range("A1").PasteSpecial xlFormats End With End Sub -- Regards, Tom Ogilvy "MeTed" wrote in message ... Thanks Tom, Is there a way to automate this process since the original spreadsheet is constantly growing? "Tom Ogilvy" wrote in message ... =if(Sheet1!A1="","",Sheet1!A1) in a1 of the other sheet, then drag fill down the column. Select the formulas and drag fill to the right -- Regards, Tom Ogilvy "MeTed" wrote in message ... Hey All, How do I link specific column ranges from one spreadsheet (A11:[End of Data] through F11:[End of Data]) to another spreadsheet where it automatically refreshes data each time it's opened. TIA... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking spreadsheet | Excel Worksheet Functions | |||
Excel spreadsheet linking | Excel Discussion (Misc queries) | |||
Linking 2 spreadsheet using data from the last row of spreadsheet | Excel Discussion (Misc queries) | |||
Linking 2 spreadsheet using data from 1st spreadsheet | Excel Discussion (Misc queries) | |||
Linking spreadsheet | Excel Worksheet Functions |