perform

How can I get VBA to perform a vlookup in a range of cells. Right now I have this formulas in cells like below. Cell A8 = IF(C8>"",VLOOKUP($A$7,'Employee Data'!$B$4:$D$27,2,0),"") Cell A9 = IF(C9>"",VLOOKUP($A$7,'Employee Data'!$B$4:$D$27,2,0),"") Cell A10 = IF(C10>"",VLOOKUP($A$7,'Employee...

Can i have a command button on my dynamic worksheets to perform the below function (I have created a button to copy the work sheet, so the new buttons would be copied too ). 1. View button - to highlight or show a range of cells / table in the worksheet 2. Color button- selected cell would be...

Hello everybody. I've a situation as follows. https://imgur.com/HLpoOUH Then, in sheet "Data" I have two values: cell A2 = 7210210 cell A3 = 7210214 Now, I've to loop in this array and write in B2 = 2958 (corresponding to 7210210) and in B3 = 1020 (corresponding to 7210214). How can I...

Can someone assist...I need excel to perform a vlookup and if the value is less than 100.00 then return 0.00 otherwise return the value in the cell.

Hello, I am having problems trying to get this statement to work; specifically for the portion that is supposed to look for any numbers between 1 and 2 and then perform the calcualtion. Can someone take a look to see what I am doing incorrectly? Thanking you in advance. =IF(B38<1,0...

I have developed nested IF formula that works fine but I have to use it in 44835 cells that makes my Excel file 4,8 Mb in size and worksheet pretty slow on i5 Intel with 8 Gb of ram. Is there any way to rewrite formula to make it more efficient or maybe do something else to speed up my program...

When I protect/unprotect cells and then protect the worksheet I allow users to Sort / AutoFilter / Insert Rows. They are only able to perform these functions once and then that ability is removed and they can no longer perform those functions. Is there a way to override this and always allow...

Hello all, I have spent the better part of a day unsuccessfully trying to see if there was a way to toggle the number of criteria on / off to perform a dynamic average. I have included a screen shot of file - essentially, I would like to toggle on / off certain attributes and perform an...

I would like to create an excel macro where I can click on a button, and it will perform the following functions: 1. Open SAP Easy Access 2. Open IM33 - Display Budget of Inv.Prog.Position 3. Search terms laid out within specific cells 4. Upon displaying results, copy information displayed 5...

I need help please, I have various conditions and got this far =IF(AND(W687>0;X686>0);(W687*Y687*G687)+X686*Y687*G687;0) only problem is that if cell W687 is negative it should still perform the calculation for X686 if this cell is positive. How can I change the formula to do this. Thank...

Hi everyone Below i am stuck with one problem, that how to perform vlookup for only selected cells. Here i have 2 sheets, from sheet2 i have to perform vlookup only for specific cells in Sheet1 row B Can that be done????? Sheet 1 <tbody> slno name 1111 asdf 2222 gadsffds 3333...

Greetings, I need some help. Am perform basic multiplication between two cells, one containing numbers & text. Example - Cell A1 - contains the number 5 Cell A2 - contains the words "5 days" Cell A3 - I'd like to multiply A1 times A2 and come up with 25. The word "days" in A2 is creating...

Hello. Your help will be very much appreciated. I have to perform searches to find several items over about 700 workbooks located in a specific directory, just to confirm whether they exist in any of the workbooks or not. Can someone help me with a vba code to perform the search for several...

2.1Carry out a cross-cast check(on the funding worksheet – Total Funding) that uses secondary columns to perform the same calculation but in a different way to ensure your spreadsheet shows it is accurate. How can I perform a cross check in my total funding that uses secondary columns to...

Hi, I have a cell A1 this contains a formula to pull a date from another worksheet using an Index and Match Formula In Cell A2 I want to perform a check to see if that date is greater than or less than today. The problem I have is that my formula in Cell A2 is seeing the formula in A1 and...

I need to compare to columns using index/match but round each value before comparison. Could create a dummy column but that is very cumbersome and ugly. is there a way to perform an operation on each cell value before the comparison =match(round(a6,1),Sheet!A6:A1000) I need...

Good morning all, I am after some help with VBA to perform the follow tasks Find the last populated cell within range C4 to C174 Copy the last populated row from A to H Paste values @ A174 to H174 Delete the original range copied Delete all rows based on C being blank in range C4 to C174...

Hello everyone, Statistics do not lie, and i'm working on a spreadsheet to pull individual information based on how I perform each week. Can someone give me a little guidance as to how I would be able to RANK the times based on which Kart I was driving? ive attached a little bit of the...

Hi, I need a formula to perform the same actions as text to column. I need the phrase ONE_TWO_THREE to be split into 3 columns such as ONE | TWO | THREE. I am assuming I will need a function for each column. Any help will be GREATLY appreciated.

hello I've try , faced to msgbox anwser , stop a macro AND clear email envelope head but I ony able to d one or other It's possible perform both ? cesar