reading

Hi - Is there a way to use a macro to multiply .Range("P" & .Rows.Count).End(xlUp) and ws1.Range("A10") then paste the value in ws1.Range("C10")? I guess I could use .Formula, but I was also reading about PasteSpecial and xlMultiply. I just haven't been able to figure out how exactly to use...

I had a popup to explain this change in my formulas but accidentally closed it before reading it... Can someone point me towards an explanation? Example =@IFS(AVERAGE(C14:E14)>=90,"A",A...

Hi. I am wanting to transfer data from one sheet to another within the same workbook. To put it in to context it is a spreadsheet for my work (school) for transferring data about pupil achievement in subjects. I currently have a table (on a spreadsheet called Pivot Table) in the format for...

Non VBA person here. I think I have stumbled my way into VBA code that does what I want it todo but only triggers manually. I need itautomatically to trigger. I think my reading tells me that the tables don’tcalculate automatically. Is there a wayto calculate table on change to a range...

Good afternoon, I want to give line number of reading subject for my students. Paragraph-LineNo-para No-total lines-start no. 1-1-1-5-1 1-2-2-4-6 1-3-3-2-10 1-4-4-3-12 1-5-5-6-15 2-6-6-9-21 2-7-7-4-30 2-8-8-4-34 2-9-9-3-38 3-10-10-3-41 3-11-11-3-44 But now I just carry them by key the number...

While reading a TXT file the following occurs: Such a line like: "31/07/2019 TOTAL" At this line I suppose the "Input #1 , sTxt" instruction is reading read as there was 3 lines in the TXT file: "31" "07" "2019 TOTAL" I expect that this instruction will read the entire line "31/07/2019...

Note: Need a solution in power query (no VBA). Please refer to image below. There needs to be a new custom column added like the green one highlighted below, that would automatically find last reading for the relevant ID, even if the columns are not sorted.

if i have an array like this ReDim ray(1 to 30, 1 to 17) how do i read, say, cells (V8:V37) into the array rows 1:30 but only in the 7th column? thanks

I have a spreadsheet to determine the number of hours a machine worked from one month to the next based on meter readings. However, if a meter reading wasn't entered for a month (total of zero), I need the formula to go back each month until it finds a month where the meter reading is greater...

Hi I am reading that vba is not fully Object Oriented programming but it is close. I am also reading that OOP language such as java, c++ have inheritance and polymorphism capability. So I am guessing VBA does not do inheritance and polymorphism, am I right? What else VBA can not do and other OOP...

I need to retreive the value from the last non blank cell in a set of cells (not on the same row or column), so, I use this formula...

i have tried using Hyperlink formula but it is not opening specified path =hyperlink(A2,B2) There are around 200 cells i have to give friendly names to open specific file any idea how to do this Thanks for reading my post

Hi I'm struggling to change the format of my information to show reading ages in the YY/MM range. I already have info and when I custon and change to YY/MM it changes all the years to 19 from any year age ie 10/11 = 10yrs 11 monthes. but when I custom format the cell it changes to 19/11 -...

I have a formula that says if a cell= "" then "" - for example if in cell C1 I had the following =if(A1="","",B1) The problem is it is not reading cell A1 as being blank even though it appears to be empty. It is in "general" format. The weird thing is it was working a few days ago but now it...

Hello I ve used the following and getting the figure as _(5036882.00) Textbox4.text = Format(Ws.Cells(3, 10).value, "_(*#,##0.00_);_(*#,##0.00);_(* ""-""??_);_(@_)") How the same can be read as 50,36,882 or 50,36,882.00 if i remove the underscore from above syntax still reads as 5,036,882...

Hi I have a list of poeple that have use water. Name - Date - start meter reading - end meter reading etc. I need to seach the list via the name and then copy the Name - Date etc across to a new worksheet. Note, - name maybe listed more than once so I need to look at the complete list and...

cell A1 has the month which has to be manually filled Cell A2, A3,A4... has the dates of that month, Can we have a formula where the dates are autofilled depending on the month mentioned in Cell A1 ( as some months will have 31 days and some 30 days ) Secondly in Cell B2, B3, B4.... we mention...

Hi, Being a Diabetic i use excel to plot my readings every day. I am looking to get an average reading as i enter my values each day. Please can you advise a code to achieve this. Cell range would be B25:AF25 At present there are only figures up to J25 being 9th of this month. So in cell D23...

hello, I have a weird thing happening with this code shown below. 'Find "Current Odometer Reading Date" in Row 1 With Sheets(1).Rows(1) Set t = .Find("Current Odometer Reading Date", lookat:=xlPart) 'If not found, present a message If Not t Is Nothing Then...

2 questions centering around the same report, 2 different ways of getting it and 2 different problems: 1. Report generating from database has total logged time by hh:mm:ss. When I attempt to sum up the time, about 10 cells, each cell reads as a timestamp not as hh:mm:ss. Example: 9:08:50 = 9...