blah

Hi All I have been struggling with this one. I can do it if its a duplicate but not with different criteria. Basically I need to get a formula, preferably using conditional format ( so it colours the rows) I want it highlighting if as example Mr Jones had bread, doughnuts, and cake in the same...

Hello, A "double click" on any of the cells in Column B "Trip" launches a routine which produces the following error at present. <colgroup><col><col><col><col><col></colgroup><tbody> Date Trip Order No. Issue Detail 31/08/2019 60A 1 Issue 1 blah blah blah 31/08/2019 39B 2 Issue 2 blah...

I am very new to Userforms and have learned all I know by researching examples. I'm thrilled with a userform I set up, but can't figure out one final detail. I have loaded a combo box with student names pre-loaded a worksheet using the following: Private Sub UserForm_Initialize() 'Empty...

I've got a chart embedded in a spreadsheet that is called 'Chart 1'. I've got some code to run and set the trendline which seems to run ok. Dim STPChart As Chart Set STPChart = Worksheets("Detector1_Report").ChartObjects("Chart 1").Chart With STPChart blah blah blah... However, I don't...

Good Morning I would like to combine text and formula's for example it would star Hi, and then take the info from the sale sheet by date cell B2 then continue with text blah blah blah and then insert another formula from the sale sheet by date cell H2 and then continue with text blah blah blah...

Hi - hoping some expert can help me with a text search query I've got a column full of text entries. What I would like to do is extract x number of characters after certain keywords. So for example. keyword 'DOB: ' then bring back the next 10 characters So if the below is the text in cell...

I have a section of code below from a much larger piece. The section of code worked when using an input box to acquire a userinput. However, I'd like to have userform replace the inputbox. I've tried just using a userform and inserting the line (as seen below) but that didn't work. I need the...

Hello, I'm trying to create a script that would search a folder, find the last inserted spreadsheet, locate a field and if that field is > 0 send an email. And this is to be run weekly. <tbody> F L O Descr Email Available_Spots 60749 jon.snow@got.com 1 </tbody> I've scraped up a...

First time doing this... I've created a script at this point that is doing what I want. I've also applied this bit below to the Sheet tab in order to cause the cells to be updated automatically any time certain cells are modified: Private Sub Worksheet_Change(ByVal Target As Range) If Not...

Good Morning! I'm tryig to figure out how to create macro that will review a column and list and count values in the field. Example The Column will hav "Unit" as defned by House, Apartment, Barn, whatever. My goal is to try to run something that go through the column and capture all values...

I have a large and complex file currently open and working. I've been saving regular versions v1.1, 1.2 etc throughout the day. When I attempt to reopen any of these I'm getting the error "we found a problem with some content in ..blah blah.. do you want to repair?". The repair tool doesn't work...

Hi, I've got what seems like a simple conversion task that I'm having trouble puzzling out. I have a column of product descriptions (text/html) that contain measurements (i.e. "Medium - 6.3cm x 7cm") and I need to find and convert them from cm to inches. I'm having trouble figuring out how to...

I'm wondering if someone can point me in the direction of a resource that describes the syntax of different combinations of ranges like below. I have trouble remembering the right syntax for concatenating the different items, and I'd just like to bookmark a page that has examples of these types...

<tbody> A B C D E 38 No OP MO Txt Co 39 112254 10 04 FSR Yeah ABB 40 114554 20 04 FLB Whatever ABB 41 144754 10 04 BBA Etc Claptrap 42 112266 40 04 KKT Blah Claptrap 43 123457 15 04 JJF Blah Claptrap 44 111365 10 04 MMN Blah Gardner...

Hello All, I have another question concerning filling data from one sheet to another. Sheet 1 I created is basically a transmittal form, Sheet 2 is a list of sample materials that will need to get approved or rejected once sent. The user will go in at the start of the job and fill on the sheet...

Hi the code below is to type blah in cell a43 then hide rows 25 to 70 for sheets 1 to 5. it works only for sheet1 and then i get error message "selection method of range class failed" Sub fivesheets() For i = 1 To 5 ThisWorkbook.Worksheets(i).Range("a43").Value = "blah"...

I have this macro that email's a specific range from an actvive sheet that works perfectly until I try to add an attachment from a file path on my computer and this is where I get the 438 error. What am I doing wrong? Any help is greatly appreciated. Sub Email_Test() MsgBox "Email will be...

To all, I'm looking for a macro that will allow the user to select multiple cells (up to 5) in a row (Lets say E10 and G10) and then add the sum of those two cells into the left most cell selected (this will usually be the first cell selected but it's possible the user will select the calues...

To all, I'm looking for a macro that will start in cell D6 and see if the cell contains the word "Custom" anywhere in the cell and if so, highlight the column to the last row with data in it. I then need it to move over to D6 and repeat until it encounters the last column with data with it at...

I have rather large textbox where a user can type notes and use the return key for spacing, etc. textbox1.value is (example) 1. Problem1. Solution is blah blah blah. 2. Problem 2. Solution is blah blaha blah. 3.etc 4.etc 5.etc The question is how I can parse this line by line to my...