summary

Hi All, I am trying to convert data from a query into a print out. The table shows a list of skills along the top and the status for the employee in the table. I want to create a summarised printable sheet that converts that data to show: Skill (e.g. IOSH Working Safely) Status (e.g...

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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