Pse send sample in Excel and I will try to do it on my Workbook
Unfortunately I couldn't get the macro to work. I have uploaded my workbook: File ID 355590. Pse put the macro on as follows:
When the word "member" on page "Info" cell B17 changes then the same word must change on sheets: "AccOff: line22", MemResp: line8,line13,line19"; "MemRep: line8,line31,line36,line42,line55,line58"
Formula is working 100%. What can I add to "&Info!B17 &" so that words are in lower case?
When I pull through a date (28 February 2012) it shows it as a figure?
Anything I need to change to pull through a $ value ?