1. A

    Solver Optimization Tool

    Hello, I have used solver to optimize the sum of numbers given certain constraints, however I am now trying to optimize the product of numbers given certain constraints. When finding the optimal sum I can use a binary list to select the combination of item to sumproduct together to find the...
  2. B

    Data population after adding sheets

    I built this sheet years ago for a colleague. However, human error seems to be the main issue. I need to be able to push the data from the Daily Sheets and push it to Well Summary. The sheets are going to be dynamic in the sense that we don't know when or how long a run will last, so it almost...
  3. B

    VBA Help - Same Function needed for multiple sheets

    I am new to using VBA in Excel. Just want to get that out in the open. What I am trying to do is create an inventory list for multiple products. Basically, I will have one sheet in my workbook per device type. I will have 4 columns. 1= Serial Number / 2= MAC Address / 3= Device Type / 4=...
  4. U

    Returning Merged Cell Value

    I'm looking for a formula that will help me return the merged cell value for every question that is next to a particular merged cell. See image below. I have huge sets of questions and areas sheets that I get sent. And just looking to use formula to help me arrange the data the way I need Thanks
  5. D

    Google Sheets Meal Planner

    Hi all, I'm trying to work on this last bit of my Weekly Meal Planner. I have multiple sheets within this one document and it would be easiest if I gave the link to the document itself rather than posting an image. Weekly Meal Planner In the sheet labeled Grocery List, in the fourth column I...
  6. L

    Clear multiple range contents, multiple protected sheets, vba

    I have some code that works great. However, I need to add in another range of cells to be cleared on a different sheet. Sheet names are "Sheet1" and "Hidden". The ranges that need to be cleared on the Hidden sheet are A2, A5, A14. Sub ClearCells() ActiveSheet.Unprotect Password:="232323"...
  7. R

    SaveAs method not actually saving, wrong sheets being deleted (1004 Error)

    Option Explicit Dim wb As Workbook Dim ws As Worksheet Dim ws2 As Worksheet Dim rng As Range Dim r As Long Dim i As Long Dim er As Long Dim c As Range Dim sht As Object Dim wb2 As Workbook Dim fname As String Dim fpath As String Sub printshts() Set wb = ThisWorkbook Set ws =...
  8. L

    Comparing two different worksheets/datasets

    Hey everyone, I’m looking for advice on how to compare two different worksheets for differences, perhaps by the highlighting of differences on one sheet. The issue is that the data set I’m comparing to is in a different format e.g. less columns and was essentially used to build the larger...
  9. W

    Macro to Copy Content

    Hello all, new to macros here, but this one has me extra stumped. I want to copy two cells (B21 and B23) in Sheet1 and paste the numbers into Sheet2. The catch is the figures being copied need to be pasted into the last empty column in Rows 2 and 3. The copying and pasting isn't so much an...
  10. Chris_010101

    Sum columns on multiple sheets

    Hello Using the basic salary column on FY 22-23 as an example, I need a formula to sum this column into basic salary on the stats sheet, if possible using the sheet name in column A as a reference to the sheet to sum from. All columns across all FY sheets are set out the same. Stats sheet...
  11. K

    Sports Champion scoring

    Hi guys, Needing some help with creating the functions for this google sheets below. Basically, I would like to be able to select from the drop down the place that the student got for each...
  12. 2

    Run-Time Error 1004 - Select method of range class failed

    Hello, I am extremely new to VBA. I am trying to do something very simple and I am running into this error. In my Excel Workbook, there are several sheets. The ones of interest are named "CAR Daily Report Macro" and "CAR Daily Report." I am setting up a macro to copy and paste data from another...
  13. H

    Automating exporting multiple sheets to new files

    Hi guys (Question is in regard to Excel for Mac 365) I have a fairly massive workbook consisting of around 40-50 sheets. Three of the sheets contains common variables / master data and some calculations, and values from these three are then used in separate sheets per department. In order to...
  14. C

    Google sheets - Add to calendar button

    I have a series of checklists for project management. The last column is next action due (date). I'd like to add another column with a button to add that date to my Google calendar as a reminder and include the small comment in another column as the title for the reminder. Is this possible and...
  15. Saher Naji

    Sort values based on colors, then on values using VBA code

    Hello, I'm tryin to sort values based on colors, then on values The macro was working very well, but on one sheet, so I have to create a new module for each sheet, and because I have around 400 sheets, This is the simple working macro: Sub A_Sort() ' ' A_Sort Macro ' '...
  16. J

    Sheets().Range().Copy - Not working all of a sudden

    Been using the below VBA for years - no issue. All of a sudden i get a break on the bolded line. Guessing something to do with how I use 'Range' as everything else in VBA referencing 'Sheets' is fine. Any advice would be greatly appreciated: Sheets("Blotter").Select Range("AE2:AH2").Select...
  17. R

    Random value must be unique depending on date range

    Hello, I have a button that creates 12 month sheets for a specific year that is entered into an inputbox. The code below enters values (coming from a master sheet list) randomly every workday per month sheet created. I would like to have only unique random values per week, and a minimum of 2...
  18. Saher Naji

    Making the VBA code affect a specific range of pages

    Hello, I have this very simple code Sub SortByTime() ' ' SortByTime Macro ' Sort by Time ' ' Keyboard Shortcut: Ctrl+Shift+M ' Range("C4:J43").Select ActiveWindow.SmallScroll Down:=-36 ActiveWorkbook.Worksheets("Jan_1").Sort.SortFields.Clear...
  19. D

    Connecting Dynamic Table with Manual Static Data in Sheets

    Hi All, first time poster, long time lurker! Problem: Gym churn report. Client details are imported from a CRM who match criteria (not attended a class for 30 days). The Trainers then manually add if they contacted said member and add notes. When this list is refreshed and client data gets...
  20. N

    Auto Transfer data from Google sheets to Excel at a set time interval. Help Please.

    Hi everyone, I am new to VBA. I have been trying to get the below code to work, but I am having some trouble. What the code should do: Pick the data from a Google Sheet and transfer/update it to the Excel Worksheet every 20 seconds. Problem: The updating part works fine, the delay works fine...

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