Excel file
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

Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question. Michael Tidmarsh   11,390 pts. , Senior1systemanalyst   260 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

any idea about this case.please supported.tarek