Save content
Have you found this content useful? Use the button above to save it to your profile.
AIA

The ExcelZone Compendium 2007

by
3rd Dec 2007
Save content
Have you found this content useful? Use the button above to save it to your profile.

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Back to Index

Subscribe to the ExcelZone newswire
Subscribe to the ExcelZone NewswireTo keep up with spreadsheet issues, click the graphic to subscribe to the free fortnightly ExcelZone newswire. The subscribe function will take you back to the AccountingWEB home page after it adds your name to the subscription list.

Replies (2)

Please login or register to join the discussion.

avatar
By User deleted
01st Feb 2008 17:15

Importing csv data from a bank account into SAGE
Have tried to import csv data exported from an internet bank account into SAGE only to find that field headings do not match those that SAGE requires.
Any tips please?

Thanks (0)
avatar
By andy_smyth1976
08th Jul 2009 10:00

Excel: Links to other Excel workbooks
I've recently built a forecast spreadsheet using Period and YTD figures for each month. However, this is linked to another spreadsheet that's got just monthly forecast numbers. To enable me to do configure this, I've had to use the offset formula as every time I move across two columns on my YTD spreadsheet (Month/YTD; Month/YTD;....), it only needs to move across one cell on the monthly spreadsheet.
My problem starts when I close the backup spreadsheet where I'm picking up the monthly figures, as Excel then returns #VALUE errors in my YTD spreadsheet. When I try to evaluate the error, it specifies that the link is incorrect with #REF! When I replace the first month's figure with a simple formula refering it to the monthly spreadsheet it works fine, but if I copy this formula across then I'd have to manually change all the other monthly formulae - so this would defeat the purpose, especially if I have to role out the formula on all rows.

Any suggestions would be greatly appreciated
-------------------------------------------------------
It doesn't rain but it pours

Thanks (0)