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...
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...
Hi,
I would like to ask the following:
How do I detect in which row of a list (ListObject) a selected cell is?
Purpose:
I would like to enable the user to select a cell or row in a list and then they have the option of 2 buttons:
Duplicate Row - the row gets copied and added at the bottom of...
Skip, I guess your anwer is: bad luck, there is no solution?
The big deal is that I estimate it to be at least 3 hours work to change everything in different workbooks, worksheets and a whole lot of VBA procedures, while at the same time I thought I had finished my work....
thanks anyway
Nick
The first row in the List is hidden because it has default information that I copy to new rows (using VBA).
I realise that I could have placed this information somewhere else, but changing this now is a lot of work (code adaptation). Unfortunately I only just found out that these rows become...
Hi,
I have an Excel workbook in which I use an autofilter.
Some of the rows in the list always have to remain hidden. However, when I hide a row, or give it a height of 0, these rows reappear again if I use the Autofilter (All) selection or Filter-> Show All
I also use VBA code to show all...
Hmmmm, no doesn't help.
The weird thing is that if I do not have this file installed I (and other users) get the message:
Compile Error: Can't find project or library
and it highlights the Chr(10) method in the code below. I cannot remember how I found out that installing the BTXPPanel...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.