excel

  1. R

    IF/MATCH statement that includes the SUM

    I am in need of an Excel formula that looks to see if cells in column A match. If they do, then provide the sum of all of the cells that match in that group in the first cell of that group in the appropriate column (GA = column "G", "FL" = column "I"). You can see the totals in columns G and I...
  2. S

    VBA : Allocate Data Randomly and Evenly

    Hello Good People, I have this allocation workbook that when I click a button. It will randomly divide the list of data into 8. (Currently 8 but it will soon increase). I have attached a sample images for my 2 sheets. Persons sheet - List of data Teams sheet - Output of allocation However...
  3. I

    Hopefully a simple find and replace VBA script

    I have the following data (before.png): I would like to have a VBA script which runs through column A looking for a carriage return. Upon finding one, it copies that entire row but only with everything PRIOR to the carriage return - it will make a new row for each iteration. It will then add a...
  4. T

    Excel Freezing Issue

    I have an excel issue that I can’t resolve on my own, looking for some help. I will add that I work with laptop and desktop both and sometimes start on one and finish on another. I do a lot of excel work between church finances, scheduling for our little league, and my personal finances. My...
  5. T

    UserForm Close Event Hangs

    Through use of multiple UserForms I open a 2nd workbook that I hide and then may get or write data to that workbook before closing it. All was good until I noticed that when the red X in upper right corner (Close event) of forms was clicked that the 2nd workbook was left open and hidden. To...
  6. W

    Moving Contents Within Cells To Another Place

    Hello folks, Based on the attached photo, at a click of a button, I would like to: 1. Copy the contents of A3 to C3 2. Paste in the next available, free cell. In this case, A12:C12 3. Clear contents of A3:C3 I'm struggling with getting the macro to paste at the bottom most, next available free...
  7. Q

    How to stop InputBox from looping after input?

    Hi there! I am using this macro to sort through a master inventory list and transfer a row if the inputted "Vendor" is found when the InputBox populates. However, after the input, the InputBox keeps popping up and infinitely looping. How do I make it so that once a vendor name is entered, the...
  8. A

    Auto-Update Microsoft Excel Data into Google Sheets

    Good morning, I have about 25 different excels spreadsheets with various information. I'd like to auto-transfer any data updated and saved onto any of these excel sheets into One google sheet file; each excel file would have its own tab in google sheets. What is the best way to accomplish this...
  9. E

    Rebasing percentages in excel? How to

    I have a list of countries expressed in percentages of a universe Universe = 100% , individual countries as follows Japan 6% China 2.60% Korea 1.20% India 2% HK 0.60% SingaporE 0.30% Taiwan 1.70% Total 14% How do I rebase those countries to 100% in Excel...
  10. J

    Insert a Row using VBA when a filter is applied

    Hello . . . I have a very simple piece of VBA (below) that works perfectly well copying a line and inserting it below itself, as intended. However this doesn't work when a filter is applied. Can anyone kindly suggest a fix? Sub WLM_Insert_A_New_Line() ActiveCell.EntireRow.Select...
  11. Y

    VBA to Script

    Yea, I have no idea where to start. I have been all over google trying to figure out the structure. I have a VBA that i need to put into a script inorder to use it in AppSheet. Can you point me in the right direction? Sub ResetWeekly() End Sub Sub ClearOldDates() 'Declare variables Dim rng As...
  12. M

    Creating and emailing Excel sheet with only visible data

    I have this code that creates a copy of my excel sheet and puts it an email in outlook. this works perfectly. However, I run a filter with a change event once a loan officer is chosen in cell and I would like to modify my macro to strip out all the other data so the user that receives the...
  13. M

    Formula to return most repeated text in filtered data

    Hi, I have the following formulas that returns the most repeated text in a range that ignores blanks as well but I need to adjust it to only test the visible cells as the data is filtered, can someone help me? I am not sure which is better but both seem to work, can you help me choose the best...
  14. M

    Replacing delete with a value

    I have code that executes an autofilter to show data based on the value in cell d6. However, when the user hits the delete key the autofilter shows now data. If the user hits delete on d6 I would like to make the value of the cell 0. Is this possible? Code when there is a change: Private Sub...
  15. M

    Having trouble with latest date in vba code for a pivot table

    Having trouble with latest date code for pivot table vba code. Trying to streamline our process of entering equipment hours and I started getting into vba since it seems like it's the way to go, I found some code that should do this but I can't get it working in my particular instance. Listed...
  16. G

    Advice for Excel integration

    Hi, I’ve started to work on a product that will have a deep integration with Excel with the following requirements. Installation: A one-time installation of the Add-on across all Excel files on a user's machine. Tracking: The Add-on should adeptly track all user interactions within the...
  17. R

    Ayuda con formula

    Hola, tengo una tabla donde tengo las 52 semanas del año en curso de la columna de la columna I para la primer semana hasta la columna BH para la semana 52, quiero contar los datos por meses, se que puedo usar COUNTIFS para contar cada columna pero quiero que automaticamente me cambie...
  18. J

    Excel: Is it possible to use Spilled Arrays for a Cost Recovery Reconciliation Table without Circular References"

    I have been converting older spreadsheets to spilled arrays to improve and simplify logic. However, there is one area I cannot convert to a spilled array without the dreaded circular reference! Below is a simplified version of a table where costs are recovered from reveneue before the profit is...
  19. W

    Protected sheet disables macro buttons

    I am working on an Excel form to allow users to submit data about decisions made and topics covered in meetings as part of a larger project. I will have a lot of different people entering data in this Excel file, so I want to lock as many cells as I can to make sure things aren't accidentally...
  20. A

    Lookup names that are in another list but have them listed one row after another

    Hello, Hoping someone can assist me with this excel question. I would like to create List3 as it looks. If the color in List2 is in List1, then I want it to show up in List3. The part I am stuck on is getting List3 to pull green to the first row,, blue to the second row, and so on. Appreciate...

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
Back
Top