automatically

Just wondering if its possible to update prices by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adjust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. I...

Hi all, I am looking to be able to input a figure into a cell and when I press enter, have the cell automatically remove the vat @ 20% I know the calculation is to divide by 1.2, but thats as far as my knowledge takes me! Is there any code I could use to do this. I have a spreadsheet from work...

what is the formula to match automatically the second value if the result of the first match is n/a or zero? thank you!

Hi, I have 4 slicers which I am using to be able to update multiple pivot tables at once. My question is, is there a function/formula to where I can have the sliders automatically update based on the contents of another cell? Example: I have a sheet containing a list of every restaurant in...

Good Morning I need to understand how to write macros to automatically resize worksheets to display the same on all computer screen sizes. theamateur1939

How to drop down list (data validation ) automatically when cell is selected ? How to make the list ( data validation ) searchable ?

I have an excel spreadsheet which I am trying to improve. One of the columns is based on whether a shift was a morning shift (AM) or an afternoon shift (PM). currently it is using a data validation and I have to pick from a drop down list. Is there a formula that automatically inputs either AM...

Hi, I've managed to find some VBA code on Google that will automatically order my data (below), but it's not quite what I need. I'm looking at entering a job number in column A, an order in column B and then text in column C. Once the text is entered in C, I'd like my data to automatically...

Hi all, I'm hoping that someone can assist me with this! I have an Excel file located on my C drive C:\Users\Barry\Concessions\Concessionsregister.xlsm There is an access database in the same location C:\Users\Barry\Concessions\ConcessionsDatabase.V1.accdb I have a data connection in excel...

In column G I need to see the SUM of column D from the row i'm currently on up to row 3 is there a way to write a formula that when i copy it down it automatically expands the sum cells? so if i'm in G20 it sums D20 all the way back to D3 and then if i drag that formula down it automatically...

<tbody> QTY Description Sub-category Rate Total 1 sprinkler £ £ 1 pipe £ £ 1 labour £ £ 1 design £ £ 1 hangers £ £ </tbody> So, I'm working on a spread sheet for work but hit a bit of a wall. I’ve got part of this spread sheet to work. This is...

Good morning; I get multiple text files that need to be imported and parsed. I wanted to automate this function including allowing a user to navigate to the folder for the source files. Also, do not want to use VB since my company does not allow this. Any ideas? Thanks

Hello Excel Community, I have two queries : 1. In specific cells, I have entered Sum & Division type formulas. When I enter data in source cells, its not updated automatically. I have to go manually to the formula's cells, press F2 and then when press ENTER, data updates. Need to sort...

Just wondering if its possible to update numbers by inflation on specific dates. As an example, i'd like a loaf of bread at $1 to automatically adust for a predetermined inflation rate on every Jan 1. I know i can make columns but I'd like only one specific cell to constantly update annually. Thanks

Hi everyone I've one question , is there a way to do this automatically if i select YES in D4 in Sheet(input) , automatically will be writen in D4 in Tasks(data) with respect to the reference name RBC03 i hope you got my point if this worked i will buy touch screen and i will attach it...

Hi I am curerntly trying to connect two tables, if to the first table one column will be added the second table will automatically grow to the same size and automatically transfer the formulas from the previous columns in table two to the newly created column. Would be happy if you have a...

Hi, I have a list of dates in a pivot table; I amusing Excel 2016. I would like to present these dates grouped by month; however I cannot seem to do this? Apparently when I put dates into a Pivot on Excel 2016 it automatically groups them - it doesn't with these! Dates are formatted to be...

Hello, How can I make a text expand automatically to fill the merged cells as the range expands? I have a text in a merged cell (cells A10 to A15) and I want it to expand as I add rows in the range. The txt direction is vertical. Thanks.

I don't know why I cannot remember how to do this...but... I have a time cell and I just want to type "1753" in the cell and for it to display as "17:53". How do I have it automatically add the ":" to that cell?

Hi there, First time post on this forum. Looking for some help with the following... I have two separate columns with varying times. The first column contains an arrival time and second column with a completion time. I need the second column completion time to automatically highlight once...