report

I am in need of a vba module that would allow me to do the following: I currently have a workbook which is Titled "Aspen DPR 10-19". The "10-19" changes based off of current month-year. This Daily Production Report has a tab titled "Monthly Report" and also has a tab for each day of the month...

This would seemingly be simple to do. I have a "Report Date"column with hundreds of rows of dates. I need a custom column that indicates with an "x" or a flag of some type if each row in the Report Date column contains the latest report date within the column itself. Not today's date but the...

Hello, I am looking to expand a formula to include a third column. The current formula is; if(and(n2="",o2="")m2,n2), Basically I am trying to say if column N & O are blank then report the data in column M to the new column. If there is data in either column N or O then report this data instead...

Hello, I run a report which lists all 31 teachers on my staff and the number of lessons they have graded during a particular grading period. The format looks something like this(see below). What I have to do for each teacher is copy and post their grading information into another report. In the...

I have used this VBA code for publishing a PDF report which does work, but what it is doing is showing 2 blank pages below the PDF report been published. Is there anyway to say to the report to export just the range I want leaving just 1 page instead of throwing out good paper!. Private Sub...

Hi - looking for help please I have 2 columns which vlookup values within my tab, they are Team Name last month / Team Name this month. I wish to know if these change and report in Column 3. I have about 7 different team names - for this example - North, South, East, West

I'm trying to create a macro that sets up my reports with a header and spaces above and before the data Essentially what I want to do is add a column in the front of my data, add 6 Rows above my data, turn gridlines off, and open my workbook that contains my header and copy and paste it into...

Hello, I work for an online school and supervise 31 teachers. Twice a month, I run a report which gives me the number of hours each teacher has spent online. I output the report in an excel workbook. The output has 31 tabs for each teacher's information. The tabs are Sheet 1, Sheet 2, etc. I...

Hello, I am struggling with a solution to select data within cells and skip cells that are blank. The following is a description of what I have going: Group 1 - Book Size 6 cells in 1 row Cell shows the size based on selection made. The selection can require up to 3 sizes. Group 2 - Book...

Probably pretty basic question - only starting t play with excel - simple data set - daily nasdaq prices in descending data order; looking to report the number of days it takes to get back to equal or greater price after two consecutive drops - so for 3/8, second drop was 13 points - want to...

I have a monthly report which has a macro that combines data from two sources automatically and updates several pivot tables. This report used to work flawless on ex coworkers computer. He sent me the report and now I cannot make it work. I receive below error: Run-time error '1004' : We...

Hi Folks, I have a training report generated. The report comes out with the following for date <tbody> 2014/12/31 12:00 AM America/New York I only want the date and want to remove the time and location. How do I go about it. Thank you, AFD </tbody>

Hello, Either it’s Monday morning, or I’m overestimating my abilities, or both. I’m trying to figure out a way to generate multiple reports automatically based off a static report and the values in it. We get a report with hundreds of thousands of items on it, and they’re all grouped together...

Hello All~ I created and administer an MS Access DB. Back End sits on a Network Drive, 20+ End Users have the Front End on their respective Desktops. The Application has a Reporting Tool where the user has the option of selecting and running about 20 or so different reports. Currently I keep...

I have the following macros that work: Sub AAA_test_MAR() Set Mail_Object = CreateObject("Outlook.Application") With Mail_Object.CreateItem(o) .Subject = "Monthly Action Report (MAR) " .To = "richard.sabbara@xxx.com" .CC = "" .HTMLBody = MAR_Message_SECURE .Attachments.Add "" .Send End With End...

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

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

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

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

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