report builder

Hello, first post. Will appreciate any help - even just a pointer to the correct place to look. I'm struggling to word this requirement but here goes: I have a data table in excel (a proper table). Each record contains a student and several other fields of use. It also details the teacher, and...

Hi All, I have a data table where we have Roles (varies) that people have been contacted for. Columns B:G contains the dates of the activity performed (e.g. when were they sourced, when they shared their interest so on and so forth). I need a dynamic weekly report which gives us count of all...

Fairly noob here. I have a list of Person names on another sheet. I want to automate building a separate monthly trend chart for each person and paste them all onto a new sheet, one right after the other. Will this code work? Worksheets("Report").Range("A4").Value = Agent Call...

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

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

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

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

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

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

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!

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

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

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

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

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

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

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

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

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