sheets

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

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

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

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

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

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

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

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

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

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

Hi guys, Needing some help with creating the functions for this google sheets below. https://docs.google.com/spreadsheets/d/1FNtXK7l_qcNwKQBVAyHHGwbPNDvrfc-qQrNbfwCf5vA/edit?usp=sharing Basically, I would like to be able to select from the drop down the place that the student got for each...

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

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

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

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

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

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

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

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

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