1. R

    Transposing Budget line items from Col into Rows ( each Row has to be replicated 12 time for each month

    Hello Experts, I am working on a budget file where users are given an excel template to fill in Budget data for each line item as follows ( I have give We have another deptt who give us the erp based report where actuals which are booked under the planned head as follows we are doing this...
  2. D

    Weekly reporting added, changed and removed / General approach advice

    Hi, I use Office 365 and utilise sharepoint list to capture sales opportunities that I then pull down into excel and have it linked so I can refresh. We are moving to a CRM system but this not for a few months. The list details the customer name, opportunity name, Country, Industry Sector...
  3. T

    Grouping in Power Query

    Hi All, I have data that comes in tab format. so have to summary the data with Value & Reference numbers by client. but with multiple transaction ID's and reference numbers im not able to arrange the summary the way my management want. They need Client Name > Reference Number for Sales >...
  4. M

    How to create a Word report using Excel?

    Hi There, I am fairly new to this but I am trying to make a report in Word, I have a template that I am working from but I can't seem to find what I need online. Basically I want to be able to type details in excel such as company name, address, products, specific products used. I have started...
  5. 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...
  6. 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...
  7. S

    Writing sql for a table to extract information for reporting

  8. 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)...
  9. 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...
  10. 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...
  11. 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...
  12. 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...
  13. 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...
  14. 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?
  15. 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...
  16. 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...
  17. M

    DAX code to track project progress as at reporting date

    Hi all, First up, I have posted this query on another forum 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...
  18. 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...
  19. 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...
  20. 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...

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