Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I link 2 spreadsheets to insert amounts on a defined date?
I have a spreadsheet which shows a dollar amount paid out everyday for a two
week period for multiple people. I have a different spreadsheet which shows changes made to those people. I know how to connect the two spreadsheet to change the amount paid per day; however, sometimes the change happens in the middle of the two week period. I was wondering if there was a way to have the amount change on the correct date? For example, in spreadsheet 1 Bob gets paid $14.24 per day. In spreadsheet 2 I change Bob's job code which changes his rate per day to $17.59. The pay period is 4/13-4/26 and the change happened on 4/23. If I just link the amounts to change then it would change in the whole pay period not just 4/23-4/26. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to insert $ and ‚¬ amounts in the same worksheet? | Excel Worksheet Functions | |||
Faster Way To Insert Defined Names?? | Excel Worksheet Functions | |||
Dynamic Picture defined by Name using a formula loses link when sa | Excel Worksheet Functions | |||
How to make an external link to a filename defined by a cell value | Links and Linking in Excel | |||
Insert Row by a defined Number | Excel Discussion (Misc queries) |