daily

  1. A

    separate daily data into monthly data - using dropdown list

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

    SUMIFS across multiple worksheets IF the sheet name meet the criteria with VBA

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

    Need help with a delete query

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

    Loop to new column (new day)

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

    Count number/share of clients that receive are being delivered daily

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

    Display Data For Today's Date

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

    Summarising daily data by week

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

    Format of Number of Hours

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

    Sum in a Column

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

    vlookup? Index? to sum rows?

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

    Vlookup for Stock price

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

    Saving as a macro enabled excel file

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

    Find and Replace Multiple Values in One Cell Simultaneously

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

    Inserting Input Box in VBA for Excel Macros

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

    Refresh several excel-files with own queries

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

    Update various Excel files daily

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

    >> Daily Schedule

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

    Calculating getting monthly production into daily sales without flattening the tables.

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

    SUMIF not pulling through from source file

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

    spreading percentages across days of the week

    i have a file that takes a weekly sales number and breaks it down to daily sales figures so stores have a daily sales target to hit. Each day of the week (sun-sat) gets a percentage assigned to it based on sales volume of that day. When a store closes, i have to figure out how to take that days...

Some videos you may like

This Week's Hot Topics

Top