1. CubaRJ

    Returning a Set of Values from 3 different tables based on 2 criterias

    Hi! I am struggling to find a suitable solution for this problem, and hoping you guys can help me. I have 3 different worksheets containing training matrces for installations; Each tab belongs to an installation; The columns and structure are the same for all of them, and the difference...
  2. J

    Get a summary table from transaction table

    Hi everyone, I am new here. I have a table which looks like this. Team Person Period Cost Revenue A Tom 1 100 200 A Tom 2 150 100 A Jack 1 50 90 A Jack 2 75 80 B Sarah 1 300 400 B Sarah 2 150 500 Can you please help me with the achieving the following results on Power BI...
  3. K

    Looking for a Formula / VBA that adds and transposes project cost and phase items

    So I have a table that has the following Phase Code Description Cost Preliminary Phase A1 Liaison $ 3,000.00 A2 Project Meeting $ 2,000.00 B1 Financial Modelling $ 1,000.00 C1 Project Management $ 1,000.00 Main Phase A1 Liaison $ 5,000.00 A2 Project...
  4. O

    Summary sheet of multiple sheets

    Hi, I am working with making a template in excel for writing hours at my workplace. In sheet one named “Oppsumering” I want to have a summary from the other sheets I add. Each sheet represents one week and contains the hours from different tasks. The sheet named “Uke—” is the layout for where...
  5. L

    Summarize and total data from another sheet

    Example sheet named "Project Estimate" Stage 1 - Project Manager 5 - Account Director 10 - Account Director 30 - Copywriter 10 - Project Manager 5 - Project Manager 20 - Account Director 10 - Copywriter 5 - Account Director 10 Please see above table to demonstrate a sheet...
  6. H

    Create tab with dynamic summary info pulled from multiple other tabs

    Hi, To give you a bit of background I work for a property company and we currently keep our database of properties on Excel. There are multiple entities and each entity has a tab on a workbook, each entity tab contains the same column headers across the top and down the side are the list of...
  7. M

    VBA making summary from several sheets with desired format

    Hello everyone, some time ago I created a code here with great help from DanteAmor which can extract the selected data from all sheets and create a summary from them (see "Summary" list). I would like to thank him once again for that. But since I will use this code for a few more years and I...
  8. C

    Summary page for multiple sheets project tracker

    Hi, I am trying to create a project tracker with a summary sheet that will sum up: Team member Task Status Due Date Each Individual sheet will be completed by the team member and need a summary page. I tried a VBA code I found in another thread but it isn't working. Any help would be greatly...
  9. Z

    help needed with formula

    hi, i have this table which consist all the transaction happen in the month(Mytransaction). in another table(Summary), i would like to do a summary based on the transaction table. in one of the cells is to input the latest balance of the account so the problem is that I want a formula to detect...
  10. A

    Pulling specific data from multiple workbooks into one

    Hi all, I have been reading many of the posts on this board that have helped me immensely in learning VBA, however the macro that I’m working to create now hasn’t had a discussion that I’ve been able to find. I have about 15 files with different financial data in a folder; each file has...
  11. R

    FIND Question

    Hi! This seems like it should be pretty easy, but I can't get Excel to accept my formula. Maybe there's a better way to do what I am trying to do. There are two relevant tabs, "Total Summary" and "List." I am entering the formula on "Total Summary" to count items that meet specific criteria...
  12. J

    Count multiple worksheets qty of rows

    Hi, I have a number of workbooks, named by date they were created, and need a summary of how many rows each workbook has. Thanks Jon
  13. J

    Add Totals Column on multiple sheets

    Good day, I have a workbook containing multiple sheets and a 'Summary' sheet. I have a column in the Summary sheet named 'Balance as Per Schedule' and I want to sum the amounts in the 'Total' columns on each sheet by using the ID No as the criteria. Basically there is a column for 'Total' on...
  14. J

    Update columns with summation based on criteria in multiple sheets

    Hello, I'm not sure if this is possible and I have limited knowledge of macros. Here is what I want to achieve: I have a Summary Sheet with a list of names and ID numbers vertically and each month of the year horizontally as columns - e.g Jul 2019, Aug 2019, and so on. I will then have a tab...
  15. F

    Copy Data from One Workbook to Another

    Hello all, Should be a simple piece of code, but I'm getting a timeout error. I've got a workbook, let's call it "summary", which I want to put a macro in that will open another workbook, select all the data from a specific tab "CFG", and paste it into a tab, of the same name "CFG" within the...
  16. K

    Importing data from multiple workbooks to one sheet in master workbook

    Good day all. I'm busy to automate some of our time sheets and overtime reporting. Each employee completes his/her own timesheet in a Excel Spreadsheet. Some of this information is then merged into a monthly summary. At the end of the month the employee is using a button, with a Macro, to print...
  17. B

    Changing the month in a sheet name

    I have several files that I use every month. I have two sheets which include the current month that I am working on. For example, I'm starting the November file and I need to rename a couple of these sheets from Sept to Oct (I do commissions so we I am preparing the Oct commissions to be paid...
  18. Q

    How to create a search command box sheet to input one factor and display results specific to that factor

    Hi All, In case my subject line may not be self explanatory, apologies for that, I shall try to explain it better below. I have a data dump of a sheet. I want to create a sheet where I can get a summary of specific criteria/columns based on an input. I believe I would need to have an input...
  19. A

    Copy data based on column header from one sheet to another sheet with added criteria

    Dear All, Can anyone please help me with the VBA code for the below requirement ? I have a workbook with few sheets in it. I want to copy data from "Detailed" sheet to "Summary" sheet according to some selected column heading in row 2 of the "Summary" sheet. The same column heading are...
  20. J

    Sumproduct with Multiple Rows and Columns

    Hi guys, Although I've been reading for a number of years, this is my first post. Please bear with me if I do something incorrectly. I have a workbook that is basically taking invoices and rolling them up by date, truck number, and expense type. The problem is there can be multiple invoices...

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