Click here to Skip to main content

Visual Basic

 
QuestionDebug user control in VB6.0 ? PinmemberMember 24584678-Jan-13 23:38 
AnswerRe: Debug user control in VB6.0 ? PinmemberChandraRam17-Jan-13 21:08 
QuestionHow make DOWNLOADER in VB 2010 ? Pinmemberradoslaw1238-Jan-13 8:21 
AnswerRe: How make DOWNLOADER in VB 2010 ? [modified] PinmemberGuyThiebaut8-Jan-13 22:53 
GeneralRe: How make DOWNLOADER in VB 2010 ? Pinmemberradoslaw1239-Jan-13 1:36 
GeneralRe: How make DOWNLOADER in VB 2010 ? PinmemberGuyThiebaut9-Jan-13 1:40 
QuestionIOException was Unhandled Pinmemberjankevint7-Jan-13 15:37 
AnswerRe: IOException was Unhandled PinmvpDave Kreskowiak7-Jan-13 19:08 
GeneralRe: IOException was Unhandled Pinmemberjankevint7-Jan-13 22:52 
AnswerRe: IOException was Unhandled PinmvpRichard MacCutchan7-Jan-13 23:26 
GeneralRe: IOException was Unhandled Pinmemberjankevint8-Jan-13 0:18 
GeneralRe: IOException was Unhandled PinmvpRichard MacCutchan8-Jan-13 0:31 
AnswerRe: IOException was Unhandled PinmemberMike Meinz22-Jan-13 4:15 
GeneralTo calculate with two - three & four criteria multiple worksheet in summary sheet Pinmemberatulkhandekar3-Jan-13 22:42 
Hi Friend's, I am using excel 2007. In my file 6 sheets. 4 sheets is data record & 1 sheet is recorder sheet & monthly.
Data record sheet name is : FY_2009, FY_2010, FY_2011, FY_2012 & FY_2013.
In all above sheet :
Part numbers mentioned in column "C2:C60000"
Quantity in column "D2:D60000"
Branch in column "G2:G60000"
Month in column "H2:H60000"
Year in column "I2:I60000"
In some sheet record range in differ. Some sheet upto row 50000 & some sheet upto 38000 but field name partnumber quantity, branch, month & year in same column.
 
1st case : In recorder sheet i have calculate how many quantity sold part number wise as well as in particular year & branch wise. (Location of part number in A2:A10000 column & Year mention in column F2:J2 (i.e. 2009, 2010,2011,2012, 2013)
 
2nd case : In column L2 mentioned year (i.e. 2012) & L2:Q2 mentioned branch.(i.e. "HGN", "NGP", "AKL", "AMRT", "CHN", "YTMAL")
How many quantity sold branch wise in 2012 year.
 
3rd case : In column R2 mentioned branch (i.e. "HGN",   & R2:W2 mentioned years 2009, 2010, 2011, 2012, 2013)
How many quantity sold from one branch in year wise.
 
In monthly sheet i have calculate how many quantity sold part number wise as well as in particular month & year wise.
In monthly sheet location of :
Part number in : "B1" cell.
Months : 1,2,3 ... so on upto 12 in location is B2:M2.
Years : "A4:A8
 
Presently, i have calculate through excel formula but calculation is slow due to thousand of data records
& thousand of formula. And it will take very long time.
 
Now i required to calculate through vba micro to speed up our work.
In view of the above kindly let me know.
Note: I am not familiar with VBA.
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmemberEddy Vluggen4-Jan-13 23:48 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet Pinmemberatulkhandekar7-Jan-13 2:46 
AnswerRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmvpEddy Vluggen7-Jan-13 2:57 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmvpRichard MacCutchan7-Jan-13 7:39 
GeneralRe: To calculate with two - three & four criteria multiple worksheet in summary sheet PinmemberShailesh Shah12-Jan-13 20:20 
Questionwhich method I should go with Pinmemberdemo 22-Jan-13 20:54 
AnswerRe: which method I should go with PinmemberEddy Vluggen4-Jan-13 23:51 
Questionvb6 with ms access2007 database Pinmembertuticorinmano2-Jan-13 10:58 
AnswerRe: vb6 with ms access2007 database PinmemberDavid Mujica2-Jan-13 11:26 
GeneralRe: vb6 with ms access2007 database Pinmembertuticorinmano2-Jan-13 13:49 
QuestionShould be simple: incompatible types PinmemberAndreFratelli1-Jan-13 8:44 
AnswerRe: Should be simple: incompatible types PinmemberAndreFratelli2-Jan-13 1:27 
GeneralRe: Should be simple: incompatible types PinmemberGuyThiebaut7-Jan-13 23:34 
Questiondatagrid in vs 2012 Pinmemberjenkinsdjj30-Dec-12 21:22 
AnswerRe: datagrid in vs 2012 PinmvpRichard MacCutchan30-Dec-12 23:29 
GeneralRe: datagrid in vs 2012 Pinmemberjenkinsdjj31-Dec-12 1:40 
QuestionGetting innertext of HTML with </ br> tag between words PinmemberStonesteel26-Dec-12 23:57 
AnswerRe: Getting innertext of HTML with </ br> tag between words PinmvpDave Kreskowiak27-Dec-12 9:49 
GeneralRe: Getting innertext of HTML with </ br> tag between words PinmemberStonesteel27-Dec-12 22:04 
GeneralRe: Getting innertext of HTML with </ br> tag between words PinmvpDave Kreskowiak28-Dec-12 5:41 
Questionthreading impliment PinmemberMichael Hulak25-Dec-12 18:58 
AnswerRe: threading impliment PinmemberDineshshp25-Dec-12 19:32 
AnswerRe: threading impliment PinmemberEddy Vluggen26-Dec-12 13:16 
QuestionHow to read list of local and network printers PinmemberKASR125-Dec-12 8:21 
AnswerRe: How to read list of local and network printers PinmemberEddy Vluggen25-Dec-12 9:30 
GeneralRe: How to read list of local and network printers PinmemberKASR126-Dec-12 4:38 
GeneralRe: How to read list of local and network printers PinmemberEddy Vluggen26-Dec-12 12:58 
GeneralRe: How to read list of local and network printers [modified] PinmemberKASR127-Dec-12 0:15 
GeneralRe: How to read list of local and network printers PinmemberEddy Vluggen27-Dec-12 5:28 
GeneralRe: How to read list of local and network printers PinmemberKASR127-Dec-12 8:26 
GeneralAdding an email notification module to my application. PinmemberKismetGerald24-Dec-12 14:01 
GeneralRe: Adding an email notification module to my application. PinmvpRichard MacCutchan25-Dec-12 0:07 
GeneralRe: Adding an email notification module to my application. PinmemberKismetGerald25-Dec-12 1:09 
GeneralRe: Adding an email notification module to my application. PinmvpRichard MacCutchan25-Dec-12 22:01 
Questionvbs - text inputs uploaded to web Pinmemberoceaniana24-Dec-12 13:25 
QuestionThrowing run time error while saving the record. PinmemberMember 786176324-Dec-12 3:11 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.150224.1 | Last Updated 27 Feb 2015
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid