reports

  1. V

    formula to measure employee performance

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

    Macro to pull the 4 most recent dates from a list of dates

    Hi Everyone, We Get reports every so often but there is no set date or day. I have this data in a sheet "Data G" and add the date it arrives in Column N I'm creation a report that show the last 4 reports so I need to get the dates of these, So down Column N is a list of Dates many are the...
  3. R

    Export 3 Access Reports to 1 Excel Doc - Cmd Button

    So currently, I have 3 command buttons with the following code; Private Sub Command368_Click() DoCmd.OutputTo acOutputReport, "Visit Report By PMCC", acFormatXLS, "c:\Exports\Visit Report by PMCC.xls", True End Sub Is it possible to export 3 reports into 1 excel doc and have each report in a...
  4. J

    Combine all sheets into one except for one

    Hello: I have the below statement that combines all worksheets into one. Essentially, it combines all into one called "Combined Reports". However, I would like to rewrite the sub so that a sheet called "emailList" is not combined into the report. Any help will be appreciated. Sub...
  5. M

    Salesman performance anlysis.

    Hello Everyone, I recently opened up a retail store. Transactions are completed in a POS system that allows me to download reports. They are however not sufficient for me to do the analysis I need - hence I need excel help please! I am trying to create a dashboard to measure individual and...
  6. C

    Macro to Format

    So at my job before I send reports they have to be formatted a certain way. And it would be awesome if I had a Macros that when through all the tabs and formatted them for me so I don't have to do it on each tab. First the data has to be scrolled all the way to the top and the cursor needs to...
  7. G

    Random SQL Script Updating

    Hello all, i'm really not sure what Title i should guive this post... I have an Excel spreadsheet on which i display SQL query results. When the user presses a button, a form appears & different reports are available to him. For 2 of these reports, i'm able to either choose one or the other &...
  8. L

    Combining two excel reports into one spreadsheet

    I have two reports that I have exported from our system into excel. One report contains data that I need to include in the other. I was told to use the Index function however I can not get it to work. Is there anyone that can help me?
  9. T

    Lookin up reports and copping them acroos

    Hi Guys, Just wondered if anyone could point me in the right direction, I have a long list of monthly reports on a sheet called “MONTHLY REPORTS DATA” the most recent report at the top and then the second to most recent and so on, all the reports are 15 rows high and 8 columns wide, I have...
  10. J

    How to change the directory when using saveas dialog

    Hi folks, I can't quite figure this out, but I think (hope) I'm close. I'm trying to force the Save As dialog box to change to the "T:\SUPERVISORS REPORTS" directory after the rest of the code is finished. I'm just not quite sure where (or if that's even the correct way to do it) to put the...
  11. M

    Incrementing worksheet number in a formula ?

    I have data in workbooks and on worksheets and I would like to show some of it on another workbook. I understand how to get the values from the cell I want but is there a way to copy and paste the formula so that it changes incrementally. I have a workbook called Trends, with numbered...
  12. G

    Printing Reports that are mentioned in table

    Is it possible to add in my table with customers to add field where I can put report names or report ID's, and print these reports with VBA. I then want to create a loop to export all report to pdf files.
  13. E

    Coppy and shortening and string

    Hello, I am fairly new with VBA and code has never been my strongpoint. I do research in a Nueroimmune Lab and I am working on a series of macros for exporting/manipulating large data sets from out flow cytometry individual panel reports (.xls) into one master worksheet. I have managed to...
  14. E

    Time Format

    Hi all, I've had some brilliant help from here recently - thank you :) But have now encountered another problem. At work we are sent reports from automated from systems (not owned by us) We can manipulate these reports pretty well but there is one aspect I cant solve myself. One column of...
  15. D

    Increment sheet reference formula in new tabs?

    Hi everyone, I'm in a crunch which I have to manually create about 40 one-page reports from a table of values. The reports are for the people I support, and I plan to make each report on a separate tab in the excel worksheet with the table of values. The names of the report recipients are...
  16. L

    Creating subfolders in a number of existing folders

    Hi all I am quite new to VBA and have found a number of the posts on this board really helpful! I have come across a query I haven't been able to find an answer for though - I have 60 folders, each assigned to a different client, and within each of these is the same set of subfolders. I am...
  17. C

    Date as text - odd format

    Hi I am trying to amalgamate data from two different systems into one spread sheet. I am having an issue with one as it reports the date in a number format i.e 20th December 2017 shows as 20171210. I have tried to change the format using the exel functions but it just returns a line of...
  18. C

    Best technique for popup notes

    Hi Newbe here well kinda of an oldbe but that was a long time ago and a few emails back. I want to create pop up comments based on pivot table fields. They are actually team replies to earlier reports and figured it would eb a goo way for management to get the notifications. I already have it...
  19. B

    Page and header sections not showing in Subform Report

    I just finished created all the reports I need for our directory and now I would like to put all on them on one continuous report as opposed to separate reports. This report would be sent to a PDF to be sent to the printer for publication. For some reason, on the detail section of some of the...
  20. A

    Macro to write a macro

    I've written a macro that processes seven reports every day. My bosses have asked me to set up a macro that adds to the original macro when new reports become available. In other words, a macro that creates a macro. If nothing else, I figure I can create a blank script in Word, an input box...

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