| 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. |
| 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 | |||
Threaded Mode
