Thanks tdevick, but thats not quite what I am looking for. This is what I have done:
1. In the Global Datasheet I have renamed column 'A' to 'pUsername'.
2. In the Local Datasheet of my action I have selected cell A1 (column 1, Row 1).
3. I then enter '=' into that cell, then go to the global datasheet and select cell one of the column 'pUsername' and the press enter.
4. A formula is generated automatically by QTP which is '=Global!A1'.
So my localsheet is now reflecting the contents of the globalsheet, which is what I desire...
But I don't want the formula to be A1, I want it to be pUsername1. As the "A" aspect may not always be true as I may have other global parameters so it could be B1, C1 etc.
So I am looking to see if their is a way to reword the formula within the datasheets cell to have 'pUsername' instead of using 'A'.
Hope this helps make my goal more clear.
1. In the Global Datasheet I have renamed column 'A' to 'pUsername'.
2. In the Local Datasheet of my action I have selected cell A1 (column 1, Row 1).
3. I then enter '=' into that cell, then go to the global datasheet and select cell one of the column 'pUsername' and the press enter.
4. A formula is generated automatically by QTP which is '=Global!A1'.
So my localsheet is now reflecting the contents of the globalsheet, which is what I desire...
But I don't want the formula to be A1, I want it to be pUsername1. As the "A" aspect may not always be true as I may have other global parameters so it could be B1, C1 etc.
So I am looking to see if their is a way to reword the formula within the datasheets cell to have 'pUsername' instead of using 'A'.
Hope this helps make my goal more clear.