excel vba 2010

I have a very large excel table that appears as follows: <tbody> Bob OH 3 Bob OH 4 Bob OH 5 Mary OH 2 Mary OH 3 Mary FLA 2 Ted AL 2 Ted AL 3 Ted NY 2 Jim NY 2 </tbody> I want to delete rows leaving only the row with the max value in column 3 The final table should appear as...

I am using Excel 2010. Row 2 in my spreadsheet is Column Headings I would like to find all instances of "Dept Operations - Tendy" in Column E. (Say cell E3) I would like to cut the number from Cell G3 Paste it to Cell G5 If in the next instance "Dept Operations - Tendy" is in Cell E71 I would...

I have a workbook that has around 125 sheets and it is always changing. I use the second sheet as an Index. This macro below runs when I activate the Index Sheet. It takes around 4 seconds to run through. I use it very often and the time really adds up. Does anyone have any suggestions on...

My spreadsheets have a connection to SQL for source data. Since it is a new year I need the year part of the query to read 1/1/14 instead of 1/1/13. However the identification part of the query is unique to each workbook. I cannot find a way to update just the section of the connection string...

At the moment, I am trying to extract some information from the userform and put that in the spreadsheet. Basically, I have 15 checkboxs in the userform. For each checkboxs(1,2,..., 15), it has a label and a combo box next to it. What I want to achieve is, if the checkbox is true, then it...

The following Sub asks the user to select a generic template to open, then asks the user to select a source file (to populate the template). The source file is contains a number of worksheets and pivot tables. The sub then selects data from a pivot table and copies it into the template. I need...

Hopefully someone smarter than me can provide me with a neat VBA macro that will do the following; The easiest way I can describe the scenario I am trying to create, is to use a company list of personnel (my index) and to generate a time-sheet workbook per person based on a pre-populated...

I have a userform with five(5) textboxes that must be filled with figures based on entry in another textbox (Me.txtAmtRemainToSplit.Text). I want to implement some checks such that if the first textbox (Me.txtSplitAmt1st.Text ) is not filled the user cannot fill the 2nd textbox. If 2nd textbox...

I have a number of worksheets that are used as source data for pivot tables (one per table). Ideally I would like for my vba to add a new sheet for the pivot table and rename it accordingly. Right now the code adds a new sheet based on how many sheets there are. More specifically...

User selects the data source file and data is pulled from the pivot tables to populate a table in another workbook. Dim SourceFolderLocation As String Dim FileName As String Dim SourceFile As VariantMsgBox "Please select the data source file..." SourceFolderLocation =...

Hi, Could anyone teach me how to select multiple columns in CurrentRegion property so that I can create a Bar chart based on it Below are my progress so far.. however it doesn't work Public Function FourthTable() Dim Source As Workbook Dim Search As Range Dim CR As Range...

I have a macro that does the following; Sub CreateHeaders() Dim wsData As Worksheet Dim wsHeaders As Worksheet Dim headerRange As Range Dim header As Range Dim i As Long: i = 0 Dim anchor As Range Dim subAddr As String Set wsData = Worksheets("Sheet1") Set...

The following code opens a dialog box for the user to select files. I want it to determine which files to consolidate (using the loop). 'The following code will combine all data into one excel workbook. Sub CombineFiles_Step1() 'Declare Variables Dim WorkbookDestination As Workbook Dim...

Hi there, I'm going to start off by saying that I am pretty new to excel in general and wholly inexperienced with VBA. That being said, I was wondering if there was a macro that could look at a row and take the values of two cells, combine them and then create a range name for a third cell in...

Hi All, Our company has moved over to Google, but as we all know there is loads it cannot do hence this question! Is there a Excel (2010) VBA way to open a gmail message and download an attachment? The default browser is chrome, though this can be changed to IE if necessary. Thanks in advance...

Hi! in excel we can call a vba function in a cell like this =getValue(B2+A1). but is it possible to find all the vba function in cell in a workbook? thanks!

Hi guys, I gotta serious problem here.. any kind of help is much appreciated!! I have two huge text files (130 MB)each with thousands of records in each. I need to compare the two files using vba or by any means and generate a spreadsheet which includes the header and with two additional...

Hi All: I'm trying to copy data from one sheet to another. The following code is working but the problem is that it only copies the first line and it does not select any other breached or warning ticket(see attachment) If you open the sheet the code won't work because I set the Range to...

Hi! I need a macro to open a workbook (TimeSerierData.xlsm) and copy the data in the workbook into an array and then sum data by month and then put the result in another workbook called MonthSerierData.xlsm. here the data in TimeSerierData.xlsm Time Value 2013.01.01...

I have a list of numbers referencing an item in column B of sheet 2 that can be found in col A sheet1. I want to auto filter column A in Sheet 1 for rows that contain this number in col A Sheet 1. The number can appear multiple times in column A Sheet 1. <o:p></o:p> I tried VLook up. However, it...