Chronologically collate comments from several spreadsheets - help needed.

C

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

Update several ppt documents from a single excel file 0
External cell reference between two excel worksheets both in One Drive 0
collate rows from several files into one new master file 1
How to extract duplicate records from 4 spreadsheets into a separate spreedsheet? 2
Need help modifying code 0
Missing default cell styles on some large existing spreadsheets 0
Collate data from one spreadsheet into another spreadsheet 2
Extracting data from hyperlinked spreadsheets 3

Top