macro - formula

Hi, I am looking for VBA code to find a solution to a problem. I have a master workbook with various ‘quote enquiries’. Usual things are included such as name, address, phone number, quote details. I also have a column that has the date a quote was sent (column M). I would like a Macro...

Hi all I am back to be schooled on macros. I need help building a macro to use the sum formula on certain values separated by a blank row The data looks like this. 9564.46 2315.15 84842.15 154.32 4844.185 751.15 1548.48 154.84 154.84 I don't know if there is an easy way to paste formulas in...

I created a conditional format in my report to fill the cell in red when this formula = TRUE. <tbody> =AND(B16<>B17,B16<>"",B17<>"") How do I apply this into a macro? I am adding a validation button that will confirm that this AND formula has been corrected. People will see the red but...

Hello all, Forgive my ignorance here, as I am an extreme amateur in the Excel game. I have been searching Google in an attempt to find an example of a macro to accomplish what I want, but since I have little knowledge, it is difficult to know what exactly to search for. This being said, if...

Hello All, I am wanting to perform a simple macro, in my mind, of confirming if a set range of cells all = 0. My current macro is giving me errors. It is the following: Sub ValidateCheckData() Dim ValidationRange As Range Set ValidationRange = Range("H23:I27") If ValidationRange.Value <>...

Hi, I'm not skilled in VBA, so the following is created from Macro Recorder. The macro below functions, though actions 422.csv which was the original file when recording the macro. Rather, i'm wanting the macro to action the respective csv file for that same worksheet. My data is saved in...

Hello, I am still slightly new to VBA but I have a complex (or at least to me) situation that makes me feel like I will need a helper function (used to coding in Java or C) So for the first part. I need the code to be able to reference a cell in workbook (not sheet) and compare it to values in...

Hi guys this is very urgent!,when i'm using below code macro's for creating looping till line no.7 everything is OK but the main problem is line no.8 . my actual problem is after completion of first loop it is showing maximum value in column 5 and row 1 but after second loop is over another...

hi all how can i add the following text within a cell that have more than one line break .example: original text in the cell is : Description <li>first line <li>second line <li>third line i want to add the following to the previous text: Description <ul class='import-product-description'>...

Hello Excel world, I want to perform the LEN formula in a macro for column D. I want to test "=LEN(D:D)=9" and where the last TRUE is highlight all rows above it, including the last TRUE. I have scoured the internet with absolutely zero success in knowing if this is possible or not. Can this...

I am looking to create a macro button. I have no experience with macros, etc. I have a cell (N3) in Sheet 1 (called "16-17M"). I need this value to match a cell (B3) in Sheet 2 (called "Goal Tracking"). I have some conditional formatting that tells me when cell N3 does not match B3. I would...

Hello all and thanks in advance for the help. Hopefully some of you more seasoned excel users can give some suggestions for this one: <tbody> DATE AMT 2/25/16 $50 3/4/16 $100 3/7/16 $300 3/16/16 $500 3/21/16 $300 3/21/16 $300 3/23/16 $300 </tbody> I need to...

Hello! First time post, but this forum has been an amazing resource. I'm a little new to the formula/coding aspect of Excel, so apologies in advance. I'm attempting to get two separate concatenation formulas into a somewhat complex macro. I ended up using the record macro function, but there is...

Hi, I have what I think is a pretty complicated task that I am trying to find a resolution to. I receive a form like LTest from every sales order, I would like to copy certain data from LTest and copy it into 2016 Test 1. Each form is formatted the same and I want to use the data in cell B3...

I having a problem With my macro. It has so many steps that causes my excel to not respond. It there a way to shorten the process. I need a Macro that Removes all punctuation by that i mean ,./':;"()| in column J starting in row 2. DO the same in column K row 2 but also remove - with a space...

I cant get my Macro to find and fill blanks in column "m" starting from row 2. It fills the blanks but it also fill the blanks all the way down to the end of the spreadsheet. I just need it to fill to the last row of data. Also to reset the color when i rerun the macro. So i can fix it and rerun...

Can some one help me fix this error. When i run it the first time it works fine but when i make the edits and run it agian i get the "Overflow 6 Error" Dim cid(100) As String Dim rX As Range Dim rEnd As Range Dim i As Integer Dim x As Integer x = 0 Set rX =...

I really need someones help. I need a code for a macro to scan column M and highlight invalid birth-dates. Only to skip short date (by short date i mean is like this 01/01/1901) only that format, anything other than a shot date to highlight all the way down to the last row with data on it. Not...

Firstly hello and thanks all for nice and working solutions across the forum. now here is my question. I have more than 50,000 rows of data I have learned how to insert a blank row after changing the data in particular row ( that is data changes from day 01 jan 2013 to day 01 feb 2013) here...

Hi I am creating one review record in this record I want to lock the particular cell of the data once the user was close the file (Save & close it ) . Example : There are column A B C in the table once the user enter the information in A1 B1 C1 and he saves then if he want to edit it he can do...