Search:

I realy thought that I tried that one. Thanks a lot.

When I create a report I can choose the cross-tab query but I don't know how to create the same layout as the query.

Hi,

I have a cross-tab query which I want to put in a report. I cannot find a way to get this done. Can anyone give me the steps to follow?

Regards Marcel

Hello,

I have tested the feature for using mail-merge by e-mail and all is wordking OK. There is just one problem. When you use this feature the sending e-mail account is the default e-mail...

Thanks Rory,

Works great.

Marcel

Hi Rory,

I had a great laugh. What a simple solution.

But... I need this automated so I thought well lets record a macro. It turns out the macro did not record anything at all. Can you help me...

Hello,

I have a workbook that has 3 links to a MS Access database. I created them with ms query. Now I need to create a "frozen" situation.
This means that the data will still be available but...

Hi Hans,

I was expecting such a thing. I will try.

Thanks Marcel

Hi,

For analyzing data I need to go from a formatted list back to raw data. Please see the attached file for an example of the data i received and the way I need it. I know I can copy down the...

Ok that is clear.
To bad I will solve it differently.

Thanks Marcel

Hi Hans,

I used this item in the sheet I am working on right now. See other posts of me this and last week.

I have used it once and it works like a charm. But the second time it did not work.
...

Oops my error. I had 2 columns in the MATCH part of the formula.

Regards Marcel

Hi Hans,

I tested it and it worked like a charm on the example sheet I send. But in the real situation it does not work.
In the real situation the output is on a different sheet as the source...

Hi Hans,

Thanks for your very fast answer. Very clear as allways.

Regards Marcel

Hi,

See attachment for an example
I have a table of data which I use for a VLOOKUP. The problem is that one result should be the row above the result for another VLOOKUP. Since I already can find...

Hi Hans,

Thanks for the explanation. I tried the array but without the multiplying and sum as the logical test.
The extra rows is a trick I use often. I just wanted to be sure I did not miss...

Hi Hans,

Thanks for the answer.

Can you explain in simple words why this formula only works as an array formula and not as a normal formula?

The advise you give me for an extra row is I...

Hi,

Please see attached file for an example.

I have to use a sum on a column where there is a possibility that one of the cells contains text in stead of numbers. It could happen to all the...

Thanks for the help Hans

Hi,

I am looking for a textbook on how to use VBA. I have been exploring possibilities through the macro recorder and I love the possibilities. but I want more. <img src=/S/burnup.gif border=0...

Hi Hans,

Thanks for the answer. I was pulled from my project for a view days because of busy times. So sorry I did not reply sooner.

Regards Marcel

Hi,

I have to do a conditional sum which has several conditions.

For the complete situation see the attached file.

The evaluation what should be done is as follows:

If count of a...

Hi Hans,

I can understand this. It does seem easier then my code. But as I said I have little VBA knowledge. Thanks for the help.

Regards Marcel

Hi Hans,

Thanks for the quick answer.

Can you give me a short explanation of what the 3rd line does?

I forgot to mention that the cell where the formulas go are empty when the fill command...

Hello,

I am trying to create a macro which will enter specific formulas in specific columns. The number of rows will vary each the macro is used. I need some way to determine the last row so I can...