Recent content by NicolaasH

Unfortunately that is going to be too complicated for the people that will be using the sheet. I think I'll go for the VBA solution, although I might have some questions about that too. Thanks anyway! Nick

1) I have a download from an ERP system into Excel. It contains 23 columns. The number of rows varies, since more data is acquired over time. 2) I have an Excel workbook that contains a whole lot of data and worksheets where I manipulate this data. I have a separate worksheet to enter the data...

I believe I did mention that the pasting didn't work....It keeps on saying 'Select destination and press ENTER or choose paste' at the bottom of the screen, but neither does the job.

With some experimentation, I have found out that the problem lies in the fact that the list into which I paste contains a couple of extra columns. These columns contain formulas (date conversion, matching etc.) and I would like to keep them in there. Do you know whether there is a solution to...

I understand what you mean and I did just that- i.e. select the single top most cell of the list. When pasting it actually outlines (cells become selected/blue) where the new data should have come. It does not give an error message when pasting into the topmost single cell. There is an error...

I did that, (tried several things: top left cell, top row, insert row, column name row) nothing like that seems to work.

Hi, I have a List (Listobject) in a worksheet, to which I wish to copy new data. Unfortunately it does not seem to be possible to paste the data when the number of rows in the copied data is larger than the number of rows in the existing list, or when trying to add a range of rows to the bottom...

Hi, Is it possible to change the item number of a list (ListObjects)? I now have 12 lists on one excel worksheet, but since I did not make them in sequence the item numbers are in a random order compared to the sequence on the sheet. I have to compare these lists to other lists in other...

Skip, I don't get it yet, but thanks anyway. I have disgarded the whole idea and solved it differently (I now put everything in an array and with that make the grouping and comparison). Nick

Skip, I have tried that, however, I do not seem to get it translated to usable code. The wizard returns the following: ActiveSheet.PivotTableWizard SourceType:=xlDatabase, SourceData:= _ "'[WW Pipeline Axon January 2008 V5.xls]Pipeline'!R9C1:R297C52" However if I then change the...

Hi, I have a pivot table that is based on a list in a different workbook. Every month this workbook changes its name (new version) and the list changes in length. Since the source workbook changes, using a basic dynamic range is not an option. I therefore have to redefine the source data of...

I have found a solution, be it not a very aesthetic one. I have first determined the absolute row reference of the top of the list and than subtract this from the absolute reference of the selected cell. ListPosition = objList1.Range(1, 1).Row AbsoluteRow = ActiveCell.EntireRow.Cells(1, 1).Row...

Unfortunately it is a problem, because it is not merely copying and pasting. I need the ListRow reference to find a couple of other parameters (this happens in the 'rest of code bit, and the procedure AddRow that is called). To keep the code neat and not run into problems when I move the list...

Yes, I had something like this before, ActiveCell.EntireRow.Cells(1, 1).Row however this returns the row in the sheet, while I am looking for the row in the List, which is a different index different.

Bob, thanks, but could you help me out a little more? I'm not sure how to extract the index number yet, I guess that was actually my question. I now have the following code: Public Sub DuplicateRow() Dim ListWorksheet As Worksheet, objList1 As ListObject Dim SelectedRow As Integer Set...