Gents
Could you please assist me in the below case:
1-I have 2 Excel sheet on my PC (Excel A is extracted on a daily basis from I Series by using data transfer while Excel B is the target one).
2- Excel B (target) has a special header and colors and contains 4 columns and 20 rows with zeros amount in each cell
3-Excel (A) has the same columns and rows, but has amount in each cell.
4-I referred every cell in Excel (B) to the concerned cell in Excel (A) on my PC.
5-Now I have got my target excel B.
6-Every day I replaced Excel (A) with a new extract from I series , and when I open it , the Excel (B) effected with the new amount of Excel A (according to my previous reference).
My requirement is there any method to let another user to use those 2 Excel on his PC without changing the reference predefined in Excel (B)
Your assist in this regard will be appreciated.
Tarek
Software/Hardware used:
ASKED:
November 14, 2012 3:03 PM
UPDATED:
November 14, 2012 3:56 PM
any idea about this case.please supported.tarek