hard

This macro works, but I would like adapted in two ways: 1) Instead of hard coded d1:d1000, I would like to use selected cells 2) I would like to be asked for the character to use instead of the hard coded "m". Sub RemoveAfter() For Each c In Range("d1:d1000") If InStr(c.Value, "m") > 0...

Hi All, So I have rows of data where I want to count all numbers that are greater than the value in a fixed cell (M13) however I only want to count the numbers in every second column. I have tried the below however the problem is the values are hard coded so when I add more columns (and I plan...

Hi I have a form to enter First and Last name and when I click on Enter to enter them, excel will put these 2 names in the last empty row. To grantee the last empty row, there are 2 ways (code). Thanks for your help I got to know them but could not understand them!. The first one x =...

Hello everyone I have an excell project to do but having hard time. A friend of mine recommended this forum saying there are excell magicians here so I am asking for help I have 15 numbers for example 111122223333444. I need to add a certain number ABCD to that number for ex 4433. so i created...

I have this formula: =IF(AND(B1="HERE",LEFT(D3,7)="STC|A2:"),C3="HERE","") It didn't return the expected result of C3 = "HERE" so I evaluated it. For some reason these two parts of the formula evaluate to TRUE: AND(B1="HERE",LEFT(D3,7)="STC|A2:") but overall the formula evaluates to false...

Hello, I have a setup where: a button function will bring in a row from a template sheet. After that row in inserted above the button, I want one of two things to happen. Either that button deletes itself, and I can have the new button copied over OR I want that button to replace itself...

Hi I had this working last year but am unable to replicate this however hard I try!! I have some data which is importing into Google Sheets. I am now wanting to import the whole sheet into Excel. Last time whatever I did I just had to click on refresh and the data would automatically update...

Hello everyone, I would like to know if there is anyway to do in cells addition. As an exemple, the value of the cell A2 is 2. When I put another value in cell A2 exemple 3, I would like the value of cell A2 to be 5 and not 3. So an addition of the old value and the new value. I can deal...

I need to create a space between 4 groupings, each with 4 years of data in a bar chart in Excel; on Y axis. Right now it's all spaced the same...... hard to explain, I have a pic, don't know how to load it here...????

Hi, I'm trying to get a count from excel based on certain criteria. The table i'm trying to get data from is similar to the below:- <tbody> A B C D 1 Simple Simon Pending Easy 2 Simple Gary Batch 77 Hard 3 Complex Clare Holding Hard 4 Simple Graham Batch 77 Hard 5 Complex Paul...

Hi How can you text-to-column a file like this (please see the link below). It is very hard. Thank you so much.

Hi All, I'm getting an error in cell AU4 with the formula =LOOKUP(2,1/(Origami!$J$2:$J$227=AR4)/(Origami!$Z$2:$Z$227=AT4)/(Origami!$BN$2:$BN$227=AS4),(Origami!W$2:W$1000)). I can see this is connected to the date formula in cell AR4. If i hard code the date in cell AR4, the formula in cell AU4...

'=IF(H9="","",IF(H9="88500100","1217 ADV",IF(I9="BIL",LEFT($U$8,4)&" JIB",))) In column U, I have the above formula, I want to amend the second condition, where it says if H9 is 88500100 then enter 1217 ADV. As you see the 1217 is hard codded, because for January to June of 2018 it will be...

i tried this With Worksheets("Hilfstabelle") Worksheets("Linienauswertung").Range("G14").Value = Application.WorksheetFunction.SumProduct((.Range("D2:D" & Zeilenzahl)) * (.Range("A2:A" & Zeilenzahl) Mod 10), "<9") End With what i want is, sum the values in Column D for each row, where...

Hi, So, in cell B2 I have the number 13. This is a calculated field, so that actual content of the cell is a Sum formula. All I need is for that 13 to appear as 0:13. I've tried everything I can think of but nothing comes out right. Doesn't seem like it should be this hard. Thanks for the...

I'm sure this has been asked, but I can't find it. I have 2 sheets of my workbook... sheet 1 is about 6000 rows: 12345 49318 57419 64753 35489 sheet 2 is about 1000 rows: I want to shade the rows in sheet 1 that appear on sheet 2? I know it's not that hard (if you know what to do), I just...

I have a table of around 1000 rows and 25 columns from which I want to query on 2 parameters and return the results in a single cell. The table below is simplified to show what I am trying to achieve but essentially I am trying to create a query (without VBA if possible) that will lookup all...

Got this formula in my sheet: =LEFT(R3,15). It return the first 15 characters from cell R3. Is there a way I can add hard line break to this formula - after character number 8? What I've found online so far (CHAR) seems to pick data from 2 columns, adding char between them... My aim is to...

I have a formula that has some hard coding in it and while it works, I'd like to eliminate the hard coding so that I can copy it versus having to edit it for each individual In the tab called "numbers4Pat", I have the following formula...

Hi Excel Gurus, I managed to achieve what I was after, but want to show "Internal" if the statement is False and "External" If True. Currently the first two formulas result in True or False only. =SUMPRODUCT(--ISNUMBER(SEARCH({"STL","SCL","STM","STS"},C2)))>0...