update

I am trying to update a range of cells in my database which is an excel sheet with another input range. The range in the database is named "MyRange". The Input Range is named "Input" When I use this code: Range("MyRange") = Range("Input") nothing happens When I use: Range("MyRange") =...

Hi all, I am using Excel 2016 and want to update a "Box and Whisker" chart with new "Source Data" in a dynamic range. One workaround is to delete "Chart 1" and create a new "Box and Whisker" chart but how to update existing chart? I have tried below code and others but I can't get it to work...

Good afternoon, Could someone please help me with a problem I am having? I am trying to reference a cell in Sheet1 by using ='Sheet2'!A2 for example and carry it down to ='Sheet2'!A30, but when I insert a row between that range and type in information it doesn't auto update. Further...

Hi all, I am setting up a spreadsheet that pulls all of my credit card transactions. Once they are pulled, I manually categorize them. I have an issue with a formula that is supposed to count the number of uncategorized transactions (so I know to update them). Here is what I wrote...

I’ve got a loop that puts an ID number into a cell and thencopies the results from another cell to an output sheet based on formula on thesheet, however the vba code doesn’t wait for the formula to update the results cells and so copies whatever was in the result cells at the start of the...

Hi, I am using a TEXTJOIN function in an ARRAY FORMULA to return multiple matches to one cell. However periodically the formula doesnt update and/or doesnt update correctly. See formula in the attached - cell reference - D63 If you play with the inputs in cells L37:L39 - you will see that...

I am creating links between 2 excel workbooks. When I open one workbook, there supposed to be a popup message as below for me to decide whether to update or don't update the links from the close workbook: In Trust Center, already checked "Prompt user about Data Connections" for Security...

Hi All, I have a Powerpoint presentation that pulls data from a worksheet from excel into it. I have tried the embedded option with update link ticked. I have managed to get the embedded object to auto update with no problems. The issue arises when I have another workbook open that is used...

Whats the fastest way to remove all the symbols in a column of data in access? I only want the numbers and letters to be in my data. My database is about 4 million records and one of the fields in the records is a catalog number and I want to remove all the symbols in the catalog number in...

Hello. I am new here and am hoping someone can help me. I have a userform (Userform1) which has 2 comboboxes, 4 textboxes, 1 listbox and a few commandbuttons. I have the userform working well except for the edit and update buttons. The edit and update buttons are only for the search part of...

Hi all, I have a some very simple coding saved in a Macro Enabled workbook. Everytime I open the workbook I get the message stating that it contains links to other data sources - it gives me the option to Update, Dont Update or Help. What I want is some coding so that on opening the macro...

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...

Hello, I've built a spreadsheet to simulate Monte Carlo analysis of investment portfolio returns. Something odd is going on in that when I update an input condition in the spreadsheet (and the random number generators change) in automatic or manual calculation, the data table including the end...

Hello This is my first real dab into PowerPivot, PowerQuery and data moddeling so go easy on me:) So this is the setting, I need to combine staff data into one big pivot table that can be easily worked with. I have an employee workbook template that will be copied and used for everyone and in...

Hi, I've got $ figures in range I14:T20, and each respective column has a subtotal formula=SUBTOTAL(9,I14:I20), =SUBTOTAL(9,J14:J20), etc The user can run a macro to insert a line at the bottom of the data which will then be populated with $ figures. My question is, when the row is inserted...

I have a donut chart that won't update we the figures change. it used to but now it has stopped doing it. I've redone the chart and updated everything twice and it still won;t update when the numbers change. The numbers are based on formulas (i.e. I don't change them manually) - even if I...

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, 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...

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 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 have a large database for a Genealogy Project. User will choose a family. From my Database each family has a unique number. Based on The family chosen. I have created a range of all the names in the family using the inique family number, to update a death. Because that person may have been...