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 files on his PC without changing the reference predefined in Excel (B) Your assist in this regard will be appreciated.
Tarek
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.
Tarek
Last edited: