trouble

Greetings, I have the macro below giving trouble. The body of the macro will run, but does not want to seem to perform the task on a new sheet. It seems to be performing the same task on the same sheet (once for every sheet in the workbook) Dim ws As Worksheet For Each ws In...

Good day, I've having trouble transposing a bunch of XML bracket data horizontally. Data is like so <tbody> App a b c d /App App a c d e f /App </tbody> I need it to look like this <tbody> App a b c d /App App a c d e f /App </tbody>...

This is my formula but if any cell in range c5-c41 is blank it returns a ref error...

I've got a question in regards to a formula that I'm having trouble solving. Is there a way to find the times with the shortest time between them and then be able to calculate the time inbetween said times. I would normally not have trouble doing this (when the times are in different cells)...

Hi, Brand new here, and I'm having a little trouble with the site. First problem I ran into is trying to paste VBA code onto a post. I click the "paste as plain text" button, a window pops up, I hit ctrl+v, submit it, and nothing happens. Sometimes the window won't even pop up. I've also...

Hi I have 37 numbers in J5-J41, which I would like to rank from 1-37. Highest number at position 1. I’m having trouble working this out. Thank you for your help. Regards

Hi. I'm trying to report on 100 customers. A select 20 I want to list individually every month, these are not necessarily the top 20 but a select 20 and the other 80 I just want a combined total and not to be listed individually. I can get the select 20 without any trouble but I can't find a way...

Hi I am having trouble getting this simple task completed. I want to retrieve the lines from the dataset which match the criteria in the criteria range as there's more than one criteria, the lines retrieved must match just one of the criteria to appear in the result. The formula I am having...

Hey, I am simply trying to copy value from cell B2 and paste it into cell B3 but am unable to do so. could someone please guide me as the what needs to be changed in the following vba script? Range(B2).Value = Range(B3).Value Thanks. will appreciate any help.

I can't get a nested if statement to work. Using Excel 2010 on Windows 10 This my current working formula: =IF(Q4="SML STND",2.41, IF(Q4="LRG STND",IF(R4<=1,3.19,IF(R4<=2,4.71,4.71+(ROUNDUP(R4,0)-2)*0.38)), IF(Q4="SPL OVER",IF(R4<=90,137.32,137.32+(ROUNDUP(R4,0)-90)*0.91), IF(Q4="LRG...

Good day, Tried searching for this, but was unable to come up with anything that solved my problem. I am trying to write a formula to autonumber the payments received from each customer. <TBODY> ID Payment # 1001 1 1001 2 2001 1 3001 1 1001 3 2001 2 </TBODY> Having...

https://imgur.com/a/FWGxVXT Please refer to image above. I basically need to separate these items into three columns (Item Number, Item Name, and Screen Number) from the date in columns A and B. The trouble I am having is that there are about 30,000 line items and some of them are clustered...

Hi everyone! When I try to open my spreadsheet, I receive this message: Then, I receive this error message: I'm in panic and in really trouble! Anyone can help me, please? I can't attached the spreadsheet and I can't share a link =( Thanks for someone who could me help!

I hope that this is not too dopey a question. I have a column containing a variation of UK postcodes where there can be 1 or 2 letters and 2 numbers grouped together like DE74 or E7 followed by a space and a further digit like DE74 2 and E7 9 but I am having trouble searching specifically for E7...

I have problems when applying the following code ActiveSheet.Range("$A$1:$B$7").AutoFilter Field:=1, Criteria1:= _ "<01.08.2018", Operator:=xlAnd When the macro activates the filter. All values are filtered and are not visible in the list (values larger, equal and lower than...

I am having trouble with a slope equation. =slope(if(Q7:1506>1,Q7:Q1506),if(And(F7:F1506>Y1480,F7:F1506<Y1481),F7:F1506)) ctrl+Shift+entr Column Q is a bunch of data numbers only Column F is dates Column Y are the 2 dates I am looking between I want to get the slop of the data between the dates...

Hello, I am trying to use the "indirect" function so when I insert a row, the formula does not change (rows stay the same). Having trouble using the indirection function the following formula. Any help would be appreciated. "=AVERAGE(SMALL(A3:A12,{1,2,3,4}))"

Hi all. I am have a little trouble. I have a column in my data set that is formatted below: MUS 5 - BULK - PAC I need to pull only the text out in between the two dashes. I think this is all the info you need but please let me know!

Hi I am having trouble converting times, i can get it to work so far but all times with a zero at the end show as 3 digit, is there a way to convert it properly please? thanks for any help D <colgroup><col style="mso-width-source:userset;mso-width-alt:8996;width:185pt" width="246">...

I'm having trouble with the below not deleting the entire row. For Each cel In Range("L1", Range("L" & Rows.Count).End(xlUp)) If Left(cel.Value, 1) <> 8 Then cel.EntireRow.Delete End If Next