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
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
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
TheParoxysm
Posts
169
Registration date
Sunday December 7, 2008
Status
Member
Last seen
March 25, 2011
74
Dec 11, 2008 at 02:07 AM
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
Here's a thorough tutorial on how to use and basics of the Excel VBA
http://www.anthony-vba.kefra.com/vba/vbabasic1.htm