Get instant live Excel expert help to learn how to create and adjust tables in Excel?

I have 3 years of electric use recorded by date each week. I want to put the data in a table with x axis the year and y axis the month but can not work out the sumifs formula to do this. An example file attached

I am attempting to create an Excel Table macro in VBA that can create the same pre-formatted pivot table to the data, regardless of sheet name or number of rows in the data ( # of columns is always fixed). I would then like to insert the pivot table to the first available cell in row 1 (W1). Unfortunately I cannot share the real data at this time, but I have included my code so far in an excel sheet. I have looked into changing .select and .activesheet but haven't had any luck. I see that my problem lies in the part of the code where the pivot table is created by referencing specific cells and sheets. I need this to be more dynamic to read and interpret any set of data. Thank you in advance!

I am attempting to create a Pivot Table macro in VBA that can create the same pre-formatted pivot table to the data, regardless of sheet name or number of rows in the data ( # of columns is always fixed). I would then like to insert the pivot table to the first available cell in row 1 (W1). Unfortunately I cannot share the real data at this time, but I have included my code so far. I have looked into changing .select and .activesheet but haven't had any luck. I see that my problem lies in the part of the code where the pivot table is created by referencing specific cells and sheets. I need this to be more dynamic to read and interpret any set of data. Thank you in advance!

I am looking to take data from a pivot table, multiply two rows together, and show a third row.

I need to add an equation to a value field in a pivot table.

need to learn pivot table v look up and h look up

Using the INDEX and MATCH on excel functions; I am trying to display the top 3 clients who have raised the greatest number of queries per month. The challenge is where duplicate data is found. For example, in April Client 1, Client 4 and Client 5 all reported 2 issues each, so I would like my table to return all 3 client names, however, only Client 1 is being returned.

need a formula making for my spreadsheet so that the bottom table calculates the accumaltion of sales from the venues from the top table?

Hi, i like to create format table for work due date 7 days before allot required(like conditional formatting) with different scenario of production stages kindly help me

I have a list of changes in a table VO1-VO150 each a buildup of material & labour and separately priced each occupying 11 rows. A1, a12, a23, etc. - TABLE 1 I need to summarise them in to a separate table VO1,2,3, etc. but simply with consecutive cells A1, A2, A3, etc. TABLE 2 Is there a way of automating the process of inserting the totals from Table 1 directly into Table2 instead of entering individual formula =sheet 1 a11, =sheet 1 a22, =sheet 1 a33 etc.? Thanks