if-then

Hello, I was wondering how to right a code to cut an entire row and paste in another sheet when one cell meets a specific criteria. I have a checklist in column A starting in A2 that has the options -, Pending, Completed, Denied, Mistake-Abandoned. I also have 5 tabs labeled Overview, Pending...

I currently have two if then VBA codes, that are running extremely slow for my large data set and am looking for ways to optimize and speed them up. The first formula is looking in a range of cells in column J that have a value in column A, and if they are blank in J then entering in a formula...

Hi, I have a database of our clients, and the columns are arranged in the following way <tbody> A B C D E F G H I J K ID NAME PHONE ADDRESS CITY STATE ZIP WEBSITE E-MAIL/CONTACT FORMS INDUSTRY STATUS </tbody> I have the following macro, which works great. It basically loops through the...

I want to create 2 if-then statements and if the 4 cells match it returns a value of Yes, if not then No what am I doing wrong =IF(AND(F4=Q4),IF(AND(H4=S4),YES)) Thanks,

Hi, I need to take the min or max of some returned if-then results, but I really need some of those if-then returns to be ignored so that the min or max result makes sense. MIN(IF(hub!$F120=1,hub!G120,(10^10)),IF(bedplate!$F120=1,bedplate!G120,(10^10))) I put in the (10^10) so that any...

Hi, I have excel 2016. I wonder if there's a shorter way to do If-Then, to not repeat an emvedded equation twice, in one cell. If (big-long-thing=-10000, then "", big-long-thing) Want to avoid double length equations in excel, if I can. Thanks!

Good afternoon. I am brand new at Visual Basic. I have written a few simple macros but now I have something that is a bit more challenging and I am having difficulty. The primary worksheet of my workbook - let's call it 'sheet A' consists of 21 columns and 250+ rows. It has a column where the...

Oh Great & Powerful Mr Excel Gurus, please bestow your knowledge upon me, a humble desk jockey! :laugh: I have been tasked with creating a macro that will autopopulate a column in excel based on the values of two other columns (a store number (first column in example) and a date (second column...

The following code works as desired, but will be SLOW when there are more columns present (the elements are merely examples - my actual worksheets have 40+ columns and can have hundreds of rows). I feel like this could be an array formula, but I'm just learning about those. Could someone help...

I need a code to complete this objective: IF sheet count > 16 THEN copy data (range A1:L50) from a sheet named "Multiple" and paste into each worksheet until the last active worksheet has been populated. Any help is greatly appreciated, thank you

Dear Excel vba gurus, A question about filling in a range for a vba newbie: In column A of my sheet 1, I have a listing of 9000+ items, but all of these are text, with no values. Also, all of these are being drawn from a pool of around 300 unique items. I have numbers that corresponds to...

<tbody> GLYT Genlyte Group Inc. 4◄ 4◄ 2/4/2005 $86.98 $90.04 2/11/2005 3.52% SGTL Sigmatel, Inc. €◄ € 1/14/2005 $36.40 $40.01 2/11/2005 9.92% LDIS Leadis Technology, Inc. ∩⌂ ⌂ 1/14/2005 $7.52 $6.81 2/11/2005 -9.39% CEDC Central European Distr AC AC 1/28/2005 $32.37 $33.85 2/11/2005 4.57%...

I am trying to create a macro that autosums columns with a varying number of rows without including numbers from the sets of data above it. Her is an example: Row 1 Row 2 Row 3 Autosum Rows 1-3 Row 4 Row 5 Autosum Rows 4-5 I found this formula that seems to work for the most part...

Have a large If, ElseIf statement. This goes 3 layers deep. The problem is, the "End If" portion of the 3rd layer is exiting the entire loop rather than just the local function. Here's a snippit. At the end of the "If Counter > 1 Then" segment is the problem. I've tried embedding the If...

I am currently trying to design a spreadsheet to keep track of employee metrics for a call center. I have six different employees, and I'm keeping track of the percentage of total calls that each employee takes over the course of a given week. It looks something like this...

Hello I have "IF" data in 1 column and I need to populate the "THEN" into another column. I am creating an index, and it would be easier to have it auto populate than to type everything in. Column N = Document type Column L = Index Number code for example I need to determine if...

Greetings all, I'm hoping to create a dashboard filtering information from another sheet in the workbook. The main data sheet has different statuses available followed by additional data points i.e. "Available" "Unit Number" "price" "contact information" "Location" etc" I was hoping to create...