report design

Hi Everyone, I have a report which I generate on a regular basis and need to convert from a tabular view to a matrix view for readability. I use Excel 2013 I would appreciate if anyone could assist me with some VBA code to accomplish the following: Delete all non-required columns, in this...

Its been a long time since I've worked deeply in Excel. (Im using Excel for Mac 2011, FYI). In this case I'm dealing with exported data in a table. My example is a gross simplification, to get to the basic question. Assuming I have data like below, that is sorted and repeats, I'd like to...

I need to develop a dynamic report that, given an analyst's initials, the report will return all of the projects that analyst is working on. The source data is a staffing database where each project has an index number, and each project is assigned 1 or more analysts by initials (AVB, LHO...

Very stuck here. Need to build a report based off of a template (contains specific headers): <colgroup><col><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> Bill code Product ID First Name Last Name Item No. Date ordered date sold sales Qty Payment...

I often has to do various companies' valuation on excel, which has a specific format for the report output design regardless of which company I am working on. What kind of software is there which can automatically perform the task of generating the report? Any suggestion?

I want to produce a report in Excel based on a table. I've attempted this using a PivotTable but I hit a character limit in PivotTable. What other options can I use to produce a report based on criteria in Excel? I need to be easy to use and not require much work as the ultimate goal is to...

Hi. I am trying to perform a vlookup between two sheets which are likely to have varying names (relating to the month in which the report is run). In attempting to do this I keep on getting errors and I was wondering if there is a simple solution to my problem. My code so far is: Sub MON()...

Hi all, I am currently working on a project to automate a report that is run monthly. In order to do this I have made it dynamic so that it can reference files based on the run date etc and it is working quite well. What has got me a bit stumped is what I think should be a straightforward...

Hi All, I'm quite experienced with Excel, but I'm just diving into Access, and despite having read a lot about it, I have no one to really guide me directly, so forgive the silly question. I have a large database on an Excel worksheet, organized properly in columns. I'm moving it into Access...

I am trying to build a report having multiple queries (total 6) and need help on the following things 1) some of my queries are crosstabs so no of columns vary for these queries, so I not able to see the complete table in the output. Please advice a fix so that I should always see all the...