1. S

    How to convert date

    Hi, I am downloading data from JDE in excel and dates are appearing like as follows, how to change them to normal DD/MM/YYYY ? 118362 119002 119246 119273 119316 <colgroup><col></colgroup><tbody> </tbody>
  2. V

    Date formula with multiple conditions and nested ifs

    Hi, I need a formula that tells me 4 options based on a date in C3: Overdue= the date has passed Approaching= date is 5 days away Pending= normal status Complete: if A1 is = Yes then Complete What I currently have is this : =If(TODAY()-C3<=5, "Aproaching","Pending") I'd be really grateful...
  3. M

    Need normal formula instead volatile

    Hello,</SPAN> At present using following volatile formula does it is possible to be converted in the normal formula</SPAN></SPAN> Book1EFG1233 | 0 | 0 | 2 | 2 | 2 | 1 | 1 | 13Sheet1Cell FormulasCellFormulaG3=MATCH(1000,INDEX(FIND(" | "&ROW(INDIRECT("1:999"))&" | "," | "&E3&" | "),0)) Thank...
  4. I

    MsgBox yes / no advice

    Morning, I have the code below but would like some advise for a slight alteration please as i got lost with the yes / no part of it.. The code saves a screen shot in the form of a PDF file. The Yes / No box is where im stuck. Clicking No would just continue to save as normal Clicking Yes...
  5. J

    =UNIQUE coming to O365?

    Hi all Does anyone have an ideas of when the new array formulas are coming to excel O365? They were released to insiders exactly one year ago now but still no sign for normal users. Apologies if there is already a thread on this, I I did a quick search but couldn't find Thanks Joe
  6. G

    Userforms resizing and reformatting on different monitors

    I have a few userforms on a sheet, but when I use them on a different sized monitor, they resize (often much larger) and the contents are not organized well like I have them set. As soon as I go in the VBA Editor and resize them back to normal, they take on all their old formatting, but I was...
  7. T

    Normal v Array formulae

    On my worksheet, cells A1 through to B6, I have the values 1,2,3,4,5,6 from A1, A2, A3, etc. In cell D1, I type: =SUM(A1:A3*B1:B3) and enter it as an ARRAY formula to get the result of: 32 I understand how this is arrived. It is multiplying cell A1 with B1, then A2 with B2 and then...
  8. C

    Add formula after index, match

    Hi friends, is it possible to add formula after index match in vba , in normal index match its working but not with vba. vba code Sub lookup() lastrow = Cells(Rows.Count, "e").End(xlUp).Row For i = 2 To lastrow Range("e" & i) = Range("b" & Application.Match(Cells(i, 4)...
  9. N

    Updating charts over time

    Hi all, bit of a long shot, but... Does anybody know if I can update a chart automatically as more data is populated, over time? In Excel 2016. I have a set of data in various pivot tables - these Pivots update when I open the workbook each time using auto-refresh within the Options menu of...
  10. C

    Large, unstable ODBC file

    HI, How large are ODC files? I have one that is 3mb, even when I reduce it to a few lines. Itis slow and lumbering. Is this normal fo ODBC files? Thanks
  11. D

    Calculate time with different shifts

    I am Daphne from the Netherlands and I have a urgentquestion. I have to make a sheet/formulas for work. I can work with Excel but don’t have the whole knowledge of it. Ok what is my issue. I hope I can explain it correctly in myDutchy/English. Sheets contains personnel names, days, start...
  12. T

    Excel to Copy and Paste to a non MS Program

    Morning, I am trying to figure out how to get Excel to integrate with another program that is not a MS program. All i am wanting to do is take a selection of data out of Excel, cell L:L and paste it to the fields in this program into the Normal Bin Location. How would i do that with VBA?
  13. J

    Protected view File

    code Sub test8() ' ' test8 Macro ' ActiveWindow.ActivateNext Application.ActiveProtectedViewWindow.Edit ActiveWindow.ActivateNext End Sub Hi Experts, I have a protected view file and a normal one. I am trying to run the above code from the normal one but I'm getting run time error...
  14. M

    Disable a Control Button

    I am Using a Forms Control button to run a macro. I would like to have the Button disabled till certain requirements are met. How can I disable the button. It is called Button 6 I have tried the following code but the button still works as normal even though the sheet is protected...
  15. A

    Unable To Return To Normal Texct From Italic

    I was successfull in italicizing text in my textbox, but I am struggling with turning the italic format off to return the text to normal. With uf9_poststaff .pin.Enabled = True .dcard_id.Enabled = True...
  16. B

    Date Picker Help

    Hi Everyone, I put the Microsoft Date Picker in a cell and I noticed every time I open the workbook I have to work the mouse wheel to get it to activate. Is this normal and/or is there a way around that? Thank You!
  17. DRSteele

    Averages per Day

    Can someone please help me? I have a Query Table of climate data from 1/1/1900 to today which I update regularly. I wish to calulate the mean High for each of the days (e.g., month 2 day 19) and compare it to the High for each date (e.g. all of the Feb 19s), subsequently indicating whether it...
  18. G

    Run code generated from string

    Hi, I have this If a = 56 Then b = session.findById("wnd[0]/usr/ctxtAEDAT-HIGH").Text How do I get the session.findById("wnd[0]/usr/ctxtAEDAT-HIGH").Text part of the sting to run as normal code, since it comes now out of a sting?
  19. D

    Seeing 2 coordinates for a Cell. Never seen before

    Got a file from another company. It is showing two coordinates for each cell. It has numbers across the top rather than letters. Has anyone ever seen this before? Is there any way to convert to normal Excel?
  20. M

    cell auto-populates with items from other cells

    I would like to a cell auto-populate with items from drop down lists that are not normal values. I have cells of medical problems all have a drop down list with a normal item first, followed by abnormals. If an abnormal item is placed in the field I want it to auto-populate a cell so I can list...

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