main

  1. G

    To calculate based on names

    Hi Everyone, Here i am trying to calculate the value based on the headers which are in the "sum" sheet and their names will only be A,B,C......, and my inputs are in "main" sheet but in my input those columns will be renamed as Sum of A,Sum of B,Sum of C..........., and my preferred output...
  2. D

    Some advice

    Hi all, I'm after some suggestions. I am currently putting a worksheet together at work that will show various bits of data. Some data is pulled onto the main sheet from a hidden sheet when I put their employee ID into a cell. If their telephone number is stored on the hidden sheet it will...
  3. A

    Distributing specific information from one sheet onto 4 more sheets depending on values

    Hello everyone, I've been doing some research lately on this forums threads seeing if I can find a solution that is similar to the situation I'm in, but have found that while some come close, they weren't necessarily the fix I was looking for. I have a workbook where I'm forced to distribute...
  4. M

    Sub stopping at section where formula should be dragged down

    Hi I've got a Sub which runs successfully until the point where a formula needs to be dragged down to the rest of the column. In short, data is copied from column H (cell 15 downwards) in the "Main Sheet" of a file called "Main Sheet" and pasted into cell DC15 of the same sheet. The code...
  5. B

    "subform datasheet view will only allow me to edit when first opened"

    I have added a subform to the main form so I could have some controls on the main form and the datasheet view on the subform. When I first open the main form I can edit in the subform datasheet without a problem. But if I execute the combo box "cboJobNumber" from the main form to search for a...
  6. G

    Picking different text parts from a long text cell

    I need some formulas to extract a certain part of the text from the main cell. I just can't think of a logical way to do that because using Left and Right will not work as the texts differ in lenght. https://ibb.co/cv3NQxx The columns B, C, D and E should give those small extracts from the...
  7. C

    Building multiple tables from 1 Query

    I have a folder I’m importing monthly files from. I will have the main table be my “2019 Total Sales Data” table. However, I’m wanting to break that same data out by month (Jan, Feb, Mar.... tabs at the bottom). I know that I could just duplicate the main query 12 times (giving me 13 total...
  8. G

    SUMPRODUCT has mismatched range sizes

    I'm trying to use a =Sumproduct and getting a #VALUE error in Google Sheets. Here is the formula that I'm using. =sumproduct(--($B$102:$B$255=A14),(right($C$102:$C$255,2))="AT",A$102:$D$255) When I use that formula in my main table (positioned at E14), I get the error. When I place the...
  9. B

    Calling a Sub within the Main Macro

    I am having issues with this string of code: Sub Format_Workbook_Pt2() Sub ConvertTextToNumber() Sheets("All_Data").Select Range("C:C").Select Selection.TextToColumns _ Destination:=Range("A:A"), _ DataType:=xlDelimited End Sub End Sub I...
  10. R

    Exit main macro if frmMsgBox equals no, else run main macro

    Hello! :) I have a large main macro. I would like for the very first thing it does is to call a custom msg box that will ask the user whether or not they wish to exit the macro, or if they wish to continue. If they wish to exit, I need to exit out of the custom msgbox sub AND also out of the...
  11. S

    Summing Variable Columns and Rows Using VBA

    Good afternoon - I am attempting to create a spreadsheet that will have 4 different summation columns to it. The amount of columns between the four main will vary depending on the amount of tabs in the workbook. The four main columns will be summing information from the feeder columns that are...
  12. S

    Summing Variable Columns and Rows Using VBA

    Good afternoon - I am attempting to create a spreadsheet that will have 4 different summation columns to it. The amount of columns between the four main will vary depending on the amount of tabs in the workbook. The four main columns will be summing information from the feeder columns that are...
  13. I

    Help with entering data in one workbook and updating data in another workbook automatically without opening the 2nd workbook

    So I have a main sheet where I enter all the data and it asks how many receipts I want printed The receipts are in another workbook. How do I update the receipt workbook with the new data entered in the main sheet automatically
  14. M

    Open another workbook and copy to sheet

    i have 2 files Main.xlsm Database.xlsx What i want to do its on Main workbook open, open Database.xlsx and copy it to a sheet in Main called "exceptions" and then close Database.xlsx Im currently opening Database with: Workbooks.Open (ActiveWorkbook.Path & "\Database.xlsx") As its in the same...
  15. M

    VBA Help. Creating new workbooks from templates and importing content

    Hi all, So I've started working with VBA a bit and have figured out what I'd like to do and that it is possible, I'm just not skilled enough to be able to write it from scratch. I've always found it easier for me to work with existing code and learn what everything does by modifying parts of it...
  16. J

    Missing Main Toolbar Excel 2010

    I cannot determine how to show my main toolbar. I can see my add-ins toolbar but not the original toolbar. Help is appreciated. I tried CRTL+F1 but all I get is a help screen. Thanks,
  17. S

    Hide rows using a userform login

    I have a workbook with 3-4 sheets. I havecreated a registration and a login userform. The registration userformconsists of a Reference number, Full Name, address, email, phone, etc. andallows each user to create a username and password for logging in later. Once registered, ALL of their...
  18. S

    First date within 2 tables

    Hi I have 2 payroll tables MAIN and MGMT. They both have dates and are linked to a common calendar table. I would like to know the first date you were paid from both tables. You could only show up on the MAIN or MGMT or both. Is this possible? thanks
  19. D

    How do I end my macro when i press cancel?

    Hi, Below is my macro, basically inside Do Loop are a set of macro that opens a file, copy a sheet to another excel file. all i want is if i dont have a file to upload to my new excel, i just want to return to my main file without being prompted by the Run Time error pop up. please help Sub...
  20. K

    Automatically update Main Sheet from 3 or more other Sheets

    Hello, I need help to update Main sheets from other Sheets Example Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salay </tbody> Sheet1(Jul-19) How will automatically Emp ID & Name updated in Main Sheet <tbody> Emp ID Name Gross Salary Tax Net Salary 01...

Some videos you may like

This Week's Hot Topics

  • help please
    SORRY NOT ANY GOOD AT EXCEL SO HELP WOULD BE MUCH APPRECIATED this formula is in a sheet called ignore...
  • two formulas needed
    Hello, I'll try my best to explain this: First formula needed in Sheet1 cell A2: If Sheet1 cell B2 = Sheet2 cell B2 then return a 1. If not then...
  • Dynamic Counts
    Good afternoon, we are tidying up some data & the data seems to be growing quicker than we are tidying it up! What we confirm (by reviewing it...
  • Help Excel formula eliminate duplicate values and keep only 2 identical rows.
    as picture below column A has a duplicate value. but the values are not the same as the rule. sometimes 4 rows, sometimes 10 rows or 7 or 9...
  • Macro Compile Error Sub or Function not defined
    Hello, I am trying to run macros from a validation list, all macros have been created and run perfectly on there own but I'm getting a compile...
  • Last row combined with Current Region VBA
    I'm generally happy finding the last row of data through something like Lastrow = Cells(Rows.Count, "D").End(xlUp) but I don't always receive data...
Top