I would like to have my data displayed in a different worksheet

Hi in the example I post the sheet ''gegevens'' is normally connected to a database which I can refresh. Now I would like for instance to have the data in the column ''OFFERTENUMMER'' on sheet gegevens to be displayed on the column ''OFFERTENUMMER'' in the sheet ''€'' so that when I refresh the data on the sheet gegevens and other offertenummers are displayed the column ''OFFERTENUMMER'' on the sheet € changes with it.

Let me try to explain further in this new example.

I displayed the ''OFFERTENUMMER'' on the sheet ''€''. But I would like if I have 25 or 50 or 100 items in the column ''OFFERTENUMMER'' that my table size changes with it. Now the last 3 cells give an error instead of closing the table

Hi there,

I had prepared this on the basis of the first workbook you posted. I haven't yet looked at the second version

Take a look at the attached version of your workbook and see if it gets things moving in the right direction. It uses the following code:

Please Login or Register  to view this content.

The highlighted values may be altered to suit your requirements.


Hope this helps - please let me know how you get on.

Regards,

Greg M

Hi again,

The attached version of your second workbook might help.

A minor change to the "ResizeTargetTable" routine has been incorporated.

Some of the header texts (OFFERTENUMMER2, OMSCHRIJVING and status3) on the target worksheet have been slightly modified to make them consistent with the header texts on the source worksheet,

Hope this helps.

Regards,

Greg M

Hi again,

I guess it has something to do that my database has 44200 rows?

It does indeed! That value will cause an Overflow error because the variable which holds the number of rows is declared as being of type Integer (maximum value = 32767).

The code in the attached workbook declares the above variable as being of type Long - this should overcome the problem.

Regards,

Greg M

Thank you I changed it to long. Now I dont get en error anymore but it is loading like for ever.. Is that because it is so much data or what might be the problem

loading.png