report

  1. M

    Suggestions for Complex Report Layout

    I was asked to keep track of a project and need to report on its progress every month. The raw data will be names, office locations, current model assignments, new model assignments, and the date the new model was reassigned. Initially, I was going to create monthly tables based on this data...
  2. T

    VBA generates word docs, request to amend code to include description of deadlines/tasks due

    My VBA macro runs reports from Excel to generate a Word doc with upcoming deadlines/due dates. However, I can't figure out how to include a description of the upcoming deadlines/due dates when I run macros. Here are the columns that I need help with: COLUMN A = MATTER NAME COLUMN K = TASK...
  3. M

    Slow/ lag with large files

    Has anyone experienced the excel document lagging / slowing down once the doc gets over a certain size? We write reports using excel and the last few photos we upload to it takes so long! Looking for a fix if anyone can help.
  4. S

    Macro to Export report !!

    Hi Team, I am in need of your help in guiding me the excel VB macro for the below mentioned requirement inorder to complete my automation project in my organization. Please help me in guiding. Thanks in Advance. Requirement: 1) Step 1 - Need to open a Web page URL. 2) Step 2 - Web page...
  5. C

    How can I automatically generate a report (repetitive text) based on a couple cell contents, for a very repetitive report?

    I have attached sample screenshots as a reference. For example (x, b, c, d and e are figures in a cell) Entry 1 - X entry has a percentage of B%, with a total of C and D used, *insert E text (reasoning). This is the structure of the whole report pretty much. Additional notes: The...
  6. P

    Quality report help

    Hi all, I have previously made a report with a macro based on a single sheet copied from another workbook and created a random sample of cases managers to review. It has worked great but due to a shift in management there has been a slight change in how this needs to be done- instead of daily...
  7. J

    Applying discount to original cell while retaining formula

    Hi everyone! I am new to VBA and I would like to apply a discount (e.g. 10%) to a cell value in my quotation sheet while retaining (and show) the formula in the same cell at the same time. Is anyone able to help on this formula? For example: Say cell B3 contains $1,000, if I were to apply a...
  8. S

    VBA Creating an report on another tab

    Hi, i ve got summary in the first image and want to transfer it as Value to another tab to keep records on. 1.First thing i dont know how to transfer values instead of copy cells. 2. Don`t know how to put "current date and time". Date and time should reflect time once button were pressed. 3. As...
  9. J

    HELP.. Combined table by adding each date to fixed header line on seperate sheet by using VBA

    Hello Brave Excel Lovers and Helpers I have an Excel File in which there are three Nos. Sheets and a Userform (File is attached) RawDatabase ReportTemplate MyReport I can only generate report for single selected row from Userform Listbox1 (see MyReport) But this is not what I need. I then...
  10. S

    searching for data in columns with the same argument

    Hello. I am trying to copy/paste data from 2 columns (containing several rows with required data) and transfer the columns to another worksheet in the workbook over a time span of either 23-24-or 25 hrs The problem is that I need to use an argument what is not consistent and I have a macro in...
  11. M

    Use a Macro to format report to reduce number of lines used

    Hi, I have quite a large report where a lot of the data is represented in rows and duplicated. The report has 17 columns and ~5100 rows. Within these columns only a couple has data that is different to the row above. I want to be able to reduce the number of rows used in the report and where...
  12. F

    Combining Invoices to Vendor on one Report

    I am sure that this has been asked, but I cannot come up with the right search terms to find it, I'm sorry. I have a simple database with two tables (a "vendor" table, and an "invoice" table). Any vendor can have one, or any number of invoices. I want to make a report showing all invoices...
  13. B

    Need a formula - filter so 2 columns totalling more than or close to another column only show

    Column I in my excel file shows unpaid invoices. Column K shows uninvoiced items. Column P shows the customer's balance on account . Most of the time, P should be greater than I+K. However we want to be able to easily spot the customer files that are close to or have exceeded the customer's...
  14. N

    Countifs - Multiple Conditions (HR Dashboard)

    Dear Team, I am currently working on an HR Dashboard and I want to be able to use a formula to do 2 things: A. report the overall current number of employees who are still onboard. This will mean as long as I keep updating the datasheet this number should automatically be updating...
  15. T

    Columns in Report need to be only 3/4 page

    I have a report that has 2 columns in the Detail section. I would like for the columns to only be 3/4 down the page, so my report footer will show at the bottom of the page. Currently, the columns extend down to the bottom of the page, continue to the right side until all the data is displayed...
  16. P

    Lookup and Find

    I feel like I should know this but am drawing a blank. I have a table of 3 columns and 10 rows and two values to locate. In column 1, I want to find the number 29850 and I want to locate in column 2 the term "report" and return the value in column 10. So an idea is as below: <tbody> Sequence...
  17. H

    YTD Data from Monthly Input

    I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...
  18. H

    TYD Data from Monthly Data Input

    I'm working on a quarterly Board report which i'm trying to set up so that you don't have to amend any of the data when you open it. Currently there is a month-by-month break down of all the figures in one worksheet, then the report itself is on a different worksheet. Is there a formula that...
  19. R

    Need some guidance on how to approach this

    Hi Everyone, I need a little help with something. I have a report that I get twice a day, on emails that were sent to some of our generic inboxes. Each email has it's own row. Column C of this report contains a list of all the email addresses the email was sent to. There can be one or a...
  20. F

    Deleting empty rows code doesn't respond

    Ok. Desperation is setting in!!! I have two worksheets, "Clash Check" and "Clash Report". The sheet "Clash Check" gathers data which ends up as a list of names etc across 3 columns with lots of blank rows in it. I have a code which can run through the list and take the blank rows out based on...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top