tabel

I am trying to use getpivotdata with a cell reference but get an error when adding the cell reference.

Aloha In Access, I have a table with three parts Specialty Location List of support names In my form I want to have a field to enter number 1 and number 2 the result in a different cell will return the correct name. B The attached images is from my table. The first two are the condition that...

What would cause a table to be expanding by one row that has no reason to do so? the row in question is blank, checked all cells, but it does present filter drop arrow when clicking on cells of that row which is odd? going to go back and see if any spaces are in cell that appear as "space bar"...

Hi In PowerQuery I have a tabel that looks like the tabel under (TBL1). if you see under the ItemNo I have 1 or several same ID. So I need help to make a colum that takes e.g. ItemNo: SHD3061 that have 2 rows of images and concatenate. So my result I hope to achieve is this (TBL2) TBL2...

Hi guys. I have a large datasheet in which i have tabel 1. This tabel contains 5 coloums and 200 rows. I Would like to insert/create a search bar in which i Can type words and then the search bar should ‘hide’ Rows that does not have any of the five coloum resultat in common with the searched...

Hi I have a tabel in power query excel 2016. In this query I have a tabel like this under here. My question is, is it posible to split the A column so it will look like the second tabel under here? In my tabel I have many other coulums to, like Amount, Restamount and som others, but this is not...

Hi Guys, Question, imagine a tabel with 100 names on a worksheet in Excel. On another worksheet i want to have suggestions of the data on the other worksheet when i fill in some letters in a cell. So if the name "John Doe" exists in the tabel, and i type "J" in a cell on another worksheet...

hi all... i have vlookup question how to fix problem; at first, lookup is fine but...for reason..i move/copy my reference tabel e.g name "kki" then copy/move again name of kki (new data), but vlookup show error.. how to fixed it? any help, thanks.. .susanto

'The object invoked has disconnected from its clients' this problem occurs after having used the VBA without a problem for more than a year. Microsoft appearantly used to have threads about this but they are gone. nothing has changed in the VBA or in the imported txt files. Anybody an idea of...

Dear All, I am new to this forum. I am trying to find a solution for the following; within a tabel with several columns I am trying to find the last row (preferably column with the date for which the last specific value has been found in the table). See attached example. With vertical...

Hi I have a listbox in a userform called listValgteProdukter this listbox have 4 column with data. How can I with a button fill a Tabel on my sheet called ValgteProdukter. The tabel has the name ProductList Thanks for all answers

Hi, I have a file with a bunch of cash books on each sheet, each categorised exactly the same (i.e column S will be the same category on each sheet). I can create a pivot table based on one sheet, but can I do the same adding all the sheets together. https://ufile.io/r7ypb - this is a simple...

Hey everyone i need your help how to add percentage to your line on a pareto tabel EXCEL 2016

Hi, When I try this the red line gives the error: object variable or With block not set. Can someone explain where I go wrong? Thanks in advance! Dim tabel As String tabel = Range("A1").Value For x = 1 To 1000 If ws2.Cells(x, 1) = tabel Then ws2.Cells(x, 1).Select End If Next x