Previous Topic Next Topic

I need assitance

Closed
Floxysydney - 10 Dec 2008 à 20:00
TheParoxysm Posts 169 Registration date Sunday 7 December 2008 Status Member Last seen 25 March 2011 - 11 Dec 2008 à 02:07
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

Réponse 1 / 1
TheParoxysm Posts 169 Registration date Sunday 7 December 2008 Status Member Last seen 25 March 2011 74
11 Dec 2008 à 02:07
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