excel 2019

A little bit of a strange one for me as I have experienced this issue before . I have a sub which is a file picker. This allows a user to navigate to a windows folder and select 1 or many text files and then import them into Excel. Excel is *supposed* to import all selected text files in to an...

Hi all, Silly question but this is so unintuitive for me: For Each Table in Doc.tables For Cnt=1 to Table.Rows.Count Row = Table.Rows(Cnt) If ... DataRow = Table.Rows(Cnt+1) MsgBox DataRow.Cells(2) End If Next Cnt Next Table I can do...

Hi All, I been given a folder with a list of PDFs and I need to extract certain fields out of it to an excel sheet. However, we are only capable of using Excel 2019, so Power Query was out of the window. I'm currently attempting VBA to solve this problem. However, I'm not well-versed at all...

There is an Excel Add-in that makes retrieving Economic Data from the Federal Reserve (simply called FRED Data) easy. However, there are inherent problems it presents. You put the CODE of the data series you want in row 1, and optionally add Data Manipulations (such as retrieving the change from...

Hi, There are some values in coloumn A and coloumn B . The solution is just to simply get the duplicate values from coloumn A and B , and then display those duplicate values in Coloumn C AND Coloumn D. EXAMPLE: A B C D 1 3 1 3 2 4 5 6 3...

Hi I've just started using a ListBox in Excel to view a table from one sheet on another. I've been able to do this using very simple code as Private Sub UserForm_Initialize() Me.ListBox1.List = Worksheets("Cashflows").Range("A4:H26").Value End Sub However, as this does not include...

Hello everyone, We are a small company and i would like to add some QOL things to our excel spreadsheet that we use for inventory in excel 2019 Column A: Job number column B: Part number Column C: Quantity column: D Client I know how to add a macro to a button and stuff like that but i aint...

I have this JSON Microsoft Scripting VBA code that pulls data from a work website into Excel. Can pull about 55,000 rows of data. About 5 columns of data. On 2016 the code worked fine but on 2019, which I need the code on, it takes forever to run or crashes Excel. I then have to quit Excel. I...

Hi, I'm trying to create an excel spreadsheet (version 2019 and no ability to upgrade to 365) to keep track of appointments. There are sheets for each month. And I need the appointments for future dates to show up in their respective monthly tab automatically (without disappearing from the...

Hello, I need help with saving an Invoice Workbook which contains the "Today()" function using a Macro. The Active Workbook (Invoice) has the "Today()" function in Cell B14. Auto Calculate is active so whenever I open the Workbook todays date is displayed. So far so good :) I have 3 Macro's...

When I save the workbook excel triggers a calculation of the workbook. I have no problem with this and I can always turn it off. When I go to each sheet and calculate the sheet the results remain visible on each sheet. When a calculation is done on this workbook, the formula results disappear...

What I need to do is to count the number of conditional highlighted cells in each row (range) for each color. Ultimately, if the color exists in the range, I intend to have a value of 1, else a value of 0. Here is a worksheet with an example of what the result should be for the first 5 rows. It...

Hi Periodically Trace Dependents stops working in Excel 2019 and says no dependents even when clearly there are (There are no circular references, so that is not the problem) Per the example in the attached JPG, I opened a brand new spreadsheet. Put values in A1 and B1 and set C1 = to A1 + B1...

I want to extract all text outside of any parenthesis. I can get the text from the first occurence of a parenthesis using: =TRIM(LEFT(A2,FIND(" (",A2&" ("))) But now sure how to do this for multiple occurences. Below is an example. Text Expected result Cucumber (1) Cucumber Cucumber...

Good morning. I am working on a problem in my Operations Management class and am having a problem with a calculation formula. Question: Wanda's Car Wash & Dry is an automatic, five minute operation with a single bay. On a typical Sunday morning, cars arrive at a mean rate of 8 per hour...

In Excel 2019, when adding a secondary X axis to a scatter plot graph that already has a secondary Y axis, the series previously associated to the primary X and secondary Y, become associated by default to the secondary X (the association to secondary Y axis remains). The specification of...

Hello everyone, I am working simultaneously with multiple instances of Excel, as this is a way to utilize more CPU and decrease calculation time per instance. Basically, there is one "Master" instance and several "Slave" instances. When I start the day, I first open the Master Instance, and...

Hi Friends, I am trying to add sequence/following numbers in ColumnA based on cell value in ColumnB. I been doing it manually, but its taking countless hours to go through thousands of rows. Thought that I can get some little help here. Attached the spreadsheet to understand more. ( Hightail...

Hello everyone. I stumbled upon an issue which i can't seem to solve immediately. I am currently working on a project - automating excel as a relatively simple database. There is basically a front-end (with the intention to make it an excel add-in) and a simple xlsx as a backend. It has its own...

Hi I have pivot table with 2 years of cost data for services and I have taken average cost as a sum. The issue I have is some of my data has N/A e.g cars 2019/20 £5000 cars 2018/19 N/A So when I pivot the above instead of excel taking 5000 it takes the average of two years which is £2500...