reporting

I see this often in the work I do and I do not know how to get around it. I create charts that summarize data by district, by grade, by school, by class. I can make dynamic charts and even get the titles and labels to refresh dynamically. What I am 100% clueless about is how to capture this...

My knowledge of Excel is very limited, and I'm hoping for some guidance as to the best approach I need to tackle the challenge I outline below… I have an Excel file that is full of data from a SharePoint survey that is used to get feedback from various classes. Some of the questions are ranking...

I have an excel application that is relying on data from a Navision report being run every month on a specific time. Today this is done manually, but I would like to do this programatically ie trigger a macro to run this report. Is it at all possible to run Navision reports and retrieve data...

So basically I have a Month's data to collate. The data is sent daily on a workbook (Lets say that the spreadsheet follows the naming convention 2014-03-01, </SPAN>2014-03-02, 2014-03-03 etc) In the workbook, it contains a sheet that has columns and rows that are related. To help visualise...

Respected Excel Gurus I spent nearly 2 hours daily on updating a report from a dump, which I download from a website. I am wonderin if this can be automated using some formulaes or Macro. Please help me out. I can share the 2 spreadsheets which I need to compare. Please advice, if someone can...

Looking for formula to count very specific scenarioI have a report that i need for the government; this is a federal low income medical office that has patients coming in thru the year for visits. each visit has a unique visit number in my excel table. A visit may have only one item charged (a...

Wanted to know if anyone had an OAI template they would like to share. I created one but hate the reporting and the look.

<colgroup><col><col><col><col><col><col><col><col><col><col></colgroup><tbody> A B C D E F G H I 1 I want D1 in A1 I want H1 in B1 F350IR 1 2 I want D2 in A2 I want H2 in B2 F350CP 1 3 I want D3 in A3 I want H3 in B3 F350CP 1 4 I want E4 in A4 I want G4 in B4 F010AC1101...

Hi There, First time posting so I hope its not a silly question! After spending a bit of time looking for some solutions for this i've come up stuck. Basically I want to manipulate the filter options on one sheets using data validation lists on another (which are generated on startup using VBA...

A friend referred me to this site and thought it was worth a try. I have a detailed inventory that is in columns. The two columns I am concerned about are location and product. The sheet has 1600 rows of locations and products. Each row is an individual inventory entry. There are about 80...

To elaborate on the title, I do reporting in which the same format worksheet is emailed to me (as separate excel workbooks) from several users. It is my responsibility to summarize this data from each user into a financial report on a monthly basis. I'm trying to avoid manual data entry and...

Hi All, I'm new to the forum and a novice at Excel, but dropped into a position where I need to come up to speed quickly. I think MrExcel will be part of my "OJT". In the meantime, I need some idea/formulas or code to help with this application. There is a large worksheet which contains...

I have a generic question about what direction to go in. I have a spreadsheet with a thousand rows, each row is a record of sorts with about 6 columns of data. I want to "pull" out "records" (I realize they aren't really records as in a database, but let's call a record one row and 6 columns)...

It seems to be commonly known that the Get.Cell function can be used to format (shade) cells conditionally based on whether they contain a formula or just a value (explained here: http://j-walk.com/ss/excel/usertips/tip045.htm). Can anybody figure out how to take this one step further and...

Good day everyone I am trying to exctract data (profit) from my pivot tables for a daily amount, month to date amount and finally for the year to date amount. This is for various portfolios which then builds up into relationships (I need this info per portfolio and relationship ie daily...

Hello All, I have an excel issue atm with my businesses sale schedule. What happens is there are 7 workbooks used by 7 different teams for logging when sales will be up, used as a kind of calender as such. The workbooks are all formatted identically and are used by multiple people...

Hi all, Hoping someone will be able to help. At present i have 10 sheets within 4 workbooks that then collate the values (countif) in to one sheet. The information that is put in these sheets is entered daily and i need to keep a copy of this data in a seperate tab, which i noramally have to...

Hi I am a bit new to excel functions, so want some help. I am writing down one of of the cell's value ( e.g; position D3) in my excel sheet. I have written the value like you can understand my problem. The following code is present in work log column of the report extracted through...