1. A

    Application.Ontime switching workbooks

    This is a continuation of a post that is now buried. Application.OnTime continuously opening my workbook The Code @AlphaFrog helped with is working perfectly. Each instance of save, the workbook comes to the foreground and then to the background again after the save is completed. While this is...
  2. T

    Is possible to shuffle answers in multiple choice test in EXCEL?

    I have a lot of questions and I need to quickly shuffle answers in Multiple Choice Test. (1 question has 4 answers, A,B,C, or D). For example: Is possible to do that by using VBA or with some formula? Thanks for the help.
  3. O

    Automatic Rolling Months

    Hello Guys, I am actually having an issue where i am using dependant drop down with excel and i want to add to my existing formula data for 24 and 36 months planning, can someone help me please as my actual formula is as per below: =INDEX(ListeMois,MOD($AB$29+COLUMNS($E$54:E54),12)+1) in fact...
  4. G

    Automaticly sort rows by date

    I cant figure out a code, to make the rows sort based on the date, given in column B (From B5). Our Company cannot use Automatic macros (Do to Citrix), so would prefer a module that I can connect to an icon or a button click. The colums from A to V are in use, so the entire row needs to be...
  5. K

    Default to Automatic calculation

    Recently and inexplicably any new workbooks that I open default to manual calculation. I read a few message boards and they said that the solution is to put a workbook in the XLSTART folder that s set to automatic calculation. This works, however any time I open an existing workbook it opens...
  6. L

    Automatic counter based on changes to a cell (inventory usage tracking)

    I am a librarian interested in tracking book checkouts over time. I only need to track how often an item has been used, not when or by whom it was used. My library is too small to justify the purchase of an ILS (circulation software), so I am looking for a simpler solution using what I already...
  7. S

    Automatic Subtraction

    Hi, I want to be able to input data which will automatically be subtracted from another number. For example, in cells E25 to E33, I want the input to be subtracted from 0.880. In cell E34 I want the input to be subtracted from 0.860. Does this have to be done by code? Thank you. :)
  8. G

    Delete all files when date arrives

    Hello, files with the extension on the specified date need automatic deletion. .csv.pdf.xla.xlam.xls.xls.xlsb.xlsm.xlsx can you help me? ****** id="cke_pastebin" style="position: absolute; top: 72px; width: 1px; height: 1px; overflow: hidden; left: -1000px;">can you help me</body>
  9. C

    VBA question - enter timestamp in more than one cell

    I have the following code that puts an automatic timestamp in Column B when a value is entered into the same row in Column A. HOWEVER, what I need is this: When a value is entered in a cell in Column A, the automatic timestamp is created in the corresponding row of Column B AND Column E. Is...
  10. S

    Automatic Disable vba code after specific timeframe

    Hi, I need a automatic vba code to disable the existing vba file after specific timeframe and specific date. Thanks
  11. M

    "Sort by" Formula

    Hi everyone, I am tring to integrate in my formula some data more to make an automatic order in the cell but I don't have no clue how to solve it.:confused: For example if I want to match two column with this formula =IF(ISERROR(VLOOKUP(C2,$A$2:$A$6,1,0)),"",C2), the result will be like this...
  12. K

    sequence in a macro text box

    Hello all, I was thinking is this possible to automatic generate a new number under a text box in macro when I open up the userform with my request: 1) starting with 1906-001, 1906-002, 1906-003... and so on 2) I wish the number showing in textbox2 and textbox2 is default on column C 3) after...
  13. J

    Show & Hide Rows - Depending on value (Automatic Change, buttonless)

    Hey people, Just started using vba and this site has really helped me! So I thought I'd try asking with this; I'm wanting to set up a page on excel so that when B15 reads a value, it reveals the corresponding amount of rows on the page. The Values in B15 are drop box selections of: - Single -...
  14. S

    Automatic Sheet Hyperlinks Based on Name

    Hello, I'd like to be able to have excel create a hyperlink to a sheet whenever the sheet name is typed out in a specific range on a "home page" I currently have this written in a worksheet change event, but I'm fearful that this will severely bog down my spreadsheet once more sheets are...
  15. U

    Question about charts

    Hi! I've been searching but had no luck to find if there is any possible way to make a chart like this automatic in Excel, do you think it is possible? If yes... how so? Hope you can help, thanks in advance!
  16. R

    Automatic MsExcel file publication on a specific WEB site

    I have an always open MsExcel file that updates automatically I would need a macro or VB command that publishes an area of this MsExcel sheet on a WEB page (with USER ID and PASSWORD to access) with an interval of 1 minute. Thank you for your precious help. Roberto Giussani
  17. C

    Automatic birthday emails

    Can you advise in very simple terms, how I can get a spreadsheet with our colleagues birthdays to automatically generate a personal birthday email please?
  18. O

    Automatic numbering in the unsequence's row for grouping

    Can any one please help to make a excel's formula for the automatic numbering instead of manual as below sample <colgroup><col><col></colgroup><tbody> <colgroup><col><col></colgroup><tbody> description automatic numbering w1 1 w1 1 w2 1 w3 1 w1 2 w3 1 w2 1 w3 2 w3 2 w3 3...
  19. G

    How can I make a query automatically create new rows out of specific columns?

    I am trying to create a query that automatically hides questions based on their answer. My end goal is to have the query to pull a file from my C drive as soon as I download it and automatically format it then create a new filtered sheet that only shows questions with a No or N/A answer. The...
  20. A


    I.m running XP and updated my Office a couple of days ago. Ever since I've had to uninstall an Update (KB4462157) each day or it won't load. From Googling it seems I have to turn off Automatic Updates. Can this be done for Office/Excel or must it be Global for the whole computer. I don;'t think...

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...