report builder

  1. P

    Help/ Ideas needed - Excel/VBA Based Reporting tool

    Hi All, I'm looking for some inspiration and ideas regarding an excel based reporting tool for field workers. I currently envisage a worksheet formatted to look like a form, this will have elements such as cells using drop down and content validation, tables to record values etc. The format of...
  2. D

    Sub that runs through worksheets and reports an input value on another worksheet

    I'm currently trying to create a sub that does the following: 1 - asks for an input (a string/name in this case) 2- loops through worksheets to see if their name is there, and if it is, reports their name and the "amount sold" in the column next to their name onto another worksheet. what i...
  3. S

    Report generation based on value in two cells

    Dear All, I have file with 3 sheets 1. TE Deliverables 2. Job Cards 3. Processes In all the sheets, data is filled against activity VS date Vs employee the activity lists is in rows whereas the dates are in column and under each date there are 3 staff. so basically same date is repeated in 3...
  4. S

    Generating a report - issues, confusion, road block .....

    Ok, so just to give a quick disclaimer, I am fairly new to using Access. I took a college class on it like back in either 2011 or 2013. I really haven't had to use since then and so I apologize in advance for any simple/silly mistakes, follow-up questions, etc. Although I may be new to this...
  5. M

    Short and Smart vba code for a report generating.

    I need your kind help in the following code for preparing a treatment history reports of patients that how can I short and smart it? or any more suggestions form you in this matter. Private Sub ComboBox1_Enter() '**** It takes the names of all patients from Sheet2 where from '****we can...
  6. B

    VBA Help to create excel workbook with template

    Hi folks, I've got a data table with 20-25 columns worth of data (sheet1), using an index number I use Index and Match to pull all of the relevant data from the table onto a formatted worksheet into the "fields" on the template (sheet2). What I would like, is to be able to have a third...
  7. J

    subtotals

    I have a table with customers, invoice amount, and amount collected. Is there a way to sort by customer name and figure out their balance? Can I set that up as a recurring report so that I can quickly see which customers have an outstanding balance? Thanks!
  8. L

    School needs help with report

    Hello, we are a small mental health facility that began using a new EHR system which has been somewhat disastrous. The problem we are having is looking at a report. We can export to excel (link) https://1drv.ms/x/s!AoxXnX4Qzvyeem4CbgIivHkLvHA but there is a lot of data and we only need table and...
  9. TitusandNero

    VBA Userform: Need help completing coding to run a report please.

    Hello (operating on Excel 2007) Hope someone can help a newbie here. I've set up a userform(named Reports) to run a report from an Excel database(named Data) which will then populate an excel spreadsheet(named By Representative) in the same workbook. On the userform(Reports) I have 3 search...
  10. S

    How to generate report on rows from multiple worksheets where column has particular text

    HELP!! I've been struggling for a few days with this issue now and although i've come across a few different examples which i think sound similar to what i need my to worksheet to do, given that i'm pretty much a complete novice at VBA, i cant work out how to adapt the examples i've found to...
  11. C

    multiple data sheets into one sheet - data sheets will have different amounts of info

    Hi all, New here so first of all hello to everyone. I have popped in here to see common problems and answers before so thank for you help there. But, now I have a good one for you all and I hope you can help me. I have a report that I want to run every 3 months for my staff. I have a template...
  12. J

    Ambitious Student Report Creator Project

    Hi everyone, This is my first post so please be nice and thanks in advance for anyone who takes the time to reply. I am using Excel 2016 and am a little bit out of my comfort zone now so am looking for a general steer. I work in a school with a rather antiquated and labour intensive way of...
  13. L

    Print report based on the checkbox selection

    Hi, I'm having difficulties with building an printing option for specific goods selected on the list. I have a form witch contains an subform. On the main form user is able to select supplier and based on the supplier can choose article that he's interested in. On the subform user get the list...
  14. P

    Time series, medium size numeric data (lite to none RDBMS/relationships) visualization and reporting

    I work with generators and 100MB time series CSV data files are generated every day (250K rows), as shown here: https://www.dropbox.com/sh/d57qcdkx6087u72/AACv4MqXDmpVrxN-Qci0Pjida?dl=0 I am interested in zooming in/out of chart that has 4 variables plotted against time. Then consolidating...
  15. A

    find values under 20% across worksheets and list said worksheets

    I would like my Macro to go into all works sheets and look at the last row of I matching todays date and if this value is under 20% then to paste the name of that worksheet back into the master worksheet allowing a quick overview of under performing data. I think I have got the selection...
  16. B

    Report builder refreshing error - excel auto protection workbook issue

    Hello, It seems my Adobe Report Builder v.5.0.4 doesn't refresh any reports anymore in Excel v.14. I see 2 errors, I think one due to the other: 1) If I hit the refresh all button in the Add-in tab or in the Request Manager all my tabs in the workbook jump to protected view. 2) If I refresh a...

Some videos you may like

This Week's Hot Topics

  • Turn fraction around
    Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
  • TIme Clock record reformatting to ???
    Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
  • TextBox Match
    hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
  • Using Large function based on Multiple Criteria
    Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
  • Can you check my code please
    Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
  • Combining 2 pivot tables into 1 chart
    Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...
Top