reading

  1. H

    Multiply then copy

    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...
  2. B

    What does @before a function do in new Excel

    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...
  3. P

    CTransferring data to match to a cell value

    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...
  4. B

    Table calculation question

    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...
  5. S

    Print Line Number in English Reading Story with No. of Paragraph

    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...
  6. E

    Reading TXT file strange behavior new lines??

    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...
  7. A

    Add custom column that finds last reading

    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.
  8. H

    reading a range of cell to a part of an array

    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
  9. S

    Having issues with nested formulas

    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...
  10. L

    inheritance/polymorphism in vba

    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...
  11. C

    LOOKUP,IF problem

    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...
  12. B

    how to add friendlynames to hyperlinks

    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
  13. P

    How can I Formati a column to show a reading age as YY/MM

    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 -...
  14. S

    Formula not reading a blank cell properly

    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...
  15. N

    Reading Values in a particular Format

    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...
  16. B

    Searching a list of names, with corsponding data across to another worksheet

    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...
  17. apgmin

    auto populate and substract

    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...
  18. I

    Average code advice

    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...
  19. R

    VBA Copy column based on header name

    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...
  20. F

    Logged hh:mm:ss reading as a timestamp in Excel

    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...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top