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...
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...
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...
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...
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...
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...
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:
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...
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...
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 SubWith this code I need everytime click the checkbox...
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...
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.
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...
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...
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...
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 =...
I could use some help with this formula:
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...
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.
I have the following formula in A1
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