Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
trying to create a blow-up sheet by writing a VBA macro
Hello I am trying to create a blow-up sheet by writing a VBA macro that shows
the initial cost buy of an item then for a range of years, the Maintenance cost for each year. e.g. PC Cost by is $2000 bought on 4/2005 and for the next 4 years the maintanence cost is $100 per year. so it should appear as: PC $2000 4/2005 PCmaint $100 4/2006 PCmaint $100 4/2007 PCmaint $100 4/2008 PCmaint $100 4/2009 I imagine it will be a FOR or WHILE with some ARRAY type variable Thanks |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Help with writing a macro to create a list | Excel Discussion (Misc queries) | |||
Macro to create new sheet | Excel Discussion (Misc queries) | |||
Blow ups in spread sheet | Excel Worksheet Functions | |||
it's going to blow! | Excel Programming | |||
How to create a Macro to Copy Information in one sheet to another sheet. | Excel Programming |