tables

Dear Community, I thought I was clever to setup and create a List for my Team, where we can share and enter our Day-Off Time. Therefore, I generated a Table with all the members and created for each month a separate Sheet, where within the sheet I have a second Table that is showing the days...

Hi, I'm new to this forum. I have an excel sheet with over 2000 rows. I want to have the maximum number of the Quantity of each item Code when the location is the same. For example, you can see in the excel sheet i have the ItemCode : 389-12-040 1107 01 4.00 1 1107010 A 389-12-040 1107...

I have been struggling to create a pivot table using the following piece of VBA code, but I cannot find the error. I assigned a watch window to PT2, and I noticed after I set PT2 equal to the PivotCache, PTCache2, PT2 still appears with a value of nothing. The With Block does not work because...

Hi I have summarized data in the following format: 2021 2022 2023 admin 1 2 2 I would like to convert this so it is presented as: admin 2021 admin 2022 admin 2022 admin 2023 admin 2023 I've tried PowerPivot and the Unpivot option. That doesn't seem to show in this...

Hello, I'm just entering the world of connecting to SQL via Excel, so please bear with me if I don't get any of this terminology right. I'm trying to merge live sales data that I import from SQL with static cost values that I track within the same workbook. In my previous iteration of this...

hello i’m new at work and i need help with a very easy task but i dont know how to do it with tables just with ranges in VBA, but its important to keep it as a table to my boss, what i need is a row goes to the bottom depending on the cell value on column O when it says “ DONE” and i prefer not...

Hi guys, This problem is driving me crazy and also making my spreadsheet extremely slow. Assume I have a table called Table1 and another called Table2. Both have 3 rows and 3 columns including headers and the first column which is the name of people, for example. The names column in both table...

Sub TurnTablesIntoRanges() Dim wks As Worksheet, objList As ListObject For Each wks In ActiveWorkbook.Worksheets For Each objList In wks.ListObjects objList.Unlist Next objList Next wks End Sub Hello, A novice here... I have few tables in each workbook in a multiply sheets excel file. Can you...

Hi.. I need help to develop an excel formula in referring values from different tables and ranges and add the value to basic size and place the results in respective cells. the demo file is at below link, and also one small explanation of my requirement. Kindly help... Thank you in advance...

I have a Back End (BE) with all my Tables. When I am solely in the Front End (FE) Database everything runs fine. As soon as another user opens and uses the Front End database the database somehow is loosing the links. We get a message that it doesn't recognize the back end and we have to...

I've got three tables TableA: <tbody> List of Tables Other Info TableB Info1 TableC Info2 </tbody> TableB: <tbody> Column A Column B stuff morestuff otherstuff extrastuff </tbody> TableC: <tbody> Column A Column B onestuff redstuff twostuffs bluestuff </tbody> I ultimately...

I don't know if anyone out there has experienced the error message when opening an Excel workbook. I have a workbook with 37 worksheets. A few of them have Tables, not Pivot Tables but regular Tables with drop down arrows. I also have many macros and most of them create the Tables for me...

Hi, Does anyone have any experience of applying formats to pivot table measures conditionally based on their name? For example, if my measure has a (£) in its name, then apply a currency format, else apply a simple numeric format. I've done this kind of thing successfully with ordinary pivot...

Hi all, I have a worksheet that I set up with 47 tables I need to be able to insert a row above the last line of each of table and copy formulas, cond. form. but not values. I have a code but excel has to reference it 47 times and in turn it takes for ever to complete and it copies cell format...

Hello All, My inexperience is showing here and I hope someone can help. I have some VBA code in an Excel workbook that creates a Word document then copies various objects from the workbook to various associated bookmarks in the Word document. After I have completed copying and pasting some...

I need to create a pivot table that references two data tables -- Budget table and an Actual Table. They are on separate worksheets, but how do I reference both data sheets? Thank you, Tom

I have file that on a monthly basis I dump an extract into. That extract feeds pivot tables on 3 other sheets displaying the information at varying levels of detail. I already have a VBA to auto refresh the tables when new information is added but I'd really like one that could auto filter the...

Hi, I have a worksheet which has approximately 60 entries added to it each day. The worksheet is summarized into pivot tables on another worksheet with a timeline to sort them by dates. I can get this working no problem however with multiple people adding data to the main worksheet my pivot...

I have looked and do not find a solution to acquire one column's data, insert it into a new sheet. Then acquire another column's data from a different sheet and enter that into the same column that the first column's data was inserted. This way the data from two columns, each from a different...

I have a sheet with about 20 tables of data (one table per tenant), and I would like it to print as many of these tables as can fit on one sheet, but I don't want it to split any of the tables across two sheets. For example, if page 1 could feasibly fit 2.5 tables of data, I would want page 1 to...