HI, I am new tom VBA . Plesae help me regarding this. First of of all, please see the attached JPEG File. I want to do same for merging 10-25 Excel in single excel sheet. Functiona of Buttons in Given In User form should be like this You can see the attachements for you refrence, we want to generate user form . I am awaiting for your reply Thanks and Regards Rohit ADD FILES ; When user click on this command button , it should ask me path for excel file to open as described in JPEG NO 3. REMOVE : When user click on Remove Command button, it should remove all previously added files from the list. As described in JPEG NO 3. CLEAR ALL : When we started new session, there may be some file are listed in Add Excel Files List box that we added last time. When user click on this button , all excel files that are listed in ADD Excel files should be get clear. JOIN : This command button Joins or merge all files one after another that you have added to Add Excel Files list box. Just before. NOTE : This user form should open when we click on one button in excel that is names As “Compile Data’, then only this macro runs step by step as mentioned earlier. --- On Fri, 16/4/10, [email protected] <[email protected]> wrote: From: [email protected] <[email protected]> Subject: Re: [ExcelVBA] Possible To: [email protected] Date: Friday, 16 April, 2010, 2:07 AM Is it possible you could send your worksheet offline so that I can look at it and then give you a feedback. You can use imaginary data so as not to contravene conflict of intrest rules in your coy. Regards, Ikechukwu Sent from my BlackBerry® wireless handheld from Glo Mobile. -----Original Message----- From: Lisa 66 <[email protected]> Date: Thu, 15 Apr 2010 15:05:29 To: <[email protected]> Subject: RE: [ExcelVBA] Possible here is what i have so far, just cant get the right formula for the totals, everything will be on one sheet. A B C D E LGND # DESCRIPTION Cost Total O 3 FILL LATER $3.25 $9.75 O 12 FILL LATER $0.22 $2.64 TR 3 FILL LATER $0.54 $1.62 TR 22 FILL LATER $22.15 $487.30 TR 51 FILL LATER $16.00 $816.00 TL 21 FILL LATER $0.88 $18.48 TR 1 FILL LATER $1.32 $1.32 O 4 FILL LATER $0.66 $2.64 TL 64 FILL LATER $0.45 $28.80 O Total S Total TR Total TL Total Grand Total > To: [email protected] > From: [email protected] > Date: Thu, 15 Apr 2010 09:58:34 -0700 > Subject: Re: [ExcelVBA] Possible > > sure... > If Sheet1 has your data. > In sheet2, but your list of "legends" > in column "A", > then, column "B" use: > > =SUMIF(Sheet1!A:A,TL!A2,Sheet1!D:D) > and copy it down the page > > hth, > > paul > > > ________________________________ > From: lamew66 <[email protected]> > To: [email protected] > Sent: Thu, April 15, 2010 12:09:46 PM > Subject: [ExcelVBA] Possible > > > Hi all > > Will it possible to do this? I dont want to start it and realize after > several hours that it is hopeless. > > I have 62 pages of inventory items (they have to be left on pages in the > order they are in for location purposes) Here is what I have > > Column A (legend) > Column B (quantity) > Column C (description) > Column D (cost) > Column E (total) > > I know how to put in my formulas to get my totals, what i need to know is > there a formula that will total all the items that have the same value in > column A and put it on a separate worksheet within the wookbook? > > Will this be possible? Please let me know I dont want to start inputting the > items if it wontwork. > > thanks, > Lisa66 > > > > > [Non-text portions of this message have been removed] > > > > ------------------------------------ > > ---------------------------------- > Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go > here: http://www.mousetrax.com/techtrax to enter the ezine, then search the > ARCHIVES for EXCEL VBA. > > ---------------------------------- > Visit our ExcelVBA group home page for more info and support files: > http://groups.yahoo.com/group/ExcelVBA > > ---------------------------------- > More free tutorials and resources available at: > http://www.mousetrax.com > > ----------------------------------Yahoo! Groups Links > > > [Non-text portions of this message have been removed] [Non-text portions of this message have been removed] ------------------------------------ ---------------------------------- Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA. ---------------------------------- Visit our ExcelVBA group home page for more info and support files: http://groups.yahoo.com/group/ExcelVBA ---------------------------------- More free tutorials and resources available at: http://www.mousetrax.com ----------------------------------Yahoo! Groups Links [Non-text portions of this message have been removed]
