compile

I need to compile a list of item qtys across a weekly grid for reporting purposes. My original sheet is a list with duplicates. How do I arrive at the conclusion in the second table using formulas? Right now I'm doing this manually. <tbody> ITEM QTY SHIPPED IN-HOUSE DATE (OR EST) WEEK...

Hello all, I get a "Compile Error - Wrong number of arguments or invalid property assignments" every time I try to run my code. I've been changing this little section, and I feel like I must have missed something little that is causing my error. Else Gmail "email@gmail.com", "password", ""...

Hello All, I want to combine a specific tab ("Summation") in all workbooks in a folder to a single workbook. I have my macro asking for the file path, a file name pattern and the tab name from each workbook. The only 2 I really need are the file path and the tab name but the middle is just...

I have been attempting for some time to automate compiling weekly reports that I receive. The following is what I have written, and I can't figure out why it doesn't update the value of cell B39 to reflect to the newly received sheet. This macro runs fine through to the range("B39").Value...

Hello, Can some one help me with a VBA code through which I can compile data from multiple spreadsheets into a single spreadsheet. So, what I would prefer is that the code when run would ask me to define path from which it will start compiling. And while compiling, it would also take care of...

Hello, I was given an assignment and I really appreciate if someone can help me to create the VBA code for it. Basically the problem I have is as shown in Figure 1, and the outcome I need to obtain is in Figure 2: Explanation: <tbody> 1) The fruits should match their corresponding boxes...

Hi Everyone, I have a number of excel files (same format) that i need to copy and compile to a master file saved in a local drive. Ex. Agent 1 (sheet 1), should be save in a master file sheet 1, Agent 2 (sheet 1), should be save in master file sheet 2.. and so on.. Can someone teach me what...

Hello everyone! I am a new VBA coder and I'm trying to figure out this error. Basically, I am trying to create a macro that takes the value of one entry in the column, switches sheets and searches for that value, then copies the data in the columns next to it and pastes them back on the first...

I am getting a compile error: cannot find project or library. In references I am Excel "MISSING: RulesEngine 1.0 Type library". the code(s) I am getting these errors on work on my PC and RulesEngine 1.0 Type library is just check (Do not say MISSING in front of it). I have two computer this...

Hello, I am fairly novice with Excel VBA and in searching the forum I haven't quite found what I'm looking for. I'm using Excel 2007 however writing in compatability mode for other users who use Excel 2003. I have three worksheets in one workbook, "List1", "List2", "Results". List 1 and 2...

Hi all, I am very new to VBA and I am looking for some help to set up a macro to compile all the data from multiple work books from a network folder than can be selected when the macro is initialized. All files will be .xls file format and the files will all have the same data in them. What I...

Hello All, New to forum and new to VBA, so any comments would be appeciated. I want excel to open a word document template and place a information in a cell into the word document in between two words. (I write many reports and opposed to writing all the information into excel then word as I do...

Dear Reader, I need to simplify a worksheet before I can use it. Maybe I can use it as it is but I do not know how. How can I change this: Bui:Regal(1988-1996);Chev:Lumina(1990-2001),Monte Carlo(1995-1999);Olds:Cutlass Supreme(1988-1997);Pont:Grand Prix(1988-1996) Into this: <tbody> Buick...

I have a workbook with 219 worksheets. The data I need from each resides in the same range (A53:O57). I cannot figure out what is wrong with the following code... <CODE> Sub SummurizeSheets() Dim ws As Worksheet Application.ScreenUpdating = False Sheets("Summary").Activate For Each ws In...

Hi, I'm trying to read/write from an Ini file and I found code that was said to work but when I try to implement it all of the code is highlighted in red and it tells me "Expected: line number or label or statement or end of statement" Declare Function GetPrivateProfileString Lib "kernel32" _...

Hi, I have a program written in C# that comunicates with a VBA macro in an Excel xls file. The macro creates a worksheet, imports data from a text file to that worksheet, organizes the data in the cells, makes some formatting, and save the new xls file. The problem is: most of the users...

Hello, I have found and tweaked a macro but can't quite work out all the bugs. I have a spreadsheet with multiple sheets ("10", "20", "30", "40","50","70","90"). Each sheet has the same info in it. What I want to do is DELETE all rows in a sheet that do NOT match the Tab name (example; in...

Finally got all the bits and pieces working together (in I'm sure the dirtiest way), but it seemed to be doing what I wanted, then when I tried to expand it...fail. Rundown: I have a workbook where I select checkboxes (cells) on the first tab, and then a macro copies the corresponding column...

I get the following error when I run my code: "Compile error: User-defined type not defined" VBA highlights this line of code: Public msg As New TibrvMsg I think maybe I'm missing a reference or something in tools/references. Any recommendations? Thanks!

Hi there can anyone help with the above. I am fairly new to the VBA program and have never came across this. My code is as follows if it is the problem Private Sub Worksheet_Change(ByVal Target As Range) If Not Intersect(Target, Range("G7:K154")) Is Nothing Then Application.EnableEvents =...