[Year 12 IT Apps] Macros in Excel

[Philip Pike]

A nice macro exercise is to increment a number eg An invoice number
Start with a number in a cell
copy and paste it next door ( or anywhere )
Write a formula below it, EG =B2 + 1. Press enter
Copy this cell, but paste special, value back into the original cell. 
Clear the temporary working cells.

Each time you execute the macro, you number increments.
You could incorporate this macro to clear the old data ready for a new
customer.

Another interesting increment is when you have A100. You could fill it
down, then copy the last number back into th efirst cell and delete the
last cell.


Phil Pike
Geelong College

 

-- 
################################################################################
This e-mail and any attached files are confidential and intended solely for the person to whom it is addressed.  If you have received this e-mail in error then please notify the sender immediately.  The contents represent the views or opinions of the author only and are not necessarily made on behalf of the School.  The recipient should check this e-mail and any attachments for the presence of viruses; the School does not accept liability for any damage caused by a transmitted virus.
################################################################################

Message  protected by MailGuard: e-mail anti-virus, anti-spam and content filtering.
http://www.mailguard.com.au/tt