reports

Hi All, I normally would not come here, but sadly am now at the deadline and running this as it is does not work. I am trying to get this to auto run on open or just click the Get Report button once to run all three reports f possible. [Private Sub CboReportName_Change() End Sub Private Sub...

Hi, I currently have the script below to copy a wksheet to a New Workbook. R9096 is 1 of 35 reports and they have their own worksheet. I would like the user to have an option of selecting the reports they want to extract. Is this possible to do within a macro? Maybe a drop menu showing the...

I have a script that is working but I need to streamline it and make it more user friendly. My code opens up three spreadsheets and copies them to tabs 2,3 and 4 in the original spreadsheet. It renames the tabs and does a bunch of formatting and a few Vlookups. The original code to open up the...

Hi, I have numerous reports that are generated each day and always have same table like structure. Each row in those reports shows values for unique ID's (like temp1, temp2, temp3, ...). What I need to have as result is table of changes per each ID, field that changed, old value (from most...

So I am an analyst and I automate over 150 reports to people all over my company. I suspect that many people do not use the reports that I send and I would like to know which reports are not used so that I can turn them off. Basically I am looking for VBA that will notify me, or maybe update a...

I pull several reports once a week and created a file with a ton of formulas to pull data from the reports. The reports must be open in order to extract the data. The report names are always the same as I use a macro to open the reports and then close them once the values have been...

Hi, I am creating a Make Query to retrieve specific data and categorize a date into Month, Quarter, Year to be used for other reports. I am using a form to identify the year and ThruMonth of the data needed. Tables in Make Query: Summary Master, Direct Time Master Fields In Make Query...

Hi, I have a program that creates a Data Base every time it is used, for me I think it was easy to do it, but now I do not know how to retrieva anyone of those reports created back to a form from which was sent (it can be a copy of the form in a different sheet), all I want is to have the...

Hi all, i´m trying to create automatically, based in a list of client codes, new sheets (and the name of each one of them are the client codes) and then inside of them create a report from sql data base. for the first part i have the code to create new sheets with the name based in a list of...

I have a document that I track multiple serial numbers of reports. The trick is that reports initiated by our company have a unique serial number (N00164-18-0001) and reports that are initiated by outside users have a different serial number so the excel spreadsheet has mixed reports going down...

Before I get into the issue I am experiencing, I think it should be said that my expertise in this matter is extremely lacking, so pretend that we're on /r/explainitlikeim5. I'll also note that I have tried to do some extensive research across multiple sites and forums, but nothing that really...

Hello all! Sometime last week I suddenly developed a problem that I've never seen before. I was attempting to open a file from a website - which I've done for months with no problem. But that time, I got a box saying: "Excel cannot access 'Daily Reports". The document may be read-only or...

Hello, and thank you for reading this post. I'm creating an org chart outline to account for employees during an emergency. The goal is to associate each supervisor (Reports To) with subordinate staff(Name) that reports directly to that supervisor. From this table check lists will be created to...

I have tabs in Excel (both hidden and unhidden) I'm trying to export each tab in the workbook to a separate, stand alone workbook. Ideally, I'd have a reports function in the ribbon (like I used to do with pre ribbon excel), that a user could click on and run this and other functions and...

I have a large workbook that contains many reports used regularly. I always use named ranges throughout the workbook. Over the years I suspect there are many named ranges that are no longer used by any of the current reports. Is there any way of seeing (macro or otherwise) whether a named range...

Hi Everyone: I'm new to this forum and I searched my cases and need your help. I have several workbooks which are reports of different classification of processes of products.(same product but different Serial Numbers). Now I need to make a database for each Serial No. which includes the...

Hi everyone, I have a folder for my students, which has a folder for each individual student inside it containing their monthly progress. I wanted to know if there was a way for me to enter data in one "master" spreadsheet and it would auto-populate the individual reports. opening and manually...

Hello, I have a workbook that I use for "Performance" tracking of our machines. I currently have multiple worksheets in this workbook. I have tab for graphs with 15 different graphs on each tab. That is 120 graphs, these graphs update automatically when data is entered using "Name Manger" with...

I have a shared folder that contains a large spreadsheet with fields necessary for reports. I produce these reports via filter and mail merge to a word document. I'm training a new person and want them and myself to be the only ones able to update the spreadsheet. The problem is, others need to...

Hi All, Can anybody help me with a formula to measure employee performance. Our department job is to prepare reports , so some reports have frequency , it means the submission of reports are daily/weekly in nature. While others are huge data based which is time consuming. Few are critical in...