Chronologically collate comments from several spreadsheets - help needed.


Chris Mitchell

I have several spreadsheets each of which has a standard 'Changes' sheet
which is used to capture the history of changes to that particular
spreadsheet, i.e. each change only applies to one spreadsheet. The Changes
sheet has 3 columns the 'Date' of the change, the nature of the change
'Change' and details of the person who made the change 'Changer'.

I have a master spreadsheet which takes data from each of the subordinates
and collates it by means of various functions.

I want to be able to collate the individual changes from each of the
subordinates as a single list in the master in reverse chronological order.

How can I do this?


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