I am puzzled by an active form I am looking at.
There is a process on the active form which goes to another worksheet, the target worksheet is in the same workbook as the source worksheet.
The process uses Match Title Elements and when I look at the Advanced options I can see that it says Source Type is Value and Target Type is Range.
However the Source and Target object are blank.
On the target worksheet there is a Subnm as follow:
Code: Select all
=SUBNM("Server:Cost Centre Dim","","","Description")
The puzzle for me is how does it do this? Is it because match title elements somehow reads the subnms on the source sheet and applies them to the target sheet? edit: I have read the IBM guide on this which I know does say it matches the elements, I was just hoping for some information as to how exactly it does it, and are there any restrictions etc
The other puzzle and the real issue is if I snapshot this to excel from the web then the target worksheets cost code is blank and the cost centre value is not being populated? So for example X001 is on the source sheet but not on the target sheet, which as I have said is blank.
Hope the above makes sense
thanks, Maren