Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Link & Update Two Workbooks
I have two workbooks that contain some of the same information that I would
like to partially combine. My first workbook has account number, account name, and billing month as the column headings. Each row contains the account number & name, and day of the month that I received each report for billing. ie: Acct num | acct name | jan billing | feb billing 123456 | abc company | 12/8 | 1/26 And so on for the whole year. My other sheet lists the account number and name and a column titled "last report received", as well as other information, not specifically related to the report. I'd like a formula to take the most recent report date from the 1st book and plug it into the second book, corresponding to the same row. I'd also like it to automatically update itself (if it can...). So when I enter a report date in December in the first book, it would list 12/04 as the most recent report date in the second book. I hope that made sense.... Thank you in advance for your help. Darcie |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can you update links between workbooks without them both open? | Excel Discussion (Misc queries) | |||
link two workbooks | Excel Discussion (Misc queries) | |||
How to Link named ranges from multiple Workbooks into a single Wo. | Excel Discussion (Misc queries) | |||
How do link to a remote field but use the path from a stored field | Excel Discussion (Misc queries) | |||
Workbooks...I'll try this again... | Excel Discussion (Misc queries) |