report

  1. B

    parsing lists

    Hi, It has been some time since my being into developing vba code in Excel. I am [beyond] rusty in my skillset. I receive a report generated in Excel and need it parsed correctly, and the report appended each time I update it. (Until I figure out--LEARN--syntax, I would like the append...
  2. willow1985

    #VALUE error with Sumifs formula

    Hello, I do not know what is wrong with the below formula - receiving a #Value error: =SUMIFS('WO Report'!F2:F1000000, $B$14,'WO Report'!V2:V1000000,$B$12,'WO Report'!S2:S1000000) Let me break the information down for you, I have 2 tabs: Tables and WO Report. The formula is in the tab...
  3. S

    textjoin query

    i have been requested to make a simple absence viewer iin our office that is feeding from a report from our HR system and appending that report over the top of the previous one. Essentially, the report comes down like this : Name, Unique ID, Office Location, Dept and then absent date. At...
  4. O

    Removing Lines that change location from downloaded Reports

    I would like to find out if it is possible to remove lines from reports I download daily. The lines change position, say lines 20-22 could be on one report and the next day the same report shows the lines I want to delete on lines 30-32. The last line always contains specific words "data can...
  5. D

    filter down a pivot?

    even if I use a report filter..I noticed that when I try to filter further via the pivot items ...I still see all the data even though I filtered vis the report filter ....is there way to make the pivot filter out the data accordingly ? eg I use report to filter for today's date but when I...
  6. J

    VBA Copying data from one workbook to another workbook, specific ranges & tabs

    Hi need some help please I have the following VBA for a report which copy's over Specific data from one workbook to another workbook in therange & tab I need it to, however I would like it to automatically know thefile path & report I want the data copied from, this code currently askswhich...
  7. T

    Creating Pivot from a report

    Hey guys I am having a roadblock in creating a pivot to analyse the data. I have a report in the "Details" tab and calculations are done within the tab. For example, I have a total cost for a line item by month (from column U to column CZ) and the cost is then allocated to different...
  8. N

    How to remove every other row in a spreadsheet from report quickly

    Can anyone provide me with a quick way to remove every other row in a spreadsheet report?
  9. M

    RLS Sharepoint embedded report

    Hi Guys, I've got a question about RLS in PowerBI. My problem: When i give someone access to my reports without a role, they see all data. Is it possible to set my dataset to like a RLS only? So when someone without a specific role opens the report, they see nothing. I ask this because of...
  10. D

    VBA Macro link to daily report

    Dear Forum, I need a little wisdom here please. I have managed to create a working Marco that filters, formats, deletes etc. a worksheet report. The Marco name is: Daily_Report_Filter Each day we need to pull a report, the report data and structure is always the same but the file name...
  11. J

    Separate Dates With Blank, Unformatted Row

    I have attached links to two spreadsheets: "Before" and "After." Here is what I am trying to do to "Before" so it ends up looking like "After." Separate dates as follows: if today is 9/16/19, I need the spreadsheet to only show 9/16, 9/17, and 9/18, removing all other rows of data and...
  12. D

    How do you query in excel? What would be the best program to complete this in?

    I have spreadsheets called allocation sheets. These are yearly documents and each row is a service instance. The row headings are: Date Purchase order # Req # Child Name Service Requesting Organisation Caseworker Name Price ex. GST GST Price inc. GST Allocated to Date report...
  13. A

    Reverse VLOOKUP? INDEX - MATCH?

    Hello, I'm looking for a formula that would accomplish the following. If the date in worksheet (DRP Payable "J") is between the start (A3)and end date (D3) of the pay period listed in (Pay Period Report), I would like to list the results of J,G and H from DRP Payable to be listed in Pay Period...
  14. A

    how to combine multiple columns of a table and get a report in pivottable?

    Hello Is there any other way than power query to combine multiple columns of a table and get a report in pivottable?...
  15. M

    VBA to pickup latest sharepoint file

    The following code will open the specific file I need: Sub OpenRoutingOpen12() Application.DisplayAlerts = False Application.ScreenUpdating = False Application.AskToUpdateLinks = False txtdate = Format(Now, "m_d_yyyy") & "%208am" Workbooks.Open...
  16. N

    Email multiple reports to specific addresses

    Hello, I need to email out a list of individual reports to specific addresses. The reports are located in C:reports and all have the same naming convention. Below is an eg of the spreadsheet and the data. Paste starts from A1 <tbody> AssetName Driver email Manager email1 Manager email2...
  17. N

    VBA to split a report to 5 worksheets different criteria with loops

    Hi All, New to VBA/Macros trying to learn whilst piecing together examples i've seen, think what i've got works but is long winded and needs a different macro for each split and will require tweaking if/as the report changes. Im trying to break out a report in 1 worksheet into 5 different...
  18. U

    Convert Report number to Date and Time

    I am trying to convert this report number to a date and time, is there a single formula that can achieve this or do I need extract the numbers using left/right formula? W3_20190903_230338 = Sept.3,2019, 11:03:38 pm
  19. G

    Merge data from one worksheet to another

    I'm trying to merge data from a weekly report into a master sheet that runs calculations. The weekly report is always formatted the same, and the calculation sheet will be as well. What's the easiest way to import data from the report to the master? I.E. F33 on the report will always need to...
  20. E

    Browser Page Refresh: Reflect new data after scheduled refresh

    Hi, Does any one knows if there is a way to refresh the Chrome view of a power bi report in the service after the schedule refresh? (without using Chrome add ins) [ i have a report that is presented constantly on a tv and refreshes once a hour or so, the view does not update after the...

Some videos you may like

This Week's Hot Topics

  • populate from drop list with multiple tables
    Hi All, i have a drop list that displays data, what i want is when i select one of those from the list to populate text from different tables on...
  • Find list of words from sheet2 in sheet1 before a comma and extract text vba
    Hi Friends, Trying to find the solution on my task. But did not find suitable one to the need. Here is my query and sample file with details...
  • Dynamic Formula entry - VBA code sought
    Hello, really hope one of you experts can help with this - i've spent hours on this and getting no-where. .I have a set of data (more rows than...
  • Listbox Header
    Have a named range called "AccidentsHeader" Within my code I have: [CODE]Private Sub CommandButton1_Click() ListBox1.RowSource =...
  • Complex Heat Map using conditional formatting
    Good day excel world. I have a concern. Below link have a list of countries that carries each country unique data. [URL...
  • Conditional formatting
    Hi good morning, hope you can help me please, I have cells P4:P54 and if this cell is equal to 1 then i want row O to say "Fully Utilised" and to...
Top