daily

Hi, I'm trying to calculate monthly returns of a stream of returns using an ongoing set of daily returns. So what I was trying to do was something of the sort: A4:A10000 column = WORKDAY(daily dates) B4:B10000 column = daily returns % S2:S61 column = end of month dates (Jan 2019 to Dec 2023)...

Hi. I have a data set which shows daily data for each variable. I have attached an example. I want to present the daily data in a column graph still, but have a dropdown list so i can choose between the months. If i have 3 different graphs, apples, pears, bananas i want 1 dropdown list to be...

Hi All, I have a dynamic range of sheets that is updated daily (new sheet added daily with the same format but updated values). I need to modify the code below to go through all worksheets and use sheet name as a criteria. For example, if I type date 20.02.2019 on Sheet1.Range("A1"), it needs...

Hi Everyone, I am in need of some help on a delete query in an Access table. I have a linked Excel table which is a worksheet that is filled out daily. That worksheet has several columns that are deleted daily with a macro so we can enter new data. What remains are various formulas in various...

Hi Forum, I've recently been tasked with changing a daily process at my work. The general overview is the main tab is filled in daily by some of our operators and then stored in a 'database' as such for each month. However, I'm not that great at VBA My current code is below Sub copier() Dim...

Hi, I have a lists of transports. The list contains for each transport the source (warehouse), the desutination (clientID) and the shipment date. Ultimately, I want to show in a 100% bar chart the share of clients that are being delivered daily, up to 4 times per week, up to x times per week...

Hi there, I was wondering if someone could offer a novice a helping hand? I'm pulling together a dashboard to display, amongst other things, the cumulative daily % variance of actual v target. I have the days of the month in A2-A33 and the actual cumulative +/- % in F2-F33. The only thing I...

I've got daily data, which I want to convert into weekly. However, the data are not for every day. In some cases, it could be from Monday to Sunday, in other it could be only, say, Tuesday and Thursday. Basically any combination. I have a table with a date and a number for that day. I need to...

I believe the formula I have is being accepted by Excel, its not thrown an error. However, I am not sure the format for the hours is causing me a problem. I have to report those orders whereby we hit our SLA of 2hrs and less which is green for good. Over 2hrs is red and not so good. The lady...

This one hopefully is my last one. I need Excel to look up a region, and then the type of job which I have done. Then the final column I need it to total the number of hours. So my CountIFS bit works, but as soon as I add the formula to total the hours up from I11 to I164 it just wont work...

OK lets see if I can give the relevant details or close enough to work ... I have a spreadsheet in which I sum information daily. On the row for day end there is a cell in which I enter a D. I also sum week ending, designated with "WE" in that cell. Also, Monthly designated by "M" and...

If we have big database of daily stock prices with column of date,stock and price. How can we vlookup specific stock in specific date? On daily basis we have a large stocks list... Please solve this...

I am setting up a department file that requires macros to be enabled. I have the code working to the point of opening the save as dialog box, but I am unsure as to how I can force the file type to default to macro enabled. Hopefully someone can help this beginner figure this out. 'This...

Hi, I have the following range in each cell: ='C:\Users\kumar_\Documents\Kumar\Work\Daily Work Files\26 Dec 2018\2017 Daily Report\Daily Report\[Alor Setar.xls]Jan'!D4 I need to change the range to as follows: ='C:\Users\kumar_\Documents\Kumar\Work\Daily Work Files\26 Dec 2018\2018 Daily...

Hi, I have a file which needs to be looked up for data in certain fields on a daily basis. I've created a macro in Excel using INDEX & MATCH. The lookup file name is the same barring the date which changes on a daily basis. I need to run the macro daily to lookup a new value to the master file...

Hey! I have introduced several Excel files in the company, which use Power Query to consolidate different Excel files and prepare them accordingly. The structure is as follows: 1st file: - Query from Access - Querys from 3 Excel files 2.-5. File: Various Excel files. Some of these...

Good day! I have about 10 files that I manually open and update daily. Overall, the procedure takes 30 minutes so far. Is there any way to outsource this update somehow? On a kind server / Sharepoint? What ideas would you have for me? A macro which on an external computer in the morning each...

https://templates.office.com/en-us/Daily-work-schedule-TM02780252hi Hi all, Happy Anniversary to Mr. Excel. I've downloaded the Daily Schedule (Re link above). It's really great tool however the EVENTS doesn't appear in the schedule and I don't know why. It downloads as an excel template...

I have a report where I need to calculate daily sales * production / monthly production. I get it by flattening three tables this model (here's the file, in case you would like to take a look): ... into this model, using Power Query: It works a lot faster than the original SUMIFS and...

Hi All, hope you can help, I have a workbook that pulls information from another workbook. The workbook is not updating when the source file is closed. I am using the following formula: =SUMIF('[Weekly Production 2018 Live Data.xlsx] Daily Summary 2018'!$7:$7,B2,'[Weekly Production 2018 Live...