1. G

    Copy all the data from one specific sheet, paste and save that on a new workbook which as to be save in csv on a specific folder path - VBA

    Hello, I'm new to vba, i saw a post when i was researching to: how to copy all the details from one sheet, copy this and save it in csv format on a specific folder. Then luckily I saw the code @Georgiboy posted and tested it: Sub Print_Test() Dim FSO As Object Dim TextFile As Object Dim rCell...
  2. K

    Automatically send email select rows if cell = "Buy" or "Sell". Kindly help me.

    I am new to VBA. I can't watch excel at all times. I need to get email notifications automatically from excel. I need VBA codes. If cell value = "Buy" in Column Index AR, then automatically send email select rows subject = Scrip Name in Column Index C space Buy space High Break amount in...
  3. S

    Excel change value at the end of the month

    Hello, I want to reset the value of cell E5 on tab2. Every new month the value has to be 001. Is there any option to reset this value every month automatically? Hope there is something possible. Thanks!
  4. P

    How can I setup an Automatic Refresh All for Stock Data Type fields?

    I have Excel2016 and I've created a stock market excel sheet that tracks stocks prices, etc using the new "Stock Data Types" feature, super cool! To see the latest stock data I have to manually press the Refresh All button which while simple is starting to become an annoying routine. What is...
  5. T

    Auto Sort Birthdates

    Hello I am hoping someone may be able to help me. I have a list of birthdates and in my job, I have to purchase gifts for everyone's birthday. Ideally, I like to do this 3 weeks before the birthday comes up to give me time to buy the gift and get it sent to them in good time. It would help me...
  6. L

    Hide columns automatically based on year and month imputs

    Hello everyone! and thank you for your time. I work as a financial analyst and I have a VBA question. I would appreciate if you can help me. I'm new to VBA. So, what I want to do is for excel to hide automatically certain columns depending on the imputs on two cells, which indicate the YEAR...
  7. J

    help on how to automatically distribute values (defined as max ) on a list of materials across orders with variable quantities of products as integer

    Hi! I have this extremely big list of material that contains 10000-30000 positions -(COLUMN A) next to it is quantity in pieces (COLUMN B) values vary between 0 and hundred of thousands (these are also MAX VALUES). I need to automatically distribute each position of MATERIAL QUANTITIES over...
  8. 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...
  9. 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...
  10. 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:
  11. 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...
  12. 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...
  13. 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...
  14. 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...
  15. 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.
  16. 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...
  17. 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...
  18. 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...
  19. 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
  20. 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 =...

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