I have some very simple Excel sheets which I keep to track filing dates for accounts and tax returns etc.
Are you, or someone you can recommend, an accountant within range of Chertsey who would be prepared to help get Sage Line 50 talking to Excel properly?
Does anybody have a formula that works out the filing deadline of a company based on incorporation date, and year end.
The proposed changes in online filing rules for Corporation Tax are also causing accountants who develop their own accounts production tools to think again.
The new version of Excel isn’t likely to contain many surprises, but Simon Hurst has delved more deeply into what’s coming.
I am drafting an spreadsheet for an analysed cash book with 20 analysis columns. Each column has a "Y" / "N" to denote whether the expense should be included on the VAT return.
I recall having been shown how to quickly toggle from the formula bar of Excel to the worksheet / cell that is specified in the formula.
I have an excel spreadsheet with about 80 columns (A, B, C, ..... etc).
I need to print each column on a separate sheet but column A would be in every sheet. So the print pages would be:
Can anybody tell me why this code will not run in XL97? It falls over at the myarray declaration. (Run-time error 438. Object does not support this property or method).
I have a large spreadsheet but want to add a word in front of all text in a certain column. Is there an easy way of achieving this without going through each line individually?
- New Range Name features in Excel 2007. By Simon Hurst 442,250 6
- Want to learn about Excel pivot tables? Start here. By David Carter 112,074 6
- ExcelZone's Five Minute Pivot Table Tips - Index 87,031
- Exporting data from Sage Line 50 into Excel #1. By David Carter 73,090 10
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 70,714 2