1. leopardhawk

    Get External Data (long shot question!)

    This is likely a long shot but I am wondering if it is at all possible for Excel to somehow 'change' the contents of a URL that is being linked to by 'Get External Data' every year on January 1 at 00:01 local time? The following URL is currently in use on a worksheet within my workbook...
  2. G

    VBA Auto filter & amending values help

    Hi All, so basically i have the following table <tbody> A B C D 1 Start Duration Depart Month 2 01/11/2019 61 01/01/2020 January 3 01/12/2019 18 19/12/2019 December 4 19/12/2019 26 14/01/2020 January 5 25/12/2019 5 30/12/2019 December 6 30/11/2019 43 12/01/2020 January 7...
  3. E

    How to make cells equal certain row

    I am looking for a formula to help me in my spreadsheet. I want it to look for the month of January and an ID# with the amounts in that row to copy it into the next 11 months. So January would be column B and ID# in Column E, while the data i want to copy are in J, K, and L. It should display...
  4. D

    Subtotal + sumif?

    Hello! I have created this chart to track company travel for the year. I wanted the chart to be sortable so I could look at the number of trips a team, individual, etc. are taking each month and the costs associated. Where I am getting stuck is the monthly totals formula. I need the monthly...
  5. M

    Unique by month management fee in a pivot table

    Hello everyone, I'm struggling with a problem on a pivot table. I have some data that looks like this <tbody> Date Month Management fee Client Billing amount 01/01/19 January 200 Client 1 500 01/01/19 January 250 Client 2 250 01/02/19 January 200 Client 1 560 01/02/19 January 250...
  6. G

    Dynamic Indirect Reference

    I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet. So far I have this in cell B2: =INDIRECT(B$1&"!O2") Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want...
  7. G

    Dynamic Indirect Reference

    I want to make a dynamic Indirect formula. My goal is to take a cell reference for a sheet, and also a reference of a cell on that sheet. So far I have this in cell B2: =INDIRECT(B$1&"!O2") Cell B1 is January. I want to reference the cell O2 in the January Sheet. This works, however, I want...
  8. E

    How do you sum a row of data that will increase by 1 cell each month?

    I am comparing year-to-date financial statements with Budget and prior year. I want to return the sum of the row that starts with January and increases by 1 each month. I was thinking it was an INDEX function that could start the sum in the first column and then run over the specified number...
  9. M

    Chart Help

    Hello, I have a sample below of my spreadsheet for data that my customer provides. I need to create a graph (preferably line graph) to show the trend of information. We want to be able to switch/filter between the different part numbers so we can see that specific part's history. I have...
  10. A

    Sum between rows

    Hi community, I want to know how can i calculate numbers between specific rows? if user selects January from data validation list i want excel to calculate numbers from January to august, if May than from May to August. btw user can select start and end date. so it can be from january to may...
  11. G

    Power Pivot difficult IF

    I have this setup: ``` date cost 22 march 2018 100 10 january 2018 20 15 march 2019 150 12 january 2019 133 ``` I don't know in advance, which cost, dates or how many rows I'll have. Need a measure that...
  12. P

    Days and months into quarters

    I'm not sure how to explain this but I will give it a good try. I have a table with 10 headings. This is not a pivot table but just an ordinary table with headings and rows. One of the table headings is called DATES. In the DATES column, there are numerous rows with many dates. What I...
  13. F

    Convert text date to start and end date

    I would like to find an easy way to convert something like this (January 18 - February 2, 2019) stored in a single cell to start date and end date in separate cells. Here are a couple of examples: January 18 - February 2, 2019 February 6 - 19, 2019 Thanks
  14. M

    Contents of row deleted based on a zero value

    Please can someone help me with a script - I have a table 11 columns (D to N) and 7 Rows (Rows 7 to 13) - I would like the contents of each row removed if the value in G = 00:00 <tbody> Days Worked Start time Finish Time Time Worked Breaks Yes/No Breaks From Breaks To Total Breaks Total...
  15. P

    Treat Missing Values as 0?

    I've been working for sometime on creating an accurate payroll environment within excel, and I'm finally close, but ran into an issue I could use the expertise of this forum with. The workbook contains sheets for each month (January to December) separated by Quarterly sheets that populate from...
  16. P

    Clarification on use of MONTH and EOMONTH

    Greetings everyone! I have a question which I am sure can be resolved by this forum: Using the formulae shown, I get the results shown to the left thereof: 4 =MONTH(TODAY()) January =TEXT(MONTH(TODAY()),"mmmm") JANUARY =Upper(TEXT(MONTH(TODAY()),"mmmm")) It is unclear to me why the...
  17. M

    Copy cell if start and end dates are in current month

    I want to enter a value from a cell if the start and end date fall within the current month. I've tried some if/and statements and other formulas, but I have been unable to get the solution for the below scenario: Any help is greatly appreciated! <tbody> Start Date End Date Percent January...
  18. L

    Automating advancing from one worksheet to another

    2 workbooks. One called "Cash Flow"; the other called "Budget" In the workbook Cash Flow, there are different months on each worksheet (January, Feb etc). Within Budget, there are columns titled Jan, Feb, etc. I want to pull a specific cell or range of cells within January (Cash Flow) and...
  19. E

    Search and Return References from Multiple Workbooks

    I have multiple workbooks for each month (Named January, February, March, etc) with sheets within the workbooks for each day (010119 for January 1st 2019, 010219 for January 2nd 2019 for example). In each sheet is a list of people who have registered and paid for a sport (see below). Some...
  20. O

    Hide/Unhide Excel File/s.

    Hey all, I have a stock management .xlsm files for each month of the year 2019 These are named as follows in the folder named = Stock Share 01. January, 2019 02. February, 2019 03. March, 2019 04. April, 2019 05. May, 2019 06. June, 2019 07. July, 2019 08. August, 2019 09. September, 2019 10...

Some videos you may like

This Week's Hot Topics