main

Hi guys, I would like to make a simpla so-called main form, where the user can select which form has to be loaded for him/her, and pass some values to them from "main form" I found this method and tried to apply into my code Private Sub btn_frmOpen_Click() Dim frm As Object 'also tried with...

Hi I'm using the following code to save the selection to a new spreadsheet and then save it as import into the same folder as that main spreadsheet. ActiveSheet.Range("$A$1:$AM$216").AutoFilter Field:=27, Criteria1:=Array( _ "1", "2", "3", "4"), Operator:=xlFilterValues...

I have a main form named "frmTagEntry". The Subform is named "subTagEntry". I want to be able to view all of the records in the subform in datasheet view and have them linked with all of the records in the main form in formview. Basically mirror the form in split form view but using a subform...

As title says, I have a main sub that calls a subroutine that displays a Retry/Cancel Msgbox. On cancel, I want to Exit the subroutine AND not return to the main sub. Currently I have an Exit Sub on cancel, but it only quits the subroutine and continues on the next line of the main sub. Do I...

Hi, I'm trying to do a SUMIF over two worksheets for a number of values in a lookup table. The idea is that in cell AV39 there should be an addition of the associated combined scores on the look up sheet, Column D. The issue comes when there are some Pt Nos that have aslight variation in the...

I'm trying to sort about 50-60k rows of data and doing so by manually going through the lists and deleting the rows that do not have the #### part of the address. Is there a way to filter down and see addresses that contain the Main St and not the 1234 Main St? like 123 Dunn Rd are ones I...

Hi, I have a column with address details. I would like to separate the house number (always on the left) from the string. In some case, there might not be a house number, while in some other cases there might be a house and a flat number. I am only looking for the house number. Table below...

Hello, this is going to be a slightly long question. I will try to be as detailed as possible. I have a workbook with data, and column F contains a long string of text, which is essentially a description. Column E contains either one of two identifiers, "Main" or "Related". When a "Related"...

I have a worksheet with about 60,000 rows and 20 columns. I need to make about 20 copies of the main worksheet and then filter slightly differently on each of the other worksheets. This is a daily process so I'd like to automate it more. I started off pretty basic with just a formula...

OK - here is the scenario: Main macro opens a selected workbook to be 'worked on'. This workbook is then closed by the user using the standard 'X' (NB Not by a macro code line) I want to suspend macro execution in the main macro while the new workbook is 'worked on' until the new workbook is...

Hi everyone , firstly english is not my main language sorry for that.I have a main file which is working with 15 different source file.In the main file on A columns datas should be taken from source files on TOTAL sheets on A column.But the problem is a lot of data in TOTAL sheets and they are...

Hi all, Pretty new to VBA, trying to work things out for myself, but I've become stuck. Basically every Monday my colleague downloads a spreadsheet of direct sales (Main Tab), I then create a summary (Summary Tab) where I have every date of the year which is split into weeks. Next to each week...

Hi! I need to clean up a excel file (2016) with approximatley 2000 records where many of the names and addresses are all caps or all lower case. Is there a forumula I can use to identify these records and change to proper case formating (JOE SMITH, 123 main ave. change to Joe Smith, 123 Main...

Wowza, Wasn’t sure what was the best way to word my question. I’m currently working on a code that transfers dates from an excel sheet into a webform and selects a specific export button on the website (just pulling reports essentially). Each button pulls a specific report. So there’s a need...

I was wondering if there was anyway to carry variables across multiple sub routines. What I want to do is set a macro to a button, and I want to use an integer to make small changes to the main sub routine. I know I can accomplish this by making the button change a cell in excel, then making...

Is there a way for me to declare a variable in a UDF so that it will be available to any UDF that it calls? I tried Public varname as double Global varname as double but they both got error messages. A search turned up several webpages about global variables, but they all seem to indicate...

Hi, From the link to my test spreadsheet, I have 3 tabs, Site 1 and site 2 and site 3 What I am after is that the data of the 3 tabs populate the Main Page tab automatically as I enter data...

Hi I want to make my match() and Index() look more dynamic. User is going to select name from a Data validation list Then user will Select from another data validation list to tell excel what they want to return, Phone#, Address, or Salary I can do the lookup if the column is fixed (col1, 2, 3)...

Hi I want to use vlookup() to return multiple values. User will enter the name in cell G2 and vlookup() will return phone number and address. So I selected 2 cells (I2 and J2) and typed this function G2=VLOOKUP(G2,A2:C15,{2,3},flase) and pressed ctrl+shift+enter But I got error msg #Name ...

Greetings Everyone! I've been learning a lot since I have been a part of this community and I want to say thank you! I have another question that I'm going to go in and try what I know and see how that goes, but if someone has a better suggestion, I'm all ears! We currently have three...