daily

  1. R

    Finding the latest saved sub folders in the folder to copy and paste to another folder on daily based work

    Hi all, i'm new to vba work and i'm looking for an help! Question: In x path, on daily basis my team member saves the folders with loan number and today's date ex (7894561023 6-1-2019). they can be more than 25 or some times none on single day. so i want to copy the based on latest date...
  2. M

    Xcel newb needing help calculating simple interest on a judgment

    I have used court calculators in the past to calculate the amount of interest (simple) owed, to-date, on a judgment but have been tasked with something I am unaware how to solve. My best best was to figure out an Xcel formula in hopes of simplifying my life. Judgment was awarded on December...
  3. A

    Concatenating text with with time not working.

    Hi Excel experts, I am trying to concatenate text with time. But it is not working. For example <tbody> FOM MY ECC Staging Margin Transaction Daily 01 -Cell 1 <tbody> 0:50:52 - Cell2 Output is coming as <tbody> FOM MY ECC Staging Margin Transaction Daily 01 0.0353240740740741 I...
  4. P

    Name Lookup

    Good afternoon. I would like to create a sheet (formula) that would scan another sheet for customer name matches. I would like to have a Master Excel Sheet with the names of companies that I work with (i.e. XYZ Corp) I receive Excel sheets daily for work that will be done that impacts...
  5. S

    Find matching value in large table and return associated data

    Hello, I have a large spread sheet that lists multiple currencyvalues. For each value there is anassociated daily fee, weekly fee, and monthly fee. For example: <tbody> Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate Weekly Rate Monthly Rate Value Daily Rate...
  6. D

    today's date match and return value of other cell without changing yesterday's match

    I have spent several hours searching the internet for a solution to no avail. I have an external reference (Daily Exchange Rate) that updates daily. I have a column with a daily date in each row for the entire year. I wish to make the cell next to "today's" date in that column reflect today's...
  7. B

    Importing HTML

    Hi Everyone, I am looking for ideas getting an HTML document into Excel. I've tried the standard "Get Data" but I end up with a 4MB file and have 30-35 tables daily. If its possible to import the entire HTML document to one worksheet with a one click solution that would be great. Any...
  8. K

    Updating Inventory Based on Daily Pull Values

    Okay excel genius', I'm stuck in a rut and need your help! I work at a shop that carries a stock of liquids. It is my job to keep track of the inventory on a daily basis. If this was my only job, then it would be easy, but its not. So, I began working on an Excel file that could automate the...
  9. S

    How to cell reference from certain files based on dates

    I have daily files that "feed" information to summary file. Right now it is a manual process. (copy-paste) There are certain cell ranges in daily file that feed information to specific sheet and specific date in summary file. I want to find a way to make it automatic. I almost did it with the...
  10. B

    Conditional formatting formula help

    I have a spreadsheet which i use record my daily profit and Loss (Daily PL) i have the 365 days of the year in column A descending. At the end of the year i collate the final numbers and these are stored on another worksheet (Totals) in weekly and monthly form this worksheet has several years...
  11. K

    Variable Last cell in a calculation/formula

    Hello - I calculate the difference between the last cell in a column and the first cell in a column. The first cell in the column is an absolute value ($A$1), but the last cell in the column changes daily and the last cell changes daily. For example, today the calculation is A25-$A$1, but...
  12. I

    Index Match Query

    Hi I'm trying to have an index match or equivalent whereby in cell B5 in looks for a daily task then if there is one displays "Daily Task" In cell B6 it then needs to look for a Post Task or a Month task likewise in B7 I have the index match for looking to see if theres a task for each...
  13. W

    Splitting daily figure into 48 periods

    Hi, I have thecode below which splits 24 hourly prices into 48 half hourly periods. Iwould like to do something similar whereby I take a daily figure and split thisinto 48 half hourly periods. I have tried altering it in different ways but nosuccess. Any ideas? Thanks for your help. Column A =...
  14. M

    How to access external add in to click some buttons

    Hi, I have a Facebook Ads Manager for Excel (FAME). I need data daily in my Excel how can I automate to Click Refresh button daily and store values some other location into CSV file or directly into AWS S3. I have been struggling from some time to control that refresh button. Any kind of...
  15. G

    dynamically reference a sheet name within closed workbook and return value

    I have a workbook named "Results" with a row containing the weeks in a year 1 through 52. There is another closed workbook named "Daily Stats" that I would like to dynamically reference a particular sheet name based on the week (each sheet is named W1, W2, W3, etc) and return a value from a...
  16. M

    To calculate an average.. or total?

    Hi guys... If i have 200 applications to process daily and i have 12-15 people to process them daily, each application takes about 3 hours. How would I put this piece into an excel formula where I want 3 hours to be average to process each app or ok.. how many people would i need in order to...
  17. E

    Macro to substitute cell reference with index and vlookup

    I am updating daily data from one excel shhet to another, i have an index ('sheet7! $A$6:$U$220|3|1). I have to replace daily $A$6 to 7 more rows for each day of month.How can i automate it?
  18. K

    Number Of Occurrence

    <tbody> sunday monday tuesday wednesday thursday friday saturday peter <tbody> 09:30 - 15:00 </tbody> <tbody> 15:00 - 22:45 </tbody> <tbody> 09:30 - 15:00 </tbody> amy <tbody> 09:30 - 19:00 </tbody> <tbody> 13:15 - 22:45 </tbody> 09:30 - 19:00 before...
  19. E

    Dynamic Vlookup between sheets

    I am currently using Vlookup with @Date to update data daily, bbetween heets. The sheet i am trying to get data from has rows .How do i get the data update daily?
  20. G

    Calculating returns of a range using Product + Offset functions

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

Some videos you may like

This Week's Hot Topics

  • Copy entire row if CountA <>0 to another sheet
    [B]I want to copy entire row if CountA <>0 for column J7:AM7 (headers on J6:AM6) and so on till the last used cell is column D and paste the...
  • Select last used Row in Table
    I have created a Table in a Worksheet which is locked to prevent user errors and protect formula. Some of the cells require freetext entries which...
  • excel workbook: do not allow certain file name
    Hello all, Don't think this has ever been asked before, but how do I restrict file save [Before_Save Event] if the name of the file being saved...
  • fixing problem autofilter
    hello i need help about my code when i search by code in textbox it doesn't show anything this is my data [ATTACH type="full"...
  • “Weight”
    Hi, i’ve got a long sheet filled with weights such as kg,g,L & ml. i can build a formula to convert kg into g and liter into ml. How ever, my...
  • How to capitalize everything before a certain character?
    In column A, I have some text: Hello good day.mp3 Hello good day.flac etc. I'd like to capitalize everything before the period. I don't need the...
Top