automatically update

Good Morning, I'm trying to integrate Microsoft Forms with Excel for an easy to use data entry that can be used on mobile as well. I understand that forms is a survey / exam tool but I'm trying to "IKEA hack" it to be an easy user friendly data entry portal. The user enters data through a form...

Hello, I have been trying to find an answer to the following question from various sources with no luck. I have a PowerPoint that is linked to Excel Doc A. Excel Doc A pulls information from Excel Doc B. I want Excel Doc A to automatically update from the information in Doc B without having to...

Hi, With regarding the following macro, I need help adding the extra coding required if I wish to have the macro run automatically when the value of a particular cell changes. I'm new to using <acronym title="visual basic for applications" style="border-width: 0px 0px 1px; border-bottom-style...

I have a master excel document at work and I get about 80 emails a day with the same excel sheet in it but with information filled out that I have to manually enter the information from each of those excel sheets into mine. Is there a way to have excel automatically do it? It would save me hours...

Hello, I'm a Dungeon Master for my Pathfinder RPG group and am making an Initiative/Combat Tracker in Excel 2013. I'm not sure how to go about doing this. What I'd like to do is make a button that when pressed will refresh data stored in cells with the =RandBetween(1,20) function in order to...

I have a weekly cash flow statement for 52 weeks to December 2013 in one tab i.e. 52 columns of data. In another tab, I have a 4 week i.e. monthly view of the data. On a separate input tab users are able to select the appropriate week ending date which then automatically feeds through to my 4...

So I have an excel problem (first time user) and I have to adjust for inflation for a fortnightly payment. So the payment comes in every fortnight and its $900. Inflation is estimated approx. 4% and its to occur on a yearly basis on and after 1/07/2014 (so the next one would be 1/07/2015 and...

Hello, I have a working VLOOKUP formula for generating a one page inventory list. It grabs values from worksheets in other spreadsheets. The only problem is it doesn't automatically update. Please, someone help me! Thanks in advance, Drowning in Quicksand

Hi all! So, I am certainly not an advanced user but take pride in the fact that I can usually figure something out on my own but am stumped here. I have a table in the 'Property Openings' tab which has a data list in column A for job title. The 'Titles' tab has all of the Property job titles in...

I have created a dynamic named range in the Variables sheet of the workbook listing employees and what their role is. The list is by department also, so there is two columns for each dept., ie: Dept A Dept B Employee ROLE Employee ROLE I need these to populate in a...

Hello, This is my first post. I will try to follow all the rules. First, thanks for this forum. Somtimes you just need a little help. The questions about updating a chart automaticallyin Excel 2003 has been posted many times. I am working with a row type. <TABLE style="WIDTH: 192pt...