formula & macro

Hi I have an excel file that has the user answer 3 questions then runs a query against a database. That take a min and thats ok but then the data is dropped into a sheet and there are over 100 formulas that are entered via VBA in about 6 sheets they all look like this =Sumifs('Raw...

Hi, I need some help!! I am trying to put formulas in a few columns. Here's where the problem comes in, I am using variables to look for the column with the headers names. Cells(5,dis).select Price= Application.Match("List Price", .Rows(1), 0) Cost= Application.Match("Cost...

Hello Excel experts. I am a beginner using Excel 2003... requesting help with a formula that will extract the date, certain text, and a dollar value from a string of text I get from a text file from my bank. I will be pasting the text into Excel 2003 starting in A1 and possibly down to A300...

Hi, I am wondering what would be the best way to go about this. I have a column of names,another column of subject and in another column either yes or no. I want data like this........... To become like this <tbody> Name Subject Action...

This code is to work on two tabs in an excel worksheet. I'm hoping to use the below code to replace the formulas below row 2 in columns N to AA with the values that would come from having run the formulas that are kept in row 2. So, what I would like in the output is to have formulas in row 2...

Hi All, I have a data table like this: <tbody> A B C D 1 T 0 1 1 2 G 1 0 0 </tbody> After using formula or macro, it should look like this: <tbody> A B C D 1 T T 1 1 2 G 1 G G </tbody> All 0's has been replaced by the text in the cell from Column A in that row. Have no idea how...

I have this macro LastRow = Cells(Rows.Count, "E").End(xlUp).Row Range("F2").FormulaArray = "=IF(C2=""Job complete"",(D2+E2)-SUM(VLOOKUP(B2&"" - Job assigned/passed"",$A$1:$E$62,{4;5},0)),"""")" 'Insert Array Range("F2").AutoFill Destination:=Range("F2:F" & LastRow), Type:=xlFillDefault...

Hello, I have a list of shifts I did with the date. This list expands as I do more shifts. <tbody> A B 1 Shift Date 2 1 date 1 3 2 date 2 4 3 date 3 5 4 date 4 6 5 date 5 </tbody> I have another list of deliveries (on another sheet) with the shift given, I want to automatically...

Hello, I need help regarding Excel formulas or Macros. It's kinda complicated so I will explain it. I'll post the Excel Template tomorrow as an attachment since my collegue who creates the Excel is not available by now. This Template has fictional employees. On the excel you can see 3...

Hello, I’m trying to configure a solar pump system sizing sheet. Basically, after calculating several criteria, a solar pump model should be automatically selected. The criteria for selection are: required power and required head (m). I need to extract the right model from a table that compiles...

Hey Guys, I am inserting the formula but having trouble getting it to copy down. I want it to copy down to the last row of column AA to account for variable data. Sub Insert_QueryTitle_Formula() Range("AA1").Formula =...

Hi there, I am currently building a spreadsheet for a fantasy football (soccer) game. I've hit a bit of a stumbling block.I have created a simple table which includes players names, clubs, points etc. and a column at the end with a simple drop-down menu that allows you to select a player. I am...

Hi - I'm trying to build an output model similar to the one shown below, please see the following explanations to help answer: Main Issues: (I) When a unique ID has multiple transaction with a selected product code input before meeting the selected threshold amount. (II) Once threshold is met...

I have created a spreadsheet of about 80 or so tabs. On each individual spreadheet, in a specific cell, I have a percentage that is populated. In another cell I have the "IF" formula to populate OFF TRACK or ON TRACK based on what the percentage is. I used this formula in the macro view code...

Hello, So I need my formulas to be dragged across to the next column using a macro but I'm finding it really hard. I've got a few tabs I need to do this on as well, E.g On the 'ACE' tab I need from AS46:AS86 to be dragged across one column to AT46:AT86, but then the next time I need it to go...

Hi I've been trying this for a decade (it seems like that) and searched the whole web, but probably it is just some dots, slashes and other punctual stuff thats wrong with my code. Ok what I'm trying to do is rather easy, I would like to put a countifs formula in a cell by VBA. The more...

Hi, i am having a little trouble with my vba code. I seem to have an error in my countif vba formula. I need B2 to have the formula for countif on range D2 thru last row. The criteria will be D2 (for B2)...D3 (for B3)...D4 (for B4)...and so on. Range("B1").Select ActiveCell.FormulaR1C1 =...

I have this Formula but when i try to add it into a cell it says Application-defined or object-defined error This is the formula ProgForm = "=IFERROR(INDEX('" & PathFile & Filename ProgForm = ProgForm & "'!Division_6[Programmer],AGGREGATE(15,6,(ROW(" & PathFile & Filename ProgForm = ProgForm &...

I am creating a Macros to Update a Formula everytime there is a new value on a defined table. The problem is that even if the Formula is generated correctly in VBA an error appears saying that "Application-defined or object-defined error" This is my code Dim ProjCol As New Collection Dim...

I have a sheet with several formulas that need to be adjusted, and I'm sure there's a faster way to do it than by hand! All the formulas are INDEX formulas (not the array option), and each one is unique. For example, the formulas in F11, F12, and F13 are: =INDEX('App 1T...