excel

Hiya All, I have the following formula set in Conditional formatting to highlight the entire row when the town Aston is present. =SEARCH("Aston",$G1) The issue I have is it also highlights cells that contain words with "aston" in them i.e. Glastonbury. Is there a way to stop this? Thanks in...

Hi, Can someone help me with this issue please. I'm searching for ages. My code goes to 'else' when e = 15. At row 15, there is a number/text (C15) that needs to be equal to another number/text (L15). (6002559) When the 'do while' hits e=15 the condition er=et is FALSE, so it goes to 'else'...

I want to make a program that tracks which station each of my projects is at using barcode scanners. My small business deals with putting certain lots through certain stations, kind of like an assembly line but the line is a snake that wraps around it self a couple times over and ties itself in...

Hello everyone, As part of the Olympics celebrations, we've created a couple of trivia quizzes using MS Forms for colleagues. Each MS Forms quiz outputs the results into an excel spreadsheet. From the outputted spreadsheet, the main info I need are: Name The points The amount of time each...

Option Explicit Sub GatherFiguresXXX() Dim wksSource As Worksheet, i As Long, lastRow As Long, rng As Range ActiveWorkbook.Sheets("Sheet1").Copy After:=ActiveWorkbook.Sheets(1) Set wksSource = ActiveSheet: wksSource.Name = "Data" ' SORT DATA BY CUSTOMER, PRODUCT, THEN SUPPLIER...

All, I have two lots of VBA that i need to have combined, my goal is to have a multi select drop down list applied only to cells in Column M ( first code) and add the date in to column O when all cells from Col A to M are completed (second code) This is the multi select drop down code Private...

Good afternoon, Thank you for taking a look at my question i have the below VBA code i managed to pull from a colleagues spreadsheet, what i need though is for this to apply only to cells in Column M from Cell M2 onward. It may be worth noting that my data is in a table. Option Explicit...

Not sure why I am getting the Run-time 1004 error message for this With statement: This line is the culprit: .Range("M2:M" & .Cells(.Rows.count, "L").End(xlUp).Row).FormulaR1C1 = _ "=INT(RC[-1]/1440)&"" ""&TEXT(RC[-1]/1440-INT(RC[-1]/1440),""hh:mm:ss)""" With Sheet8...

Hi, i always encounter error whenver i delete last entry on the excel using the selected indx on listbox i have a listbox SBL_list.List with items coming form Worksheet SBL_T2K ( 9 columns) i need to delete the selected entire row on the listbox from the excel sheet. no error encountered when...

Hi I am happy to join you here. I have an excel sheet that contains thousands of rows, and there is two columns that contains similar text, sometimes identical, and sometimes long. What I need is a way to get the differences of every row of these two columns, maybe in two cells for example: one...

I know this has been asked many times here and in so many different ways before. Still unable to figure out a way to achieve this as per my needs. So, I'm looking for a VBA code to insert multiple photos and arrange them in specific manner(not inside the cells) and resize with custom width...

Hi all, Hope you everyone is well.. I am trying to copy/paste file name to my destination workbook's column A. Below is copying data from all workbooks from a folder and pastes them to my main file. Application.ScreenUpdating = False Dim wkbDest As Workbook Dim wkbSource As Workbook...

Assignment.xlsx Please help me do this assignment, I am not able to understand what type of formula would be added. I am trying to enter calculations manually but it is taking too long. Please help.

I am looking to create a Lambda in Excel that does the same function the formula =REGEXEXTRACT(cell, regex pattern) does in Google Sheets, with the same input parameters.

Hi I have cobbled together from several sources code that hopefully copies a range ("AA1:AN1000") from an open worksheet/ workbook and opens a new blank workbook and copies and pastes as formats & values into the new workbook, saves this to a set directory and closes this file. This is what I...

Good afternoon, I need help to develop a macro for a button. I have an SS where i paste in a string of text to cell A1 for example HLX/DBI/123456 Bloggs, Mr Joe I have a button and macro that removes the forward slash /, the spaces, the comma and full stops and replaces them with an...

Hi all, I have this formula: Formula: =IF(J4=""; IF(I4>P4; "G4 grant bigger than Total grant (IA) by " & TEXT(ROUND(I4-P4; 2); "0.00") & " DKK"; ""); IF(J4>P4; "G5 grant bigger than Total grant (IA) by " & TEXT(ROUND(J4-P4; 2); "0.00") & " DKK"; "")) I want to expand it, so that it looks my...

hi all, I am trying to get rows to move from "active" Sheet to "complete" sheet on the attached file once column "J" has been sent to "complete". for the life of me i can not get it to work and as its a moving sheet thats updated daily i want it to move rows from one sheet to another so it...

Hi, I'm trying to create a 2 column sheet that will be populated by barcodes, which will be scanned into a tablet via a barcode scanner. Each product has our own SKU barcode and a branded barcode (GTIN), I need to capture both on the same row for hundreds of products with minimal effort from...

I am struggling with my excel spreadsheet. I take a weekly inventory of items and subtract it from a needs list to create orders for the week. My coworker does it manually, but I decided to assist by making buttons for him to do various tasks. I can't seem to get this one button accomplished...