Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a file to worksheet
I'm trying to open a worksheet depending on the month that the data is for.
For example, If I am looking at Jan Balance sheet on my first tab, I'd like to pull the Jan Trial balance from a file. I have written a VLookup so that the proper path/filename is displayed. How do I get Excel to open the file name in cell A1? Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Link a file to worksheet
Here's a little macro that will do it.........
Sub OpenFilenameInA1() Worksheets("sheet1").Select Workbooks.Open FileName:=Range("a1").Value End Sub Vaya con Dios, Chuck, CABGx3 "Stacie" wrote: I'm trying to open a worksheet depending on the month that the data is for. For example, If I am looking at Jan Balance sheet on my first tab, I'd like to pull the Jan Trial balance from a file. I have written a VLookup so that the proper path/filename is displayed. How do I get Excel to open the file name in cell A1? Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Personal File Link with Worksheet | Excel Discussion (Misc queries) | |||
Is it possible to link cell formatting in Excel from file to file | Excel Discussion (Misc queries) | |||
Link worksheet totals to a summary worksheet in the same workbook | Excel Worksheet Functions | |||
I want in one worksheet to relatively link to/reference cells in another without changing the format of the current worksheet. | Excel Discussion (Misc queries) | |||
How to link Excel worksheet tab names to dates in each worksheet? | Excel Worksheet Functions |