Previous Topic Next Topic

I need assitance

Closed
Floxysydney - Dec 10, 2008 at 08:00 PM
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 - Dec 11, 2008 at 02:07 AM
Hello,
i need help,I'm very new in Excel VBA i'm currently working on a data and i hv some missing values in them. i need to write a programme that will help me locate these missing value. i need a programme to inspect my data and give a name "N/A" each time it comes accross a missing cell.
i Aslo need to write a programme to generate the list on these missing values and paste them on right hand of the present sheet
generate an average for each colume of data(Quarterly data).

I'll be glad if anyone will be off help!
Thanks

1 response

Answer 1 / 1
TheParoxysm Posts 169 Registration date Sunday December 7, 2008 Status Member Last seen March 25, 2011 74
Dec 11, 2008 at 02:07 AM
You don't need VBA to generate your average.
Here's a thorough tutorial on how to use and basics of the Excel VBA
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm
0