Hello there
I'm wondering if anyone can help me with this. I've got quite a bit of Excel and programming experience, but this is an issue I can't seem to figure out.
I have to keep records of what invoices are sent to particular people and when they are received back from them. There will be one person processing the sending of the invoices and another person will be processing when the invoices are received back. To avoid having one workbook open by two people, I have decided to split the table of data into two workbooks.
As such:
I have two workbooks. Workbook one we shall call the 'Sending' workbook and workbook two the 'Receiving' workbook.
Sending:
Contains a table with headings relating to information about the invoices (irrelevant in this question), and a 'Date sent' heading. As well as a 'Date Received back' heading which is linked from the receiving workbook (we'll get to this one shortly)
Receiving:
Contains a table where headings relating to invoice information and the 'Date Sent' heading are linked from the sending workbook, so as all the data entered into the sending workbook is displayed in the receiving workbook (the user cannot edit this data in the receiving workbook). The receiving workbook also contains the 'Date received back' heading, which the user can input data into. This heading is also linked back to the sending workbook so that data entered into the receiving workbook is displayed in the sending workbook.
This sort of almost creates a circle. 'Sending' creating the record and 'Receiving' adding to it.
I have set this up and it works. BUT my problem is, is if you sort the data in one workbook (such as sorting A to Z), it screws things up. If you put a date received onto one invoice and then do some kind of data sort, that date received is now applied to a different invoice, like as if they are two separate tables and I am only sorting one. Also, sorting the table in one workbook automatically sorts it in the other workbook, which is also a problem.
So I want to know if I can somehow get these tables to sort correctly. Or, if there is some kind of way to have a workbook open by multiple people, then that solution would be even better.
I hope this hasn't been too confusing :-P Any help would be great! :-D
Bookmarks