reporting

  1. S

    Run-time error '1004'

    I have a monthly report which has a macro that combines data from two sources automatically and updates several pivot tables. This report used to work flawless on ex coworkers computer. He sent me the report and now I cannot make it work. I receive below error: Run-time error '1004' : We...
  2. mole999

    Sub is this possible

    I'm having a big problem with a set of routines (I won't explain them) Is it possible to call a routine from a Sub, and return the ID of the calling Sub (maybe its not worth doing) I want to list each sub entry and a time stamp to be able to focus down on what the issue is Sub One Reporting End...
  3. S

    Writing sql for a table to extract information for reporting

    HELLO EXPERTS, I NEED TO WRITE A SIMPLE SQL TO EXTRACT DATA FROM A TABLE. TABLE IS ALREADY EXTRACTING DATA FROM MULTIPLE FILES AND IS REFRESHING WELL WHEN DATA IS UPDATED IN SOURCE FILES. NOW FROM THIS TABLE I NEED TO WRITE COUPLE OF COMMANDS / SQL IN DIFFERENT SHEETS / WORKBOOKS WHICH MAY...
  4. C

    Vlookup or any other function

    Mr (or Ms) Excel Community, I need your help to figure out the formula as I hit the roadblock. I used the following formula to come up with the reporting liters value of the below table: =IF(AND(B4>=D2,B4<=E2),C2)*B3 The outcome I am trying to achieve that we manually input gallons value (B2)...
  5. R

    Recording a long formula is splitting it and destroying it

    Hi all, I'm trying to record a sumif with 6 different criteria pointing at different workbooks, when I record it, it seems to cut it after a point and replace a bunch of it with a " _ & " As a result, I think I fixed it with this but I still get application or object defined error...
  6. P

    Multiple Reporting

    Hi - looking for help with regards to multiple reporting. I have 4 Elements Business Areas - up to 100 Products - up to 20 UK or Europe New or Used Product I am trying to report the volume of all products within each area and whether they are New or Used in UK and Europe This would be...
  7. R

    Data Reporting/Extraction on specific dates

    Hello Everyone, I am new to Excel and need some help for my project. I want to extract a particular cell value on weekly basis. The start and end date of project is known. The cell value named 'percentage of work completed' updates every day, but I want to know the status only on weekly basis...
  8. L

    Create new column with macro

    Hey all, I'm currently working on a private equity report that I want to automate. Ive made a rough draft of what I am looking to do below. Assume the first two columns are manual entry (Company Reporting, 6/30/2011). I want to be assign a macro to a button that, when pressed, will...
  9. M

    Auto Update Date Every 7 Days

    Hi All, I'm a newbie to Mr Excel so please bear with me! I have a small problem on a worksheet and have searched for a solution with no luck. I have a date box (cell A5) that controls a range of dates on multiple pivot charts on a office report which is auto emailed daily. At the end of the...
  10. J

    EXCEL form not opening for other people the way it is supposed to

    I have a form i created that is protected so that the supplier can only fill out certain areas that i want them to. when i send it out to the suppliers they are reporting that the single page document opens in 4 pages. how can i stop this so that everyone can open it the same way?
  11. R

    MACRO HELP NEEDED: Complex comparison, text coloring, and reporting between an old and new sheet.

    I have a complex macro in my mind that I want to build, but such little macro experience that I just can't build it alone. One workbook. Three sheets. Several hundred rows, but only columns A through G. Sheet1 "Old" Sheet 2 "New" Sheet 3 "Final" Sheet 4 "Report" Each workbook has the exact same...
  12. S

    Extract all rows from a range that meet criteria in columns

    Hi, i have a list of dataset from A1 to AZ200. The row A1 to A200 are list of projects that company has. Columns are name of the officers in the company and also the months of each year (Jan-Dec18). The excel spreadsheet keep tracks of the monthly revenue and expenses of each project as well...
  13. M

    DAX code to track project progress as at reporting date

    Hi all, First up, I have posted this query on another forum https://powerpivotforum.com.au/viewtopic.php?f=6&t=1305 I am working on a dashboard that can track all the projects that are currently being undertaken. The aim is to report on the progress of the various projects over a period of...
  14. Y

    Need help in forecasting

    Hello all, I hope someone can assist in this - and thanks in advance. I hope I can explain this without much confusion. I have a sample survey size of 1,120. 60 people out of 1,120 responses are reporting site errors (so 5% of the population is reporting site errors). It is assumed that these...
  15. Johnny Thunder

    VBA Help - Code to Look into Folder Directory for File and Download to Specific Folder Location

    Hello All, I have a project which requires a tool that is capable of looking at a set list of file names, a specified sub folder and seeing if the file exists, if so, then make a copy of the file to a specific Directory and update the workbook that I will trigger the code form with a "Saved...
  16. M

    Open file based on changing date value

    Hello, I am trying to createa vba code that will open two spreadsheets based on the changing year and monthvalues. I have the below codethat will first enter the date value needed for current reporting period andprior reporting period (3/31/18 and 2/28/18 respectively).I am having...
  17. M

    Power BI replacing Reporting Service

    I just started learning Reporting Services of Ms SQL Server and found it is no match with Power BI from a beginner view. Anyone is still using Reporting Server and please advise if I should continue with MS Reporting Service or simply jump onto Power BI instead ? What is the advantage of...
  18. I

    Splitting data out into 100s of worksheets

    Hi there, I have been asked by someone in my organisation to try and improve an excel file they use for managing account transactions. They basic format is this: We generate a tab delimited TXT file from our banking portal which lists all of the transactions made for the month. This is then...
  19. J

    Excel sheet to report if Word documents have certain values

    Hi guys Firstly, a big thanks to the community here. I have always seemed to get the answer to my queries so hopefully today won't be any different. I am NOT a vba coder but have managed to bluff and blag my way to get to this point. I have made a spreadsheet where the user loads a list of...
  20. H

    Amend Message Box to include Text

    I have the following code below Range("f1").Select Dim myValue As String ActiveCell.FormulaR1C1 = InputBox("Enter the Report month and year") Range("F1").NumberFormat = "MMM-YYYY" I would like to automatically include text in the message box Reporting period : so that when the month...

Some videos you may like

This Week's Hot Topics

  • Sort code advice please
    Hi, I have the code below which im trying to edit but getting a little stuck. This was the original code which worked fine,columns A-F would sort...
  • SUMPRODUCT with nested If statement
    Hi everyone, Hope you're all well. I'm hoping someone will be able to point me in the right direction with a problem I'm having with a SUMPRODUCT...
  • VBA - simple sort is killing me!
    Hello all! This should be so easy, but not for me, apparently! I have a table of data that can be of varying lengths and widths. My current macro...
  • Compare Two Lists
    I have two Lists and I need to be able to Identify differences between them. List 100 comes from a workbook - the other is downloaded form the...
  • Formula that deducts points for each code I input.
    I am trying to create a formula that will have each student in my class start at 100 points and then for each code that I enter (PP for Poor...
  • Conditional formatting formula required for day of week and a value
    Hi, I have a really simple spreadsheet where column A is the date, column B is the activity total shown as a number and column C states the day of...
Top