starts

Hi is this something I need to learn or these are old excel. I am using excel 2013. In the article below, the author said it is an old feature: "In Excel, it is possible to create a pivot table where data comes from several worksheets. It's an old feature, but still useful. The process starts...

Hello everyone! I am a beginnerin using Excel and have the folowng question. I havea dynamic row. I want to enter a formula into the cell which will connect it to the other cell with the year. For example, what to do if I want to make the cell change its value in case the connected cell is...

Hello, I need help with VBA code inserting sum of cells in column R in to column T which are separated by two empty rows. values in column R starts at row 2. Here is an example: <colgroup><col><col></colgroup><tbody> Column R Column T 258.05 567.42 309.37 426.19 930.44...

Hi - I have the following code; Dim lastRow As Long lastRow = Cells(Rows.Count, "D").End(xlUp).Row Range("X2:X" & lastRow).FormulaR1C1 = "=SUM(RC[-3]:RC[-1])" Is there a way to amend or add to this code so that the SUM formula starts in row 2 of column X and continues down, but stops as soon...

I have a formula that is partially working. There are multiple IF statements nested, and the first two actually perform correctly. Once I get into a couple of layers it starts to result in #NAME?. When I click on the various statements within Excel it seems to work through the logic correct...

Hello Excel guru's, I need to convert the text data in an excel sheet to a fixed length number. For example: Emp# ALY/5632 = 41021345632 In this example, output always starts with "4". A=10, Z=35 etc / is removed can I do this in one extra column? Thanks!

starts line 19 if col M =>1, SUM col AM also COUNT thanks ironsides

Im trying to extract the color index of cells in a table in a spreadsheet into an array using a VBA macro. The indexing I have for my for loop is offset as in the count starts at column 2 and row 4, but the array begins at 0,0 or 1,1? Is there a way to enter this info using such a for loop? Thanks

I hope this will not be too difficult to explain but this is a tough one. I have 3 columns, A, B & C and each column has about 10 rows. Each cell is formatted to be a date. So for example, the rows are broken down into weeks, so the first 10 rows will be week 1, the next rows will be week 2...

On a spreadsheet I have the names of five columns that contain the title of Product Codes, Product Description, Dozens per case, Cases per pallet and UOM(Unit of Measure). As of now, on my user form, I have a combo box that the user will select the product, a command button, and a text box. The...

I need a script to clear contents of cells in a range that may contain values less than 1. The data starts from A7 and I am clearing from the range D7 to N7 down to the last used row. Thanks Kelly

Hello, I am trying to figure out the formula for the following: Starting in G2 I want to add a 1 when the dates in C2 and D2 are within the range of G1 and continue on for each cell down and across. The formula I have now does that. However, I cant figure out how to make a formula where: Add a...

I have three data tables. Two of them are sitting on a single sheet and the other is on a different sheet. I am adding from the two tables from the single sheet and pasting the result to the Sheet2 table. Table 1 starts from G4 to O104 and Table 2 starts from P4 to X104. Then table 3 starts...

<tbody> Elevation A Elevation B Elevation C Elevation D 24 32 31 35 15 20 25 30 </tbody> I have two ranges of elevations (Elevation A and B and Elevation C and D) and I need a formula to determine if the two sets overlap. For example, Elevation A starts at 24 and ends at 32 and...

Hi , I have the code Sheet2.ActivateSheet2.Range("B5").End(xlToRight).Select Range("B5").End(xlToRight).AutoFilter Field:=Range("B5").End(xlToRight), Criteria1:="IT6" however, it does not seem to work. My aim is to select the last coloumn with data and this always starts from row 5. So I...

Any formula that starts with =if() doesnt work. What should i do?

Hello! Bit of advice needed as I'm running out of hair to pull! I have a column which contains a landline number, a mobile number, or in some cases both. I need to strip these out into separate columns. The common identifier for each example is the word at the start of the cell. If the cell...

Hi everyone, I´m new here and I hope someone can help me. English is not my native language but I have seen a question similar to mine that was posted in 2010. So, I'll give it a try, and if I make mistakes please forgive me :pray: I am trying to generate a travel calculating formula for...

I need a macro which keeps running at the backend...whether I do anything on system or not, it should perform some activity in excel till the time I want. I need a button that starts that macro and when I want to stop that then i press again a button to stop the macro. Please help.

Hi All, Is there a formula that if the last cell in a range is A6545, that it can return 6545 as a value in another cell. Secondly, if that is possible, can I link that cell value, which in the above example would be 6545 to a named range. So, the range always starts from A1 and ends in A...