reports

I have two tables, one has the [Sales data] (Customer and Sales Dollars), the other table has [Order Details] (Product line and SKU). Both are related with a 1:1 key. I want a pivot report to show Customer (from sales) in the column, SKU (from orders) in the next column, and Product line...

Hey Guys, I was wondering if there is a way to accomplish this in VBA? I have an excel document that I use mail merge to create a bunch of different reports. After completing the mail merge I want to be able to save each individual file as a pdf. Currently I am using this to split the pages...

I just upgraded to Windows 8 and my accounts receivable software is no longer supported by the operating system. I was hoping to create a workbook in Excel that can achieve the same results as my software. I have a list of clients and I.D.'s matched to them that I have already set up into the...

Hello there, I am new at VBA and Access and I was making a DB that needs to print a determined number of different labels depending on the options given. When I use macros it is quite easy to choose the labels and it all works but I found out code that works fairly well and it becomes faster...

I have a report based on a Query. The Query, when run, displays the Project Names and Task Names. When creating the report (report wizard), Access reverts all the Project and Task Names back to thier primary keys. The report is broken down as such: Project Task Activity Sum...

I have a Table with 10 columns and 21 Rows. Last column has %allocation that is 'I' Cell of each Row divided by 8.75 and multiplied by 100. Example Source table and Target table in attached file. Target: Need a Excel macro to Generate a new Worksheet with 'Task' wise Report as mentioned below...

Hello All Excelions! Here my problem: (cause I'm a TOTAL newbie/excel idiot) I have a client list/table that gets new data each day. I need to create separate lists/tables on new sheets from the main data sheet (ALL) base on certain conditions/criteria... The All sheet has different...

I have 40+ reports that I generate weekly for different clients. I have the workbook set up so that each report is in a new sheet/tab and have a macro that runs through and saves each report as a PDF using the file name I desigate in a cell within the sheet. My clients are now wanting the...

After watching many youtube videos, I am still stuck on trying to fit the right function/formula into what I am trying to accomplish. I have many worksheets all linked together and giving me great reports, but the last report I need I can not seem to capture the data I need. I need a report...

how do I use VLOOKUP to move whole columns of data from one report to the other.

Hi folks. I'm investigating the possibilities of extending a spreadsheet I've been working on to manage data in a school. I've already completed the first stage of the process, creating the management system on a spreadsheet, but ideally I'd like to generate weekly reports of recent data from...

I am often getting this Two name of the Excel funtion books from my friends who are talking regarding the reports generation but i could not see that as it was confidential. Any possibilities from your side??

I have a database with many tables and a manager who likes a weekly report update. My table fields are FT/PT PGCE/CERT and I need to include SITE and STATUS (Status' are ACCEPTED/WITHDRAWN/IN PROCESS) i need a report to show all the fields on one page - not as a list of students and I don't...

I am stuck with what to do, and may have to create a few tables to fix the problem, but I thought that before I did that I would consult with the experts! I am generating a report based on a query of a table that has three fields that can contain multiple values. For testing purposes, I have 4...

I have 4 little daily report and 1 master report; I am trying to link them together so that when someone enters a total on the little report it will change the master report, any advice… <?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" /><o:p> </o:p> thx

While running a report (one which has several groups, and several subreports) I get one parameter I expect ("Enter ID number you wish to report on") as well as a parameter I did not expect to see. It just says "Catalogue". Which is the name of a table which the main report is based on and the...

I am preparing a report for occupancy based on room rate classification. We have three rate classifications, depending on long-term, short-term, or Penthouse: Tenant, Transient, or Penthouse. The first two may occupy the type of room, but the third is only in the condos. The "Building...