Recent content by henio

Hi Boris, I am trying to install sqlexpress 2005 on a non-networked Vista laptop. There didn't appear to be any errors during the installation, but it doesn't look as if there is an instance running, so I can't connect to anything other than the mysterious 'SQL Server Compact Edition'. Do I...

Skip, I was truly importing data - just never noticed that option. You're a star. h

Hi, I'm having problems importing a delimited file (c10k rows) into Excel 2003. Below is a simple example using the pipe as a delimiter (you can guess this data comes from a mainframe report). 003.1270|aaa|bbb |12.00 AA|AAA|BBB|17 I formatted all cells as text prior to the import. The issue...

Hi, I'm using Word2003. Is there any way of viewing only changes made on a certain date? I've tried to save a changed document as a new version, but when I look at the changes I see ALL changes made rather than just the changes made in the latest version.

Dear STU1979, Your original posting said you wanted the same table at the start and end of the document. If the table formats are different you could still do the table copy and paste and record a macro to reformat the second table.

How about select table, edit copy, edit paste? How long can this take?

Hi, put the department in the row and data areas. In the data area set the function to COUNT of departments. hth Henio

Hi, try creating a pivot table - your subtotals will all appear together. Henio

Hi shteev, if your summary sheet contains lots of SUM functions, replace them with SUBTOTALs. These will sum, count, etc whatever you have filtered. hth henio

Thanks Patrik, you deserve a star. Regards, henio

I agree with all the comments about 'password protection' but still use it to stop people with even less knowledge than me from tinkering, getting the wrong answers and blaming me to other people!!! On a related issue, many of my macros run a query to extract data from a host database, and then...

Hi 01Patrik, I normally use the technique you suggest with no problems. I just tried something different and ran into this situation. I'm just curious... henio

Hi all, I have created a custom toolbar with two buttons which run a couple of macros. It works fine for me but when I email the file to colleagues, they don't see the toolbar. It doesn't appear on the list of toolbars available. I've searched for information about this and just got...

Hi, you need to use the INDEX and MATCH functions. eg sheet1 colA ID Acct Amnt 10 100 =index(=INDEX(Sheet2!$A$1:$D$2,MATCH(Sheet1!A2,Sheet2!A:A,0),MATCH(Sheet1!B2,Sheet2!$A$1:$D$1,0)) will return 1 sheet2 colA ID 100 200 300 10...

Hi, Thanks to all of you for replying. I tried Combo's solution first so s(he) gets my star. There seem to be so many ways of doing anything - I need to buy a good VBA book... Cheers Henio