Allocating Across Financial Years
A recent question from a CPA in Canberra allowed me to combine the MOD function and helper cells to offer a solution. (more…)
Hiding Zero Rows in Excel with No Macros
Over the years I have had regular requests for a technique to hide zero rows in reports. You can use macros but you can also use filters. Let’s see how you can implement a filter solution. (more…)
Free Webinar Recording – Interactive Excel Chart
In September 2019 I re-ran my very first webinar that was based on an August 2012 INTHEBLACK feature article. I have provided a detailed pdf manual and example files which you can download at the link below. This session covers using controls with charts to make the user experience easier tips for using controls on spreadsheets flexible formula techniques to make reports more dynamic a technique to stop figures plotting on charts using range names with controls and reports general…
Linking sheet controls to cells
Most spreadsheet controls need to link to a cell to enable interaction with the spreadsheet. There is an easy way to do that. (more…)
Some actions clear the clipboard
Some actions in Excel will clear the clipboard after you have copied or cut. Two common ones are inserting a new sheet clearing a filter - using Clear in the Data menu (keyboard shortcut Alt a c ) So if you are going to do either of these, do them before copying or cutting.
![Read more about the article Copying between sheets in Excel [VIDEO]](https://a4accounting.com.au/wp-content/uploads/2017/06/vimeo-221396947-1.jpg)
Copying between sheets in Excel [VIDEO]
Copying between sheets or files is a common task. I’d like to share a quick and easy way to do it. (more…)