reports

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

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

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

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

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

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

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?

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

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

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

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.

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

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

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

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

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

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

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

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

Hello all - I have a statement that has be stumped. I am looking for a true condition based on multiple criteria, however, the formula needs to stop at the first result if true. I have four columns. Column A is Number of Days. Column B, C and D and Number of Test Days. What I need is for...