Hi DanteAmor
Firstly, thank you for all your help so far. The code is running "perfectly", ie is is bringing up the column headers for anything that is empty.
So for the columns listed (Columns A through to L, and then any blank cells from Column R, S, T, U, V, W, X, Y, X, AA, AB, AE, AF, AK. AL. AM. AN) - these need to be included and all other columns ignored
So the code to do exactly the same but only for Columns A, C, D, E, F, G, H, I, J, K, L, R, S, T, U, V, W, X, Y, AA, AB, AE, AF, AK, AL, AM, AN
If the column M, N, O, P, Q Z, AC, AD, AG, AH, AI, AJ are blank/contain text I need the VBA to ignore these.
With Column L to have the contents displayed alongside the reference number (this is the name of who is dealing with it) so makes it easier to deal with
So on the below I have Column L as the Analyst, this on, any information the Macro generates, I would like to include next to the reference number.
On the below data this goes from A-L, and then restarts at Column R. Any information (for this report based in
M, N, O, P, Q Z, AC, AD, AG, AH, AI, AJ are completely irrelevant, regardless of any content or not, and should be ignored by this please.
Apologies again, I posted it in my initial post, and then when trying to explain again, I forgot to include it in my requirements!!
(DATA TAB)
A | B | C | D | E | F | G | H | I | J | K | L | R | S | T | | |
Internal Ref | External Ref | DETAILS | DATE REC'D | REQUESTOR | AREA | PRIORITY | DEVELOPER | STATUS | STATUS2 | STATUS DATE | ANALYST | Type | Price | Comments | | |
1 | 1234 | Request 1 | 01/06/2019 | Adam | 1 | A | Steve | Stage 1 | A | 03/06/2019 | Sophie | 2 | 500 | On Target | | |
2 | 1235 | Request 2 | 02/06/2019 | Peter | 1 | B | Phil | Stage 1 | B | 03/06/2019 | Ellie | | | On Target | | |
3 | 1236 | Request 3 | 03/06/2019 | Andy | 1 | A | Tom | Stage 3 | C | 05/06/2019 | Kaitlyn | 60 | 50 | | | |
4 | 1237 | Request 4 | 03/06/2019 | Katie | 1 | C | Stuart | Stage 4 | B | 08/06/2019 | Hannah | | | | | |
<tbody>
</tbody>