Extract sheet name and cell number

[Howardc1001]

I have written code that where "variance" appears in Col A and there is a value in Col E in same row as where variance appears , then the sheet name as well as the cell number are to be extracted and pasted in Col G2 onwards


The macro works well, but I am battling to separate the sheet name and cell number with a space in between eg BR1A20 should be BR1 A20


Your assistance regarding the above is most appreciated

Please Login or Register  to view this content.

[mgs73]

Try changing

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

[Howardc1001]

Thanks for the help, much appreciated

[Howardc1001]

It would be appreciated if you could amend my code to also extract the sheet name and Col & row number containing the value in Col E <> 0 where Variance in in same row eg BR1 E

I want this extracted in Col H from row 2 downwards


Your assistance in this regard is must appreciated