automatically

Hi. Can anyone tell me how to add a formula that automatically changes the colour of a cell to red once the date within that cell expires please? Thanks. David

I'm working with a long list which is a bunch of names in one column - they are in teams of a maximum of 5, but usually less so I need to create blanks rows to keep things in order: Column A/B is what I need to achieve - from the basic list I get in column E... <tbody> A B C D E...

Hi, so i am trying to get one last thing working on my work excel before i leave. I have tried a couple of the macros that i have found on this site, but couldn't get them to fully work. So basically i have 12 cells where they update automatically and i am trying to set it up so they also...

Hi all, i would to provide me support so that, when i enter in cell "I4" the text "MONTHLY" should hide automatically the entire columns "D" and "E" and when i change the text to "YEARLY" should unhide the columns. Thank you all in advance

Is this possible with Excel? Automatically e-mail a client when a value is typed in a certain cell. And as you see on the picture, there must be 3 or more e-mail templates. [1]: https://drive.google.com/file/d/1NGo1aQHffubZ-ptiQ8QGUh3Zi1OP2ctL/view?usp=sharing Please share some...

Hi, I'm trying to set up an advanced filter that updates automatically and here's my code: Sub advancedfilter() Sheets("Sheet1").Range("A9:N151").AdvancedFilter Action:=xlFilterCopy, _ CriteriaRange:=Sheets("Sheet1").Range("K1:K2"), _ CopyToRange:=Sheets("Sheet2").Range("A8:N8") _...

When you double click on the line between 2 column Letters is automatically makes the column width fit the widest cell value. Is there a way to set excel or a work sheet to always automatically adjust the column width to the widest value?

So let me explain. I have a table with months along the top row, a product in cell A2, and each month I have new data Jan = 20% Feb = 30% Mar = 40% Apr = 32% etc I have a different cell on another worksheet in the workbook that I want to automatically put in the latest value in the year...

Hi, I am working on a macro where it should automatically save PDF when the value for 2 cells in different sheets is not blank. I have the below code but it does not run automatically, I have to press the "play" button in the module for it to run. Please help check if there is something wrong...

Hello all, Let's say there is new data set is put into sheet "MASTER" on a weekly basis. The rest of the sheets are all tables populated using "INDEX MATCH" pertaining to data found in "MASTER." How would you have the tables automatically adjust number of rows to account for new/deleted...

Hi, This is my first post but I have found many answers on this website before but struggling to find something on the following problem: I am currently trying to write a VBA code which would automatically hide a whole row when this formula displays a blank =IFNA(VLOOKUP(A10,”Sheet...

Hi All, I would like a macro to start running automatically as soon as I open the Excel file. However, a prompt would ideally appear first, which asks if the user wants to cancel the automatic start of the macro. The user has the option to click on the prompt (or hit a specific key or...

Cell D100 on my sheet has a simple formula pulling data from G11. =G11 I need help with modifying the formula so that on December 31st at midnight the formula will automatically pull data from the next cell G12 and then the following year from G13 and so on each year into perpetuity... Of...

Hi All, I have a workbook that will automatically print a worksheet within it when certain conditions are met. The problem I have is that this is a multi-user workbook who work from different pc's. I want the automatic print to print to the printer that is closest to the users pc. The workbook...

I have been using an Excel-based form for years with a macro button that automatically sent the form as an attachment in an email through Outlook. Locations that have since switched from Outlook to Office365 say the button no longer works. Does anyone know where I can find the macro...

Hi people, If anyone can help. I have near completed my excel sheet but I'm wondering where my dropdown list is, when a yes or no answer is selecting can the sheet automatically insert new cells for further answers to be entered into the sheet that does not mess up the format of my sheet? Any...

Hi All, I am hoping you can help me with something. I am trying to create an automated form on excel where I can automatically input pictures into cells. So for example, I have a picture and text in Cell A1. Is there a way for me to put the same exact text and picture into cell C2 just by...

Hi All, I have the bellow table on a spreadsheet, courier is a drop down list where any of the below could be chosen, what i want to know is if its possible to make it so when ever i select a certain currier from that list can it send an email involving that row. e.g if i select Gopher on row 3...

Hi Can someone help with how to have a single cell automatically update daily from a range. So i have a worksheet for each day of the month and the equipment used can change daily. Currently the identification of the equipment is taken from multiple cells My issue is this then forms a dynamic...

Hi All, i have setup an invoice date and i need to automate the payment due date (7 days after the invoice date) Ive formatted the date as dd mmmm yyyy although how do i automatically add the "st" (for 1st), or "nd" (for 2nd) etc? Need it to be 7th May 2019 thanks Sam