put

I just want to know why I am the Visual Basic Applications (VBA) script isn't working as it should be. I am trying to copy and paste multiple tables, depending on the value I put into cell E1. I've used this code here: Sub CopyMulti() Range("A3:D19").Copy Range("E15").Resize(14 *...

I have a list of 150 formulas in Column B I want to put the formula in B1 on the second sheet and extend it from A1:H200 Then I should grab the next formula in B2 and put in on the third sheet And so on Any pointers? Thanks for your suggestions, will help me out a lot

What i would like to do is if any cell in C5:H10 is modified i want the date and time to be placed in column B. Currently this is what i have Private Sub Worksheet_Change(ByVal Target As Range) If Intersect(Target, Range("C5:H105")) Is Nothing Then Exit Sub ' C1:C100 is the price range...

I am a middle school math teacher. I bought Power Excel (2019 edition) and was instantly overwhelmed. I am sure the book has the information to help me but I don't know what is called to do what I want. We have to post grades with comments 4 times a year. The list of comments we can use are...

I have a very long SQL statement which I'm trying to put into my VBA code. In my VBA I have the following format for SQL: With ActiveWorkbook.Connections ("Database").OLEDBConnection .CommandTest = Array ("Select * bla bla bla") I looked through some web information and it was suggested...

I want a drop down list in one workbook that references a dynamic list in another workbook ie it may have entries added to it so I can't hard code the reference? If I select data validation for a cell, I set it to allow a list but what do I put in the source for the list to be from another...

hi guys i need a macro or maybe if there is a way in excel, if i have a column like below and I'm trying to fill the blank spaces with whatever value is on the cell above. Not sure where to start on this. thanks for any help Colum A 1 --- macro should put a 1 1 2 2 2 --- macro should put a 2...

Is there a formula that I can put next to the final date that will "forecast" the number? My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it.

I have a list of people with other information about that person and I want to get selected people and their columns of information into another sheet. Ideally I would like to have a column that I would put an x on the rows I want in the other sheet. Is there a way to do this?

Hi I have a spread sheet with a couple of thousand cells of decimal numbers between two values of 0 & 10. I want to use some type of formula that will put them into five ranges eg "0> & <2"=1, ">2 & <4" =2 etc. What is the best formula to apply in this instance please. Thanks BT

Hi. I'd like to have a button on Sheet 1 where the user clicks it and it creates an exact copy of Sheet 1* but up pops a little box that says "Please enter your name below then click Ok" and when they do that, it creates a new worksheet that is an exact replica of what's on Sheet 1 (even down...

VBA: If given characters !, @ and # found in column B then put 1, 2 and 3 in respective cell in Column C VBA: If given characters $, % and & found in column D then put 1, 2 and 3 in respective cell in Column E Ps. Blank rows present in data

Hi, part of my job is to put dates to documents that were made in the past 15 days or so, and I'd like to know if there's a way to put, for example, if today is 08/10/2019, then I'd put a 4 and it should assume that I want to put 04/10/2019, or a 26 and it should assume that is 26/09/2019 (from...

Hi, Can someone please help me translate this function to VBA? =IF(G5="Delivery",(10000+IF(D5="Ain Jarfa",1000,3000)),10000) I need it in Sub cmdNew_Click as: ws.Cells(nr, "I").formula = (The above function) Note: Instead of "G5" put (ws.Cells(nr, "G")) Instead of "D5" put (ws.Cells(nr...

I have numbers in column A that look like this <tbody> 13,065,102 13,165 4,051,065 600 18,013,092 </tbody> But when I click in the formula bar they are really this (real numbers) <tbody> 13065102 13165 4051065 600 18013092 </tbody> What I need to do is to is put the...

Hi I am trying to put a code together into a command button which opens the userform1, but if someone else has the userform open already I want a msgbox pop up to say that ‘userform is in use’, I have put the following code togetherbut getting no joy. Hope you can help? Private Sub...

Hi All, I'm trying to do this formul but is not working. =IF(ISNUMBER(SEARCH("*LR 10*";A2));"M01";B2) so in column A2 I have the long desription of the loan and I want to find the ones that contain "LR 10", and if this is true to put in cell C2 "M01" otherwise the value that is in cell B2...

Hello, I thought I had this worked out. I am trying to get the points in cell C4 to show up in z3 IF "H4-20"or "J4-14" which in this case is H4-20, to show up in cell "Z3" =IF(H4>J4,C4,O4) This formula is located in Cell "Z3" But without a score put in h4 or J4 it will show "O4'S 90" in...

Hello, Is there a way to have a result of the top 5 highest scores? Here's my example. Entered manually: A1 = Dan - B1 = 63 A2 = Bill - B2 = 54 A3 = Steve - B3 = 73 A4 = Ben - B4 = 38 A5 = Patrick - B5 = 45 A6 = Jack - B6 = 104 A7 = Craig - B7 = 73 I put the tie on...

I have a workbook with VBA that was made years ago with Excel 2003. (see VBA below) The sheets have many cells throughout that I can "Check off" with a click, to put an "X" in the cell. (Each column has a hidden column next to it and when there is a "q" in it, the cell to the right will put...