zacharystucki
New Member
- Joined
- Sep 11, 2015
- Messages
- 8
[FONT="]Hey guys,
I have a major project that is giving me a run for my money. I need to build a report that will allow us to copy a report from another excel workbook into this one, then have it automatically put out the expected payout based on the breakout of codes used in a visit type and the allowed fees in the fee schedule.[/FONT]
[FONT="]I created an example here. If the link doesn't work try the one below. https://docs.google.com/spreadsheets/d/179LxltG5Y32CwLJqfXFKu4IAhJjhnHTgn7KhaIC4H8M/edit?usp=sharing
I'm trying to figure it out, but given the complexities of the formulas and such I thought I'd give it a try.[/FONT]
[FONT="]I was thinking I could use some kind of a count if or something, but I'm really open to anything, including changing up formats.[/FONT]
I have a major project that is giving me a run for my money. I need to build a report that will allow us to copy a report from another excel workbook into this one, then have it automatically put out the expected payout based on the breakout of codes used in a visit type and the allowed fees in the fee schedule.[/FONT]
[FONT="]I created an example here. If the link doesn't work try the one below. https://docs.google.com/spreadsheets/d/179LxltG5Y32CwLJqfXFKu4IAhJjhnHTgn7KhaIC4H8M/edit?usp=sharing
I'm trying to figure it out, but given the complexities of the formulas and such I thought I'd give it a try.[/FONT]
[FONT="]I was thinking I could use some kind of a count if or something, but I'm really open to anything, including changing up formats.[/FONT]