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 files on his PC without changing the reference predefined in Excel (B) Your assist in this regard will be appreciated.
November 17, 2012 12:47 AM
November 19, 2012 1:36 PM