I wonder if anyone can help with a formatting issue i come across from time to time. We use an sql based practice management package which allows the exporting of client data to excel.
I have a sheet with dates running across C7 to IT7. I would like to hit a macro bitmap that activates a macro to go to today's date. I managed to get a macro to go to the next blank using:
How can I format a cell so that it displays a negative time rather than #### ??
e,g, for use in flexi- time calculations.
A new series of articles offering tips and tricks to conquer common Excel problems starts with time formats and calculations.
Having got to grips with Excel 2010, lecturer David H Ringstrom highlights five minor changes that have improved his efficiency in the new version. Look out for more tips next week.
Hi i have a macro (below) which does exactly what i need it to do. Whenever i change a figure in any box on the tab, the macro runs and hides relevant boxes that i dont want.
I'm preparing income forecasts for a consultancy business. Our contracts are usually on a fixed fee basis and generally run for several months or even longer.
Basically there is a file on our network. I only ever need to look at it, some people need to edit it. I get bothered a lot to come out of it by the updaters, so I want to open a read only copy
My client uses Sage MMS & I have developed with him a comprehensive Excel2007 model (using ODBC) for monthly Management accounts reporting.
- New Range Name features in Excel 2007. By Simon Hurst 453,596 6
- Want to learn about Excel pivot tables? Start here. By David Carter 113,524 6
- ExcelZone's Five Minute Pivot Table Tips - Index 88,428
- Exporting data from Sage Line 50 into Excel #1. By David Carter 78,899 10
- Tutorial:.... Budgeting with Pivot Tables #1 [Excel 5 to 97] 71,398 2