formula and vba

I really need some help with a formula for a cell to calculate a figure based on another cell. Below is an illustration of the formulas that are needed. I am trying to take a backdoor approach the cell formula due to I am unable to use the indirect process like with multiple sheets in excel on...

LINKBACK http://www.excelforum.com/showthread.php?t=1154872&p=4475242#post4475242 Hi All Need your help on how to write formula in VBA, here's my condition shown in screenshot below yes, the condition is the main data is also generated by macro too, and there'll be a macro to delete...

Hello, I'm pretty new at using VBA. I would like a button on a UserForm to open up an InputBox that requests a value. The code then needs to look up the value in a particular sheet. Based on that found value (which is always in Column A) I will need a MsgBox to pop up that will display some of...

hi, i have got 2 tables. I want to compare 4 columns from both these tables and retrieve data from table2 into table1, if the criteria matches. Now the problem is that the values to be compared will not match exactly. 2 columns would match exact 2 columns would be similar Table1 Table2 The...

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

Morning All, Can anyone help convert this into VBA for me? I need it to automatically run as the worksheet is filled out: =IF(COUNTA(M1:V1)=10,TODAY()+60,"") Currently used in column W Thanks in advance.

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

I am working on an inventory spreadsheet and have multiple things that i have working. but the one thing i seem to be struggling with is that i have a sheet "RECORDS" which keeps track of how many of each item i have for the date the inventory is checked which is every other week). what i am...

Hi Excel Experts, I am fairly new to VB/Macro so any help would be much appreciated. I am trying to create a macro that will search through a worksheet for a particular portion of a formula and replace with something else. Below is what I have built so far: For Each cell In...

Hi, my friend has a hotel and wants me to devise a spreadsheet, I have guest date and time of arrival in column B and date and time left in C and he wants me to add a column that will calculate at any point if the guest occupancy reaches 9. I am stumped, any help would be greatly appreciated...

Hi All I have an ongoing requirement that I'm trying to resolve within a sales order workbook. If Sales person has agreed a fixed price for subsequent sales order lines they enter the price in to sheet 1, and the pricing is pulled through to each order line on sheet 2. However if the Sales...

I have a workbook with three different columns and within each column are approx. 245 formulas. Each formula in a column references a workbook and each column has a different workbook that is referenced. The referenced workbook is labeled in row 3, such as A, AA, and AC all reference workbooks...

I want to control whether a cell is locked or not based on a value in another cell entered on a data entry form. The data entered in row by row, thus the cell column will remain the same but the row number will increase. Thus I want a formula(or vba code?) in cell B1 to say IF(A1="No", unlock...

Hello all, I have a monthly spreadsheet I pull that contains raw data in columns A through AU. I need a VBA or formula that will enable me to instantly delete specific columns I don't need. If possible, I also need for the formula/VBA to delete rows based on column E's values. Thanks in advance.

Basics: The column letter is static (something like column NX:NZ); the numbers of rows for a group can change. The math I want to perform would be positioned differently for each group. Details: I have data like the seen below – my sample shows three groups of various lengths, with one or more...

Hello, I have a formula that checks the bgcolor of a reference cell (rColor), then selects all cells in the defined range (rMatrix) with corresponding color in order to calculate the sum or count the number of cells. Problem is that I want to enter a specific formula that determines the needed...

I have the code : For Each cl1 In Table1 cl1.FormulaArray = _ "=MAX(IF(RC[-4]=(IF(VLOOKUP(RC[-1],Correspondance!R[" & i & "]C[-5]:R[" & j & "]C[-4],2,FALSE)=Log_WK!C[-3],Log_WK!C[-2],0)),Log_WK!C[-5],0))" If Not IsError(cl1) Then Result = cl1 Else...

Hi, I have in worksheet, from row L142 until L237 function: L142= IFERROR((SUM(I142:K142))/(K$242),"") L143= IFERROR((SUM(I143:K143))/(K$242),"") . .. ... .... L237 = IFERROR((SUM(I237:K237))/(K$242),""). Now in VB, I have a simply for loop: For i = 142 to 237 ws.Range("L" & i ).Formula =...

Ok - I admit - I am adding two questions into one thread.:eeek: First scenario: In column G - I have different phases. I need to calucate how many dates it's been in that phase. It's an easy formula =networkdays(O2,Today(), Holidays A1:A10). O2 is the day that it moved into that phase...