formula & macro

Hello, I would like to create a macro that will scan sheet one for cells that contain the word "Complete", Copy the whole row, and paste it into another sheet (Sheet 2 - "Complete") without overwriting the rows in sheet 2. And Finally Deleting the copied "Completed" rows from sheet one. I am...

I have been trying to figure this out for 3 days and am at the end of my rope. I am designing a spreadsheet for a construction firm. The workbook contains an the estimate, client proposal and the PO's for 3 different vendors. On the estimate I have a dropdown list for the vendor, category...

Could someone please help me translating the formula below into VBA coding? I would like if all of these cells were pre-populated behind the scenes. =IF(SUMIF($T$12:$SF$12,"<="&EOMONTH(V$12,0),$T14:$SF14)<=$K14,V14*$J14,(SUMIF($T$12:$SF$12,"<="&EOMONTH(V$12,0),$T14:$SF14)*J14)-$I227) My range...

Hi All, I am looking for a vba which will do the following: Daily I get a list with data. The numbers of rows differs daily. From 10.000 rows to 18.000 rows. I am looking for the following: · VBA to check the dates in column AO and date in columns AP. If date in column AO > AP, select...

Hey guys, I am having loads of trouble editing my spreadsheet and it seems to be taking a really long time (over 20,000 entries)... I have some data for over 500 companies (1990-2015) and they all have different currency units which i need to convert (into EUR). It looks something like this...

Hi I am trying to figure out what appeared to be a simple formula however I thought wrong. Does anyone know how to have a SUMIF apply if a cell contains a certain text? Here is the formula that I have now, which is not working... =SUMIF(AJ1:BC1,"=*Reserved*",OR("=*Actuals*"),AJ2:BC2) What I...

Hi All, I have a small range of results that I would like to automatically sort when the formula changes. Below is what the data looks like; <tbody> 1 A B C 2 Drug A 100 3 Drug B 80 B3-B2 4 Drug C 110 B4-B3 </tbody> I would like to automatically resort A2:B4 from smallest to largest...

Hi, I searched about how to make drop down list from sheets name and i found couple answers by VBA and Formula GET.WORKBOOK and all works fine but when the guy in video used GET.WORKBOOK he said it's a macro formula and didn't work in cell only used in "Name Manager" also you cant make a drop...

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

Hi all, Before this, i just get the number for the info that i want, like right now i need the information in column itself. Formula that i used to get the data =COUNTIF(Q:Q,"*"&Apple&"*") so i got 2. I would like to get the output Like "Apple = Apple-Lemon, Papaya-Apple." Means that, find all...

Hello Experts, I am working with 4 columns where I am in need of a formula where it will check if the director or directors of one company is exactly exist with the same name along with the same number of directors with the company just next to the first one. Let me explain it with a few...

Hello Experts, I am working with 4 columns where I am need a formula where it will check if the one director or directors of one company is exactly with the same name and same number of the company just next to the first one. For example please check the below table where for the both company...

Before I begin, I should tell you all that I am a complete noob to excel and VBA macro. I am trying to compare two excel sheet data by using EXACT formula. sometimes the data ranges to 50 columns and 10000+ rows, So I am using a VBA macro to define the range and applying the formula. perhaps...

greetings .. I have an issue that I included a new row in a sheet that has a "Macro" and I modified the cells in the macro script and the Macro run just fine but my problem is that I updated the range for the new cell that I inserted but an error of (update formula to include cell) appears...

Sub Rangeformula() range("E3").Formula = "=IF(ISERROR(VLOOKUP(D3,$B$3:$C$19037,2,FALSE)),,VLOOKUP(D3,$B$3:$C$19037,2,FALSE)" Range(e3:e20000).filldown End Sub This is my code. it wont run. Run-time Error '1004': Application-defined or object-defined error. *Frustrated*I'm simply trying to...

Hi I have information in one sheet. I want to filter them with formula 3 times. 1. with Card No. 2. With Month 3. With Week and the last, I have personal report for one month or Week <tbody> Row No. Card No. Card&Row No. First Name Last Name Date Week Day Input Time Output Time Presence Time...

So I have been compiling data on a sheet I have for work. Now I have all the data I need and have all the formulas I need to make it work except an auto email function to let customers know that they need to make contact and update their expiration dates. The date of expiration and their email...

Good Evening. I have a long list of values corresponding to a quantity of color put into paint. I need to convert these according to paint size (1ltr, 2.5ltr, 5ltr etc.) However, once the number of drops reaches 48, I need this to translate to 1 (oz). In other words; 5 x 10 = 50.. this would...

Hi Im new to Excel Forums so please be gentle with me I need some help I have some research that i have been doing for work and have just been informed by the developers that they need the data in a certain format. For example i have researched the price of a beer like Budweiser from 6...

I am working with a large spreadsheet that contains specific names and 4 columns over contains a numerical value. What I would like to be able to do is search for the specific text and then have the formula return the value to the right. Example: Pete is located in cell C4, C12, E1, G5. In...