Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Date plotting
Hi
I'm trying to find a way to do the following in Excel XP. I have two worksheets in the same workbook. The first has a list of invoice names, each with an invoice date, amount and expected payment date. The other sheet is a time line (dates along the top) with the invoice names down the left hand side. What I'd like to be able to do is to automatically pull in each 'due' date into the time line. If the expected payment dates change, I want to be able to update these in the 'data' sheet and for the changes to be automatically reflected in the time line. I suspect this might be impossible without programming, but I'd appreciate any pointers. Thanks for any advice. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
How do I calculate if a date is in a certain time frame? | Excel Worksheet Functions | |||
search for latest date | Excel Worksheet Functions | |||
Recurring annual events using a specific date as a trigger date | Excel Worksheet Functions | |||
Date Math Problem | Excel Worksheet Functions |