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...

Watch MrExcel Video

This Week's Hot Topics

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top