auto update

I have a power query ("Query - qry_Riders_Last_5_Years") located on sheet tab "Previous RolledUp Cost Data" which needs to be refreshed only once each workday. I prefer this to happen before everyone gets in and starts their day. This way, they can come in, open the tool and begin working...

Hi Everyone, I was hoping for some help with a piece of code that keeps tripping me up. I work for a store and have lots of pages relating to different kinds of product. I'm attempting to add them all to one "master list" that contains data for a pivot table. New products get added via a...

Hello Everyone This is my question I have a excel book that I have created for like a master inventory list and as I download the inventory excel books from my vendors I wanted to know is there a way for my excel book to check the vendor's file and match the SKU for a product and then...

Hello, I am trying to have a cell (or cells) that log when the last change was made to a shared workbook. I have tried a few options through VBA that I found through searching:Public Function ModDate() ModDate = Format(FileDateTime(ActiveWorkbook.FullName), "m/d/yy hh:nn ampm") End Function...

Hi, I have created a spreadsheet in excel. It will contain the following columns: Date Performed Employee # Last Name First Name Temp Y/N Dept # Dept Name Position I would like to eventually convert this spreadsheet to a table, but for now it is...

I have workbooks on SharePoint. I link data from Book2 to Book1 such as: Book1 cell A1 ='https://hawaii.mil/Tracker/[Book2.xlsm]Tracker'!A1 I understand the concept of not having Book1 open when and if Book2 is opened and moved because the Eternal Link will follow the move. Here is my...

Hi there, I have an excel document where people are going to score points based on sporting predictions. This document will be updated throughout the year. I am looking to have a 'league table' that updates based on when a players total points changes. Thanks

Hi All! Here's what I'm hoping some of you wizards can help me with: My Boss' wife has a mailing list in Excel which exceeds 500 entries. The Master list contains all the addresses. Columns 9 - 13 have designations of x, g, c, j, and p. If the person gets a mailing for Christmas, an "x" is...

I have 20 separate workbooks and each have a pivot table. I would like to write code to open each workbook, update the pivot, save the workbook and close the workbook instead of me having to do that manually to each one. I can place them all in the same folder to make things easier. Ideally...

Hey guys, I have built a dashboard in excel using a couple MSSQL queries and then I filter the data in a pivot table. The only problem I have is that the data in the pivot is not updating unless I refresh. I am populating a few sheets in a table and have set them to auto refresh every 3...

Hi, I have a table which a client is populating with information. The first column contains key information to identify the line of data. The summarized output will be in a second table designed to be more clean and printable than the data input table but the first column needs to correspond to...

So, I have a workbook containing multiple worksheets and I'm trying to clean it up a little bit. This workbook is a list of people that my company contacts and it states if they accept an invitation from us when we contact them or not (in other words there are a bunch of yes and no's next to...

I'm trying to create a virtual purchase order book that will insert a six digit number that updates each time I open it. I also need to track each purchase order I create (just the purchase order number and the amount) on a master sheet. Can someone help me please?

Hi all, I have a form that has three fields (1. Comments (TEXT), 2. Legacy_Comments (TEXT), 3, Comment date (DATE)) Now my users need to keep adding comments to the comment text box, and when they do it automatically adds the date they entered the comment in the Comment date box. Now my problem...

I send these kind of mails to intimate people about upcoming meeting, the format I prepare in Excel 2013 and paste it in Outlook 2013 (as a table, not as an image) Now one of the columns I put as 'Days Remaining' which basically tells the users how many days are there to the review, the...

Hello, First off I want to say thank you to all the moderators/ administrators/ any one else that actively contributes with helping to answer these types of questions. I am pretty new to conditional formatting and some of the more advanced formulas used in Excel. Having said that i will get...

Hello. Could someone please help me with my spreadsheet? I want it to do 2 things; 1 of which I have managed but now I have an error re my drop down lists. 1. I have a main worksheet, where I enter and update rows. Depending on the answer in Column N, all of the corresponding data in that row...

Hey, I'm trying to Auto Update a column once a preceding column is updated. For example, when I update D5, E5 will add the date. Likewise, when I update J5, K5 will add a date. It is important that the date inserted does not update with the current time of the spreadsheet, [ ie. now()]...

I need to have the corresponding row numbers auto update in column A, if it is blank, whenever new data is added. i.e. If there is no row number in A7 when I enter data in D7 then auto enter the row number into the corresponding row in col A, A7 in this case. Obviously do nothing if there is a...

I'm looking for help to create a marco that will auto update a workbook, "Master.xlsx" upon opening from another workbook, "Test.xlsx". Is there VB code that will automatically update when opening "Master"? The thing is that "Test" workbook will have rows added in between the existing rows...