Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Linked cells, VLookup? don't know which to use
I'm fairly new to this & not overly proficient with formulas, this is my
problem. I need to track cash & inventories each week, to do this I have created a template consisting of 5 worksheets. Each week I create a new file from the template & save it useing a file name like 20610 Mar.12 2006. When I open a new file I need to enter opening inventories, which are the closing inventories from sheet 5 of the previous weeks file. My problem is I want to automate this step in the template (so I don't have to have 2 files open) but I don't know how to do this. Can anyone help me with this, anything will be appreciated Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
VLOOKUP issue with #N/A - linked workbook | Excel Worksheet Functions | |||
Sorting non-linked cells in a linked worksheet | Excel Discussion (Misc queries) | |||
VLOOKUP, linked cell &combobox | Excel Worksheet Functions | |||
Linked Cells Staying With Cells Once Linked Workbook Update. | Excel Worksheet Functions | |||
vlookup with linked cell references | Excel Worksheet Functions |