report

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...

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...

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.

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...

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...