Replies

light bulb – bing bing bing

I was not connecting the true = 1 and false = 0 so could not see how the multiplication worked.

I get it now!!!!

Another excellent formula in Excel

thanks again

thanks Hans – that works great.

Now I just have to understand why it works so I can teach others who will use the sheet I am making.

thanks Hans

Err total novice user of Access here.

Where do I put your code?

I tried the event on change and it does not seem to do anything.

thanks Hans

Err total novice user of Access here.

Where do I put your code?

I tried the event on change and it does not seem to do anything.

Hi Hans

thanks for the assistance with this. That is working wonderfully.

Hi Hans

thanks for the assistance with this. That is working wonderfully.

When I do that I get the message that you can only copy filtered data to the active worksheet.

Hi there

thanks for the link.

Yes it answers the question, but I do not know how to use the feature and the help is confuising.

What is the criteria to eliminate duplicate customer names that would be in column A?

Thanks for the assistance this looks like it should do the trick.

Hi there

Thanks for the advice. We do not have Novell. Our server is Msft small business server.

I have an XP client. 5.1 build 2600

Domain worked. What is the difference?

Thanks for the assistance / knowledge!

Where did you go to tell that?

How do I turn it off?

If I start word then it does not open Excel. It is only when I access that one file. Yes I am referring to the status bar.

I have zipped the file and attached here.

The file is too big.

Hi Phil

I ran a virus scan, complete with macro virus check. My PC is clean.

It is not happening with all word documents, just one in particular. If I save that one as something else then the something else is also doing it.

It is actually opening Excel. As word opens there is text at the bottom left of the screen that scrolls by quite quickly. One of the things is a call to the Excel file that is opening.