table

Hi I have the following code to convert sheet range to number in power query, The range named "Tests" would accept any thing except number. I know there is minor change I have to do, but I couldn't figure it out. let Source = Excel.CurrentWorkbook(){[Name= "Tests"]}[Content], MyList=...

Hi guys, how are you? I need your help because I want ran from boring and hard job to work with PDF and I want to convert the table from PDF to Excel. I read different forums and watch different videos on youtube but cant find the solution. I found only good advice to convert PDF to Word...

Hi, I have multiple data series provided from a source in a format similar to SeriesName1 NameTitle DataPoint1Title DataPoint2Title DataPoint3Title Person1 DataPoint1 DataPoint2 DataPoint3 Person2 DataPoint1 DataPoint2 DataPoint3 etc SeriesName2 NameTitle DataPoint1Title DataPoint2Title...

Hi all, I want to know if its possible the below scenario: I have a table, with some formulas here and there, but in column O, I have a formula with some conditions and dependent on other 3 columns in same table. What I want to know, is, if I can have some kind of script that every time...

I need code to stop running when a Table called Table2 is already there. Some reason I can`t get the Function to work with main code? Private Sub Worksheet_SelectionChange(ByVal Target As Range) Dim Rng Dim Result As Integer Call DeleteTbl If Selection.Count > 1 Then...

On Sheet 1, I have a table that gets copied onto Sheet 2. Sheet 2 then has the entire table with some additional information that is manually inputted with each row. Currently I have it set up in each column where it is just ='Sheet1!'A1 for every cell. I get my information from Sheet 1 from...

Hey everyone, I want to take this sort of table: ABCDEF1KeyWords21bb132bb243bb354bb465bb5cc5dd576bb6cc6dd687bb7cc7dd798bb8109bb91110bb101211bb111312bb12cc12dd12ee12ff12 and convert it into this kind of table: AB17WordsKey18bb1119bb2220bb3321bb4422bb5523cc5524dd5525…… How would I do that? Any...

Hello! I'm trying to highlight the active row in a table. I have multiple table in 1 sheet and I already formatted the sheet to highlight the row when selected. However, when selecting the row in a table, it also highlight the same row in all the tables. is there a way to only highlight the row...

Hi All, I have this worksheet (see below) that has multiple formatted tables. Users are able to add or remove table rows as needed. What I'm wishing for it to do via VBA is the following: Remove any empty rows from any of the tables Print the whole thing from A2 down to F...the row just after...

I need a formula that is using the data from the table named "Costs". I need to sum the Hours column IF the Concatenate column has any of these values...162FOL, 392FAL, 392FGL, 392FFL, 392PFL, or 452FGL AND the date is before 6/1/2023. This is what I currently have and it is returning a result...

Hi team I have a table on Sheet 1 and some values on sheet 2 column E Is there a way i can filter the table in sheet one to display content only if Column A in the table matcehs the values from Sheet 2 column E . I hope this want too confusing :) Thanks in advance

Hi all, I have inventory stock details with 11,000 part count and I am making vehicle from this inventory. Now for one vehicle I require 1300 to 1500 parts with varying quantity on each part. there will be multiple vehicle codes I want to create a crisp VBA where it will show me 1) how many...

Worksheet 'Dashboard' has a weekly breakdown for production numbers. I have tried multiple ways and continue to get formula errors. I need to count the number of entries in multiple other worksheets as follows: Worksheet: DG_Procedures has table DG_Table with column Date Submitted to QC. I...

Hello all - In Excel O365, I have a table that has data which starts in row3. (Row 1 and 2 are headers) In col HJ (starting with HJ3), I have formulas that return "W", "L", or "". (So Win, Loss, or Blank) In col JS, I have formulas that check if HJ (is a "w". If it is a "w" the formula...

Hi I have the table attached and I want to have the output table attached. Power BI has to get the last owned vehicle by person and then get when it was owned.

Hi all, I am trying to figure out how to best visualize 5 years of monthly data of sales figures across 40 departments, where the goal is to find trends in a given month-year combination for a department (and perhaps ideally, comparing across the 40 departments for the 5 years of month-year...

Private Sub cmdClose_Click() End End Sub Private Sub cmdSubmit_Click() 'Priority Options If Pri1.Value = "True" Then Worksheets("Procedures").Cells(lastrow + 1, 2).Value = Pri1.Caption End If If Pri2.Value = "True" Then...

Hello all, I have a piece of VBA that identifies the last row in a column, so that I can assign values: Lastrow = ActiveSheet.Range("A" & Rows.Count).End(xlUp).Row Range("A" & Lastrow).Offset(1, 1).Select BankNo = ActiveCell My issue, is I recently formatted the data on the worksheet as...

I have this VLOOKUP for Table3, =IFERROR(VLOOKUP([@Concatenate],'COST TYPE SUMMARY'!$G$2:$H$35,2,FALSE),"0.00"). The rows will vary each month, so I need the formula to auto-populate the new cells when they are added. Is there a way to modify this formula to make that happen?

Hello, in my vba i would like table border to be black but however after a lot of test trying to add in css it dont work, i have realize that the only style i can use is through excel vba style for tables I am trying to get my table that i have created in vba to have a border that is black...