reports

  1. E

    Multiple If statements based on multiple criteria

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

    WEEKNUM function not working correctly

    I am trying to use the WEEKNUM function but it miss reports the week. example cell function in B7 =WEEKNUM(B6,11) using a date of 29/12/15 reports week 53 (Week 53 is December 28th 2015 to January 3rd 2016) but put a date of 01/01/2016 reports week 1?? It is still part of week 53...
  3. K

    Tables and Queries

    I have several tables in separate workbooks that different users populate based on the stage that a project is in. MainTbl: holds basic info on a project QuoteTbl: info on status of the project's quote info EnggTbl: info on engg for projects FabTbl: info on fabrication for projects AdminTbl...
  4. E

    define Path in inspect element

    Hi I have the current path to clicking a button in a website. is there a way I can define this path to click on, e.g. getelementbyid? $x('//*[@id="header"]//div[text()=" Extract Reports "]') Appreciate anyones help.
  5. deletedalien

    VBA to Hide sheets based on their own cell value.

    Good morning all, i searched the forum and found similar results to what i need but not quite meet the criteria for my specific issue and i am hoping that you guys can help me with your knowledge. so what i have is a series of reports that i update every morning and they all need to have data...
  6. T

    VBA to combine individual print jobs into 1 print stream

    I have a workbook with a worksheet (Reports) listing all the reports I want to print i have another worksheet (Calcs) which has all formulas pulling from other data sheets...this sheet has a validation drop down reading from the list of reports on the reports tab...once you change the drop down...
  7. V

    consolidate data from multiple workbooks with multiple sheets.

    Hi guys, We receive 7 different reports which are copy pasted in a single workbook in different sheets(as per reports name), and each of the report is allotted among 4 members and processed, Such that all 4 have to work on all the 7 reports. At the end of the day I need to collate the 4...
  8. G

    Copying data from multiple workbooks to one worksheet

    Hi, I use a worksheet where I reconcile data from different reports. All repports have only 1 worksheet and use the same format. VBA uses GetiOpenFilename with Multiselect enabled so ultimately, I would like Excel to import data from 1 workbook at the time and then continue with the following...
  9. C

    Check Range Show Error if Missing then move on

    My problem is I have a number of reports and I have a macro that goes through each report and extracts data from each as needed, these reports however are made by separate individuals while most of the formatting is the same in each the first 4 rows of information is sometimes scatter within the...
  10. S

    Excel to MS Word Mail Merge - how to create multiple directories broken up by a field category

    I have a mail merge directory that i've created using MS Word, which pulls data from an excel spreadsheet of project team itineraries. The data is constantly being updated - people quit, locations close, people run over schedule at a stop on the list, and so the reports need to be constantly...
  11. M

    Generate pdf for each pivot report filter with name

    Dear all I need help. I have a pivot table which generates customer statements. I have 125 customers. what I do every month is I manually select each customer in report and save file as pdf and name it whatever name is in report filter (obviously the customer i selected) Now I know this can be...
  12. A

    VBA loop down x number of cells, move to next column and loop again

    Good Morning Everyone! I'm about 4 months into learning VBA so I'm still a beginner. I am trying to write a code and I'll do my best to explain what I'm trying to do. I have a worksheet with multiple columns of financial data going down the columns (In this case columns C,E,G,I,K....). Next to...
  13. P

    Formatting Page Header/Footer based on if Page of a record

    Good Afternoon, I am working on a project which has a "form letter" that provides information about their record. Depending on the number of items in their record/profile their letter could be one or more pages. What I would like to do is (a) print our masthead (which is an image) on page one...
  14. D

    Can I produce text-based reports using Excel dropdown lists?

    I'm a teacher, and I really enjoy finding efficient solutions for some of the tasks that my job requires. I had an idea about how I might be able to efficiently produce student reports, and need some help in working out how to do it. I'm relatively new to Excel, but am keen to learn. I'm...
  15. A

    Dynamic Named Ranges and Pulling from Data Sheet to rest of Workbook

    Hi all, I have seen many advanced spreadsheets that make use of a single Data sheet, where data is only pasted or imported from some data source and drives the rest of the workbook. I have set up a data sheet that records the type of customer, their status (i.e., recent customer, not-recent...
  16. T

    Export Access Form or Report to Powerpoint

    Is there a way to export a list of forms or reports using VBA to Power point? I currently can export a list of forms to PDF but would like to have the ability to put these over in power point. The forms contain graphs and when I copy the PDFs into power point it makes them fuzzy. Like a bad copy...
  17. K

    Application On Time Help

    Hey Guys, I am pretty new to VBA and have never really had any training with coding for it. I am setting up an automated report but am having trouble getting the application on time event to run more than 24 hours. The Reportupdate Sub updates quite a few cells based on the current, that why...
  18. F

    Is excel even the right solution? Technical reports.

    I have been trying to use excel to generate quarterly TECHNICAL report printouts related to preventative equipment maintenance. We use a specialized program to generate the actual data for each individual report, so there is no accuracy nightmare with the actual data. The program generates a...
  19. A

    Generate Daily reports

    Hey all. I have made a table on excel that gives the daily business brief for each month. I will be inputting expense and production data into it each day. I want to generate daily and weekly reports that gives the business brief for that day or week and can be printed on one page and sent to my...
  20. H

    Generated Access reports

    Hi everyone, I have created many reports in the past using button that I created. All the reports that were generated by the macro button is showing in front of other open windows (forms, query, etc.). This time when I created a new database, the reports I created display on a tab - not...

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