reporting

Morning all So I'm using Excel Online within OneDrive which has a workbook with multiple sheets. Sheet 1 has each row with a load of data relating to the unique entry in cell A. Sheet 2 has rows of data where multiple rows (not necessarily in order) may have info relating to that unique entry...

Hi! Wishing you all a Happy New Year! This new year- My goal for this year is to ask for help and to understand macros and formulas more but since my workbooks seem a little tedious. I wanted to reach out because I have this extensive workbook with multiple formulas but I'm sure there is a...

Hello, I have a couple of files that my manager uploads into an internal folder for our department on a monthly basis. Those files relate to multiple existing real estate investments of our own. Each real estate file differs in terms of its format. What I need is one cell from each of those...

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

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

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

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

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

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

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

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

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

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

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

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

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

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?

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

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

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