My colleague has created a table in excel to pull out figures from an excel
spreadsheet, to summarise the figures contained within it and to
cross-reference/check that the figures entered are correct. She does this on
the 22nd of each month. The table shows dates along the top (the 22 of each
month), a list of 6 company names in column A (starting at A2) and the rest
of the cells showing an amount.
Is there any way of automating this process? Perhaps a macro/button, so on
the 22nd she can press this button to extract the cell values needed.
I had considered a simple formula to say: =IF(Today()=H4,B1,B2)
(where H4 contains the date 22/05/2007). Doing it this way though, when the
date does not equal H4, the cells will show nothing?
Any ideas?