automatically

  1. S

    Name a worksheet after cell contents

    Hi I have a bit of coding that copies an existing worksheet (called "SCHEMES") and puts it before another worksheet ("AUDIT") but I'd like to add in some code that will automatically take the content of cell A1 of the sheet that's copied across and automatically uses that as the worksheet name...
  2. L

    Automatically rank list based on numbers from highest to lowest

    Hi all, I was wondering if it's possible in Excel to automatically rank numbers from highest to lowest? So in this example, you see that the numbers go from 5 to -1, but if I were to change the -1 to 6, Excel would automatically change the list so that cake is first, candy second and chocolate...
  3. J

    VBA Code to Automatically Re-apply Filter

    Hi - does anyone have a working VBA code to automatically reapply a number filter on greater than 0? I have tried 3 or 4 codes that I found by searching but none of them actually seem to do anything! It is possible that I'm doing something wrong in the applying of them though.. :confused:
  4. F

    Automatically email using lotus Notes - How to Format text

    Dear all, I am a beginner in VBA and I am enjoying a lot how it can help me in my activities. My company uses Lotus Notes, and I am trying to use the code below to send automatically emails using Excell/VBA and Lotus Notes. But the problem is that I don't know how to format the text of the...
  5. L

    Automated Stock Sheet

    Hi, I’m trying to find a solution to automate a stock sheet. I have a register of various sizes based on diameter and length on one tab. On other tabs I’m trying to look at the first tab and automatically add new items or down date quantities you can see on the used / create tab, it has two...
  6. E

    Automatically update cell.value as long as a ActiveX checkbox is checked - excel 365 on WINDOWS

    C2.value is updated when a button is clicked. My wish is that so long cbox1 is checked O17.value = C2.value Private Sub cbox1_Click() If Me.cbox1.onValue = True Then Sheet1.Range("O17").Value = Sheet1.Range("C2").Value End If End SubWith this code I need everytime click the checkbox...
  7. S

    Additional code required to save document to PDF and to automatically adjust with row macro code

    Hi wonderful people. My last enquiry is that I now have one more question. I have written a macro to automatically pdf my document, but when I had rows, I then have a to manually adjust to suit my macros for adding columns and rows. Is there anyway for this code to automatically update when I...
  8. L

    How to automatically update excel without opening it once per week

    Hi, Right now, once a week I need to open a file, refresh the table, save and close the file. Is it possible for excel to automatically update itself without opening it once per week? Thanks in advance.
  9. V

    How to automatically change the visual value after changing number format?

    I wrote a macro to change format of cell by adding pre-fix "19V". The format change under the hood but the value I see only change after I go to the cell and press Enter. How to automatically change the visual value as well? Selection.NumberFormat = """19V""@" Eg: 12345 => 19V12345 (visual...
  10. J

    Creating an Unusual List

    My problem is the following: I am looking to create a list in 'column A' by referencing a range of cells from the range B2:E20 with some blank cells and some not. In the list I want to include only the non-blank cells while also updating automatically if the cells in 'columns B:E' are changed...
  11. K

    Is there a way to automatically duplicate a system subfolder structure in Excel?

    I've been asked to create a tracking template to track every step of the process for formal inquiries that go into a Outlook inbox. The plan right now is to create a system folder for all inquiries, and then in that folder create a subfolder for each day an inquiry comes in, and from who...
  12. K

    conditional formatting with time format

    hi all, if i want to enter a time with format([$-en-US,1]hh:mm) in A1, how can i easily track in column B, if time is larger than A1, bold/color the cell automatically? thanks
  13. M

    Last Modified Date/Time

    Hi, The below works however it does not update automatically, I have to click in to the cell and then refresh the cell. Can any one advise how to automatically refresh this once saved/files opened? Function LastSavedTimeStamp() As Date LastSavedTimeStamp =...
  14. J

    Formula will not automatically adjust for different rows?

    I could use some help with this formula: =(SUMPRODUCT(COUNTIF(INDIRECT("'"&$A$32:$A$34&"'!B11:K11"),"<>"))) This formula is counting the amount of times a value appears in cells B11:K11. The cells A32:A34 refer to the names of different worksheets – Week 1, Week 2 and Week 3. The formula itself...
  15. J

    Retrieve live data from index fund

    Hi there. I own shares in a Canadian index fund. Fund code is RBF556. Canadian index fund. I was just wondering if there is a way to retrieve the quote automatically from the web when the spreadsheet is open. Thank you.
  16. J

    Creating Random number generator but ignoring numbers given

    Hi I have the following formula in A1 =VLOOKUP(Sheet1!$F$1,Sheet1!$B$2:$C$45,2,FALSE) I want to add to the formula to check if the answer I get is the same as in E2,F2 If the answer of A1 is the same I need it to automatically change until the value is not the same as in E2,F2 Please help...
  17. S

    Automatically selecting the Display Area

    I have a long list of stock option strikes, 130 in all. When the stock price moves up or down beyond the number of rows I can see in my display, is there a way to automatically center the display based on a specific cell (at-the-money strike)?
  18. M

    Consolidate by reference - automatically select data

    Hello, I've workbook with some 100 sheets. This number increases each week. In each sheet there is a table with different dates and values assigned to these dates. Each sheet has a same structure. The difference is only in the entered dates. I have to consolidate by dates to get sum of...
  19. G

    Copying Column

    Is there a way to automatically copy and paste a column from one sheet to another formulaically? (not using a macro) That is to say, if I copy and paste data into sheet A, a column of my choosing automatically populates in sheet B. Thank you
  20. J

    Hyperlink

    I want to build a hyperlink or a macro which when clicked on will open an new Outlook email with a copy of the file and the email address automatically populated. Is this possible? Ian

Some videos you may like

This Week's Hot Topics

Top