Moving Data from one worksheet to another

B

Bettye

Help!

My monthly worksheet consists of insurance company,
patient name, date created, charged amount, insurance pymt
received and balance due. My assignment is to create the
following condition and move it to a new spreadsheet:

If charge is => 60 days old and insurance has not paid,
move that row to a new spreadsheet that contains only
unpaid insurance after 60 days so that I can contact the
insurance company to find out claim status. The idea is
to not have to go back over the entire months'
spreadsheets in order to reconcile. All unpaid over 60
dys will be on a spearate spreadsheet.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Making data in appear in one worksheet from another 2
How to update data entry to a linked worksheet and then return thenew value back to a master workshe 0
Collate data from one spreadsheet into another spreadsheet 2
How to update data from linked worksheet back to a master worksheet? 0
Creating forms on the fly? 4
Any advice? Creating forms on the fly 2
Duplicating a cell from one worksheet to another worksheet 1
How to update a value from a linked worksheet back to the master worksheet? 0

Top