I have 2 the same excel files with the same headings but in different format. I want to happen is when I input data on the 1st file it will also inputted in the 2nd file not copying and pasting. Is there any possible solutions with this?
2007-02-18 05:43:44 · 3 answers · asked by ask man 2 in Computers & Internet ➔ Software
Noo, it's a different file type, or different format (maybe froma n older version of excel).
2007-02-18 05:48:44 · answer #1 · answered by Anonymous · 0⤊ 0⤋
Make formulas in the second file which reference the first file. For example if you want cells A1 through A100 to be the same as A1 through A100 of the first file, do this:
Have both files open. In the second file, select cell A1, type = on the formula bar, then click on the first file and click on cell A1, then hit Enter. Now cell A1 in the second file has a formula which refers to A1 in the first file. Copy and paste down through A100. Now whatever you enter in cells A1 through A100 in the first file, will also be in cells A1 through A100 of the second file.
2007-02-18 06:14:18 · answer #2 · answered by Joliet Jake 3 · 0⤊ 0⤋
This can easily be done..
But well.. i am tired to type it here. Why dont you message me at sam_edwin007@yahoo.com i can help u rite away when ur here.
Or.. if you dont have a yahoo messenger..
may be u can checkout this site www.ExcelGoodies.Com they have Excel Experts online. you can chat with them and they would help you instantly.
Infact i learnt excel from them.. may be u can give them a try..
2007-02-19 06:03:06 · answer #3 · answered by sam e 2 · 0⤊ 0⤋