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.
I have two workbooks. Workbook one we shall call the 'Sending' workbook and workbook two the 'Receiving' workbook.
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
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
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