populates

I'm sure this is a simple fix, but I am trying to insert rows in an excel spreadsheet and I want the row I insert to automatically populate the same formula from the row above it. For example: In cell N6, I have =IF(C6="@",E6,0) In cell N7, I have =IF(C7="@",E7,0) Now if I insert an entire...

Is there a way for this code to only look until the last populated row in column A vs the entire columns D:K. IE, the data stops on row 84, but the following populates ' N/A' all the way down D:K where a cell is blank. Thanks in advance! Columns("D:K").Select Selection.Replace...

Hey all, Ive created a button that will do a web scrape to gather estimated values of various video games that I have, and then adds together their estimated values (simple SUM formula)a to give me the total value of my collection. Every time I press the button, it does the necessary web...

I have a monster of a syntax and I can't figure out how to incorporate the function below into the existing string. I want U24 to calculate SUM(S24,T24)*P24*E24 IF("DECKING" populates G24 Here is the syntax...

Hello, My worksheet has datas from the columns A:AI all the way down.. Userform with a listbox populates those datas with filtering by combobox. When I clıck any data from listbox it populates the other comboboxes with given codes below. Private Sub ListBox1_Click() Me.TextBox1.Value =...

Hi, I have a report that is ran every night by our IT team. It has a pivot table that I cannot edit. But when I save, the Field Name not Valid error populates. Is there a way in VBA to bypass this error completely?

Hi, I am trying to conditionally format a large amount of cells. These cells have these formulas in them. =IFERROR(IF(VALUE(VLOOKUP(B7,'Equipment Replacement Tracker'!$C$4:$G$3583,5,FALSE))=0,"Incomplete WO",VALUE(VLOOKUP(B7,'Equipment Replacement Tracker'!$C$4:$G$3583,5,FALSE))), "No Record")...

I have a form with a list box and the following code which populates the list With GroupListBox .AddItem "HMP Low Moss" .AddItem "HMP Barlinnie" .AddItem "HMP Greenock" .AddItem "HMP Edinburgh" This only populates the items, it doesn't select an item. I need a piece of code...

I have the code below, where I'm trying to increment through column F on 1 worksheet, and compare some values against another worksheet. I'm getting one result to copy over to the destination sheet, but there should be 175. Thoughts on where I've gone wrong? Private Sub...

Is there a formula that I could use in B1 that labels the column "Date" as well as applies a VLOOKUP formula for the whole column? Please forgive this atrocious question. I'm having a hard time figuring out how to word this for clarity... My goal is to have a sheet that automatically populates...

When I copy 12/31/39 from MS Access 2013 or Word 2013 to Excel 2013, the result populates as 12/31/1939 vs. 12/31/2039. I've checked the Region & Language settings in the control panel. They are set to treat 2-digit year entries as years between 1950 and 2049. Entering 12/39 directly into...

hiya all, I am trying to run a marco that does the following......... 1. Creates a blank email 2. Populates the "to" field with the contents of cell b1 3. Populates the subject with the contents of cell h4 ( important, pasted as values only ) 4. Sends the mail I know the ronbebruin site...

Thanks in advance, What I am trying to do is use a userform combobox to make a selection and populate multiple textboxes within that userform. The sheet that the values from the combobox are found in Column A. The values occur more than once. The values that are needed to populate the text...

I am working on a form where if B14 is populated with a Person's Name C22 populates their contact info... (which is easily done) However, I am looking to have if B14 is blank (no name populated) but B20 has a name the same C22 populates the same contact info... Is there a formula or work around...

Hi this little problem has been driving me bonkers for days. I have a userform which populates word docs and an excel form with various bits of information. Dates amounts etc. At present the dates age transferred like this 29/01/76 on one of the word letters g would like it to be 29th Jan 2017...

I have an excel sheet the retrieves data from a Sharepoint site. When the data is refreshed and new data populated the target range in my formula updates and the result I get is N/A. The formula I have is =Sumproduct((Results!$A$2:$A$500=C2)*(Results!$G$2:$P$500<>"")). Like I said as soon as...