Consoladating data that is not numerical

[Whafey]

Hi, I have been asked to devise a workbook that demonstrates the use of meeting rooms in our building. We have four meeting rooms that are used by five organisations, so each organisation has their own worksheet. This shows their individual usage. This data is then copied onto a fifth spreadsheet that shows the overall usage of the room by all organisations. The workbook has to be very visual, so has been designed to fill cells with a specific colour for each of the rooms with the initial of the rooms name inputted into it. Times are in 30 minutes intervals and I have used the following formula to calculate the hours used =COUNTIF(T92:T112,"T")/2. The fifth spreadsheet counts the cells by colour using the following formula =CountCcolor(B17:B37,$A$3)/2. The initials of the organisation using the room at that time entered into cell. At present I have to input the data onto the individual organisation's spreadsheet and then replicate this into the overall usage spreadsheet. This both time consuming and can lead to errors occurring.

Is it possible to populate either the organisation's spreadsheet and the overall usage automatically populated, or more preferable the overall usage data filtered into the individual organisation's sheet?

[FDibbins]

Hi, welcome to the forum

To best describe or illustrate your problem you would be better off attaching a dummy workbook. The workbook should contain the same structure and some dummy data of the same type as the type you have in your real workbook - so, if a cell contains numbers & letters in this format abc-123 then that should be reflected in the dummy workbook.

To attach a file to your post,
click advanced (next to quick post),
scroll down until you see "manage file",
click that and select "add files" (top right corner).
click "select files" find your file, click "open" click "upload" click 'done" bottom right. click "submit reply"

Once the upload is completed the file name will appear below the input boxes in this window.
You can then close the window to return to the new post screen.