Hoping someone can help me automate a report I create regularly - I think it should be very easy but the VBA is a tad above my (nearly nonexistent) skill.
The example spreadsheet is attached (the results sheet is added by me).
Basically, I would like to know the average difference between Posted Date and Reply Date columns for each Channel. It would be awesome if the output were on a different spreadsheet as in the attached.
Alpha - 00.01.12.14
Beta - 00.02.19.16
Gamma - 00.12.07.00
Note - not every row has a "Reply Date" - if it doesn't, that row should be omitted for calculation. In other words, only rows that have a Reply Date should be included in the average.
Columns might not be in the same place each time, but the headers are always the same.
Would be grateful for any help with this.