reporting

  1. M

    Data organization/reporting

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

    Running Navision reports from excel

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

    Creating a formula or vba for collating data and monthly reports

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

    Using multiple Lookup Functions

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

    question on selection criteria

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

    Open Action Item TEmplate

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

    Report issues (Data from different columns)

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

    Using Mutiple inputs from data validation lists to seach sheet and return multiple records on another.

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

    Convert Detail Inventory to Summary

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

    Reporting on data received in same worksheet format, in different workbooks, at regular intervals

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

    Count Uniques and Transpose for Summarization

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

    Generic Question About Reporting

    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)...
  13. F

    Conditional formatting based on the specific TYPE of formula in a cell (e.g. flat-lining versus summing)

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

    Extracting data from pivot tables for Mont day and Year

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

    Reporting off 7 identical workbooks

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

    Mutiple Reporting Sheets

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

    finding substring from the some column and updating another column based upon that

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

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top