KingSwish828
Board Regular
- Joined
- Jul 13, 2010
- Messages
- 84
Hello,
I was hoping I could get some guideance on a little problem I have. I have a workbook1 with data in it and a form on another workbook2 in excel. Is there a way to have the form automatically populated with the data from my first workbook if the dollar amount is over $1000. 00?
workbook1 will contain the account number, payer/finical class,dollar amount,DOS,provider name reason for write off request
workbook 2 is my form with fields for all the the information listed above and I only need it to locate and fill in a form for any dollar amount over $1000.00 and each issue will need to have its own form if it is over $1000.00 and it must be saved to be pulled up at a later time if needed.
I am thinking a Vllook up, but I am not sure. Any suggestions?
I was hoping I could get some guideance on a little problem I have. I have a workbook1 with data in it and a form on another workbook2 in excel. Is there a way to have the form automatically populated with the data from my first workbook if the dollar amount is over $1000. 00?
workbook1 will contain the account number, payer/finical class,dollar amount,DOS,provider name reason for write off request
workbook 2 is my form with fields for all the the information listed above and I only need it to locate and fill in a form for any dollar amount over $1000.00 and each issue will need to have its own form if it is over $1000.00 and it must be saved to be pulled up at a later time if needed.
I am thinking a Vllook up, but I am not sure. Any suggestions?
