luck

I have posted a couple of times needing help, no luck. So I tried to do it myself, and have been.....unsuccessful. Admittedly I am not very proficient and VBA. Wondering if anyone could take a look at what I got. Help me make the adjustments. Thanks in advance for any help! Need to have...

I have the following statements that ascertain whether a 1 or 0 is shown in a destination cell. I have been trying to combine both statements with no luck. =IF(OR(T29="W"),1,ROUNDDOWN(COUNTIF(T29:T33,"W")/2,0)) =IF(AND(T29="W"),ROUNDDOWN(COUNTIF(AR29:AR33,"W"=2),0)) Is it possible to combine...

I have a range of dates that are written as, for example, 20190102 I am trying to format it to show as 1/2/19 and im not having any luck. I've tried the format cells/date and its not changing. Ive copied and pasted the 20190102 into another work book as a value and tried to format it and had...

I have two worksheets. One is old, one is new. The new sheet needs the same info pulled in as the old sheet, but in a different order, by last name. There are two columns of info associated with the last name, each will need pulled in separately. I have tried a couple different formula with no...

Hi all, I have been racking my head, searching the wonderful world of Google and haven't had any luck finding a solution to my dilemma. Is there a way to filter a query where a specific date field is >=90 and <365 of today's date? Since my dates in the specific field are "Live" (changing every...

Hi Is there any way to pull tables from the following website into a google sheet? https://stats.europeantour.com/widgets-v2/stats.html?season=2018&widgetNo=0#tableSGoffTee Have tried IMPORTHTML but with no luck. Thanks

I have tried the Me.Date_Picker.Value = Value in both worksheet start, userform.intialize tried the Now() with no luck. I have googled this and tried everyway but i keep getting errors....

Hi guys, Got a VBA code to log me into a website and navigate to a certain webpage. now i need some code to select all information on the webpage and paste this into cell a1 on the tab "sheet1". Does anyone know how to do this? I've tried a couple of things but so far no luck :(

I have two lookup if statements that work perfectly in two different cells. One checks the value if the calculation is < Add_med_limit and the 2nd >=Add_med_limit. When I try to combine them in one statement either gives error statement or #value . I tried to combine by adding , after first...

Hi All, I would like to set an exact range and then the following cells I have tried with this with no luck Set rng = Range("A1:AJ1", & activecell.offset(1,0)) Could you help me with this? Thank You in Advance, Philip

hello and thanks for helping I cant seem to quite find what I am looking for so here it goes, I am looking through column A for "*West" then, if the next cell down is blank, I want it to = *West, however, if the next cell down has data, I want it to stop I started with this, and had no luck...

I have been trying to simplify my code with no luck. What I am using works fine but to adopt the same code for more workbooks I would like it to be easier. Currently I am having the VBA evaluate some cells but I would like to have it do the same thing for the whole worksheet and I am not having...

Hi there, I'm hoping someone can help me out. I am trying to make a Summary sheet that contains a formula in column B (starting at B5) that populates the current students listed on the StudentInfo sheet depending on the teacher selected in cell M1 on the Summary Sheet. I have tried using...

I have read a lot about this error online but am not having any luck figuring it out (on Excel for Mac, one file with about 8 worksheets): "This workbook contains links to one or more external sources that could be unsafe. If you trust the links, update them to get the latest data. Otherwise...

This is just infuriating me! Within my macro is the following code: For i = lr To 2 Step -1 If InStr(Range("J" & i).Value, Range("K" & i).Value) Then Rows(i).Delete End If Next i As an example, for 3 of the rows, the value in J is <colgroup><col...

I'm trying to create some easier forms for a health questionnaire. I'm not having much luck. =IF(G4=Male,AND(G3>=45,"1",""),IF(G4=Female,AND(G3>=55,"1","") What am I missing? Or should I use the look up formula?

Hi I need to add more columns on this but it breaks. Doing something wrong or maybe I cant do it? and woul dhave to run this multiple times for different columns? ("D:D.U:U,T:T") -- I tried this but no luck Sub Correction1() 'Text to Columns' With Range("D:D") .TextToColumns...

Excel 2016 Hello all!! When first opening the workbook, I have my form show! I want to have it populate with the last/newest record! Am I correct in assuming I would need to do something like this?? Private Sub Form_Load() If Not Me.NewRecord Then RunCommand...

Hi guys I just ran into a problem where my excel file runs OK in excel 2010 but when someone opens it in excel 2013 they get a menu pop up warning about it being unable to update a link. I have been trying stop this but no luck I have tried the code below in workbookopen() but still no luck...

I have a sheet with a couple hundred rows of data. I want to format the font in G5 to be red if the value is less than D5. This part I have figured out. What I cannot figure out is how to apply this formula to G6, G7, G8,etc... and their corresponding D6,D7, D8, etc... quickly. I am manually...