report

  1. M

    compare for equal numbers and color code

    I just want to compare two different reports total to check if the numbers in bold matches. For report A, the January 1 total number 800 is not correct comparing to report B. Because 200 item are not recorded so I wan to flag that with color or other best ways. The same with May 1 records. I...
  2. S

    Copy and paste multiple ws from wb1 to corresponding ws on wb2

    Hi All,I'm relatively new to VBA and am reintroducing myself to it again now after a short hiatus.My current situation sees me compiling and producing reports based on data we get output from Oracle datatbases. Currently we run an Oracle report that contains multiple worksheets and export them...
  3. P

    Report as report, no edits

    Hi I have a report that works perfect, but I can't find a way to run a report, not as an editor. I want to be able to have a separate person run the report, but they just need to run the report and then print. That's it. Can I create a shortcut to the report and allow them to run it with no...
  4. K

    Excel VBA Compare Data And Create Report

    Hi, I have two sheets with data. Note:- Data in both the sheet is around 90000, I am here showing only sample data for the task. Sheet Name:- "Associate Tracker" Sample Data:- <tbody> Column - A Column - J Column - S Column - Z Associate Name Calling Date Confirmation Location A...
  5. A

    VB Code to save excel file with selected sheets and delete and unhide some other sheets

    Dear Sir I have an excel file and using following VB code for next and back, it is making only active sheet as visible. Sub Do_Next() sc = Sheets.Count sn = ActiveSheet.Name For sh = 1 To sc If Sheets(sh).Name = sn Then ns = sh + 1 If ns > sc Then ns...
  6. M

    Error message while entering new data in report

    Hi all, I have been working on producing a report for some time now, and when i think I finally have it completed it doesn't seem to work. I have saved a template of my report so that I can input new raw data. I have just tried to do this to be confronted with the error message: ":crash:Excel...
  7. M

    SAMEPERIODLAST Year some items are missing if current year is selected

    In my data, 2018 includes items A,B,C only (eg values 10, 20, 30) 2017 contains data for item A, B, C, D (eg values 15,25,35,45) In my Matrix report in PowerBI, I am showing 3 columns:- Item, 2018Values, 2017Values 2017Values is a DAX measure created using SAMEPeriodLastYear. Then I have a...
  8. R

    How to send the automated gmail from excel sheet content

    HI, I have the data in google Excel sheet. How to send auto generated gmail from that excel cell contents Need to send status report on daily basics Eg: To:Distro to be sent Subject: Status report Body Content: All, Please find the status report Table format to be displayed from that...
  9. K

    Formula Help

    I am attempting to use INDEX and MATCH to pull one value 'Material Description' from worksheet 'ZFGI04' based on 2 criteria from columns in worksheet 'SHIP REPORT - Test' (FCID and Product) I continue to get 'N/A' I am able to pull one value by using a based VLOOKUP so I assume it isn't simple...
  10. Nelson78

    VBA, Outlook and Excel: how to inhibite Outlook popup that blocks automatic operations?

    Hello everybody. I have built a hybrid process that engages both Microsoft Excel 2007 and Microsoft Outlook 2007. The process is triggered by an incoming e-mail sent by a specific sender at any hour at minute 15. With VBA instructions set in Outlook, the mail .xls attachment is used to update...
  11. P

    Excel with lots of formulas in in

    Dear All, I have designed a report which contains lots of formulas including assay formula, every time when i save or fresh it takes 10 mins to recalculate so meanwhile i cannot do any other work from excel. Is it any other way we can work around it? At the moment I am using a different server...
  12. P

    Excel data Limit

    Dear All, Just wondering when using excel to create report as it has graphs and Pivot tables etc but it cannot hold too much data. for instance, if we have more than 20k rows the report is getting slower. What other ways we can work around it? Could we use Access to hold the data and use excel...
  13. A

    How to retrive any complete row in the data base which my program does.

    Hi, I have a program that once its done it saves a report in a database on the type of a row from "B:AF" and every time that a new report its done it is saved in the next row, however I have not been able to retrieve any of those lines when deemed necessary, my program its done in VBA and macros...
  14. Trevor3007

    save file based based on date in a2

    hello, i have to send a workbook to a 3rd party when there have been any changes to the workbook. the location is always the same as is part of the the file name (IE :\3rdparty\testAs_At-01-12-2018 22-34-29 must include the date & time of report for reference purpose ( date\time format is...
  15. G

    look up and match

    I'm trying to merge two reports together. One report gives the customer id and no customer name the other contains both. I have one report on sheet 1 the other on sheet 2. I need excel to match the customer id on sheet 1 to the customer id on sheet 2 then copy the customer name on sheet 2 to...
  16. C

    Keeping several instances of the same value

    <tbody> Report ID Date 1234 11/16/2017 1234 9/26/2016 1234 10/11/2017 1234 8/15/2012 etc. etc. </tbody> Hello, See example above I have a large amount of data. Column A (Report ID) is duplicated. Column B (Date) is unique. I want to keep only the 5 latest dates and...
  17. B

    Help With Serial Number Sequential Orders in a Multiple Serial Number doc

    I have a document that I track multiple serial numbers of reports. The trick is that reports initiated by our company have a unique serial number (N00164-18-0001) and reports that are initiated by outside users have a different serial number so the excel spreadsheet has mixed reports going down...
  18. J

    Print multiple dashboards, similiar to multiple tabs of pivot table data

    I know you can take a pivot table and create multiple tabs that change by the filtered range. For example in a pivot table you can have a monthly report but you want to show a monthly report for multiple people. I have a dashboard (an excel page with multiple pivot charts on it), that has...
  19. M

    Calculate from Sub-data set (by Modified file)

    I have a scenario where daily report file copy in my folder by date and this file are connected to my Power BI report (Folder extract) . how I can calculate the difference data from two different files. Example if I want to calculate data from 1st November till 02 November what formula I should use.
  20. G

    Excel find, copy & paste in another sheet macro for multiple documents

    Hey there! I'm designing some HVAC units with dedicated manufacturer software. After the design is finished the software is automatically generating me a final report of the unit's data, among others, in an excel spreadsheet. The thing is many times I have to make like a shorter summary of 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