cogtrain11
New Member
- Joined
- Jul 1, 2008
- Messages
- 1
I am using Windows XP and Excel 2000.
I am attempting to format two seperate workbooks so that when data is added into one workbook, the other is automatically updated. The invoice file is where the information is going to be added and the actuals file is the file to be updated. What needs to occur is that upon adding information to the invoice file, the actuals file will insert a row above totals for the given column and the totals for the column will adjust to include the new data entry. I have no experience writing code but what I was thinking of doing was to make the invoice file into a pivot table that can refresh, and in doing so create a macro that will update the actuals file. This is not as big of a challenge for me as writing the coding that will change the bottom lines to include the new entry automatically. Is this the best way to go about tackling this problem and can anyone help me write the code?
I am attempting to format two seperate workbooks so that when data is added into one workbook, the other is automatically updated. The invoice file is where the information is going to be added and the actuals file is the file to be updated. What needs to occur is that upon adding information to the invoice file, the actuals file will insert a row above totals for the given column and the totals for the column will adjust to include the new data entry. I have no experience writing code but what I was thinking of doing was to make the invoice file into a pivot table that can refresh, and in doing so create a macro that will update the actuals file. This is not as big of a challenge for me as writing the coding that will change the bottom lines to include the new entry automatically. Is this the best way to go about tackling this problem and can anyone help me write the code?