report

  1. S

    vba to auto fill day of week and date in left footer of each sheet when you go to print out

    Hello. I am looking for some vba code to add the day of the week to the below wording and to work when printing for all sheets in a workbook. Currently it says in the footer: Report Dated: 08/30/2019 Format for wording is: Bahnschrift SemiBold Font, SemiBold Font style and 9 size. Want it...
  2. S

    Copy/Paste Macros Slowed Way Down Starting in June 2019

    Through the years, Excel macros have run slower and workarounds to speed them up have appeared on this site (screenupdating, visible, calculation properties) but I have seen nothing to date on this recent (for me) situation. Starting June of 2019 the macros I run doing copy/pastes slowed way...
  3. J

    A tuff one, Copy and paste if criteria is partial met

    Hi Is itpossible to create a code that can copy rows from a data sheet and paste to areport sheet if there is a partial match? Data is a staff record with data in 11 columns and about 450 rows. In column 1 (A) are names with first- middle- and last name in the same cell. For example, if you...
  4. A

    Apple Mac File Path

    Hi all, I'm working on a spreadsheet for a friend who uses a Mac. I have zero experience on a Mac so I'm hoping I could get some help please. The below code works on my PC but it fails on his Mac: Sub ImportRawReport() Application.ScreenUpdating = False Sheets("RawReport").Select...
  5. R

    VBA to select Row based on Cell Value and Filter sheet

    Hello again MrExcel, I need to filter reports where the filter Row is in a different row on each report. The code below has the filter Row in Row 7, another report has it in Row 10, and another has it in Row 5, etc, etc.. Is there a way to have the macro search for "Call Type", select the row...
  6. S

    VBA copy & paste code check

    Hi, i'm trying to write some VBA code to open several workbooks, copy a column, and past into the book I run the macro from. I need the data I copy over to all go into the same column. Here is my code: Sub MeToo_Paste() 'Assign Report Book Dim x As Workbook 'Assign Source Books Dim y As Workbook...
  7. P

    Report issue suppressing page Header and Footer on report footer

    My report's final item is a chart image which is in the report footer. I don't want the page header and footer displayed here. I thought it would be easy - I set the report properties Page Header and Page Footer to "Not with Rpt Ftr". But although that works for printing (i.e. exporting to PDF)...
  8. Z

    How can I create a form control within a macro?

    I made an excel add-in that creates a report from a site automatically. I would like to add a form control to that report linked to another sub in the add-in file automatically. This is so the user can run another report just by entering a value in a specific cell and pressing the form...
  9. E

    send pre-defined email to email list from excel

    Dear all I have currently a macro which I run to generate a report. Once finished the report needs to be sent to several people. The email list of people, subject of the email and body text are saved under the tab "email" as you can see below I want to also only send the tab named...
  10. M

    VBA Copy sheets from one Variable sheet to another

    Hello, I'm trying to copy two worksheets from one workbook to another. This seems to be fairly straight forward, but for some reason, I can't seem to accomplish this with a variable sheet name. I have set one of the workbooks to "Report" and the other "Edit" The "Edit" workbook is currently...
  11. C

    Sales Pacing Forecasting - Weekly report changing figures

    Good Morning, I have a report that comes out of our system weekly. It shows all past business actual revenues e.g anything before today and all future(today to the end of time!) forecasted revenues. We are trying to look at or pull the data so that it does the below. *** Put a date in a cell...
  12. P

    A PivotTable Report cannot overlap another PivotTable Report

    Hi All, I am receiving this message "A PivotTable Report cannot overlap another PivotTable Report", in a workbook of about 15 sheets or so. Usually when I have this error, I can identify where it is coming from by looking for overlapping pivot tables. I seem to have maybe identified the sheet...
  13. Z

    Percent of Total - How to build report

    Hi, I have some task - that looks like very easy, but... I cannot find solution :( I have data like this: <tbody> Column1 Column2 A No A Yes A No B No B Yes C Yes C Yes C No </tbody> And want to get report showing the percent of Yes/Total: <tbody> Column1 Yes/Total A...
  14. L

    PivotTable refresh date history / flag new data since last refresh

    Hi I'm trying to flag data that appears since the last time the report was refreshed. For example, if the sale date was 28/07/19, flag this row as "new since last refresh", if the record wasn't present on the last report version. Any ideas please, guys? I've Googled about and looked through...
  15. T

    Format field as a phone number in report

    I have a common access report. One of my text boxes is ="If you have questions about this report, please contact: " & [CompRptCntctFirstNm] & " " & [CompRptCntctLastNm] & " at " & [CompRptCntctPhone] When I run it I get something like the following: If you have questions about this report...
  16. A

    VBA calculation takes too long

    Hey Dear community, I am using VBA+ formulas to analyz sales data ( about 1000,000rows ) it takes 7-8 minutes for calculation, i wanna know if there any other way to make it faster? because i need to calculate this report daily. I use following VBA for 80-90 different ranges on that report...
  17. J

    Create a new sheet in excel

    Hi All, I have a two sheets a master sheet and a weekly report sheet. I need to firstly recreate the previous weeks weekly report sheet based on the cell value i put on the master sheet For example Column A ( Master Sheet ) is the week numbers A2=WK27,A3=WK28 Etc when i add WK29 into cell...
  18. S

    Help with pulling data from an excel file in a folder to automatically update the date from inside that file to my work book

    Hi, I have a workbook with a daily report Sheet. I (move and copy) it each night and rename the file to the "Daily Report- mm/dd/yyyy, date of that work day. That file gets stored in a job number folder on the desktop and in that folder is another folder named Daily Reports. I have another sheet...
  19. T

    How would you set this up - building from scratch

    I'm building a Macro for a project. It's going really well but quite a learning curve. The project has about 20 outputs. The first steps for all 20 are the same, but at a certain point the process diverges for each, mainly in terms of producing a Pivot Table with different fields (but all from...
  20. M

    Did customer in one list buy an item in another list?

    Customer produces and sells widgets (CW). We sell a report about the performance of the widgets. I have a spreadsheet of customers with one report sale per row - Customer Name in Column A, Product Name in Column B, other data (irrelevant to my question) in other columns. Customer may have...

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