Ok last question (on this project).

I need to look at values in row 1 (in an open but non-activated workbook)
until I find the word Total (its column letter will change depending on other
info, for example it may be H one week then M another).

Then I need to figure out which column that is.

Then I need to copy a particular cell in that column (that row number will
never change), to a cell on my currently open workbook.

Thanks

Kevin Porter