Search:

Thanks Maud,

This will be very helpful. Quite often, I need to hide empty columns after I have deleted some content and then unhide them after I have printed out the content I need. I can't...

Maud,

I am assuming that if I wanted to use this code to hide empty columns rather than delete them, then I would change line 5 of your code to read Then ActiveSheet.Columns(I).Hide

Regards,...

Dr Dre,

I have done something similar to this in MS Access. What I did was pasted a document (in your case it would be a .jpg file) into a blank report, then inserted fields where required over...

Hi, You need to tell the Citrix version of Excel 2007 where to find your personal.xls file in Excel Options - Advanced -General - at startup load all files in {drive name}.

Merry Christmas
...

Joel,

If you have Excel 2007/2010 you can use Data, Text-to-Columns. All you need to do is specify what delimits the text.

Regards,
Maria

You can use the Data Consolidate command (Excel 2007). Have all quarterly sales worksheets open and in a new file use the Data Consolidate to combine them. You can add references as needed.
...

Rory,

Thanks, your formula worked slightly quicker than mine. I had thought about using INDIRECT, but could not remember how to set the reference.

Regards,
Maria

Bob,

I deliberately did not use F2 as I am not always pasting into row 2, by using the column my lookup worked perfectly.

Regards,
Maria

I am pasting the following formula into a sheet - =VLOOKUP(D2,'Lookup current policies.xlsx'!ExpiryDates,2,0). Once I have it in the sheet and location I want, is there any way of Excel knowing what...

Hopefully this is what you want. I have often used pivot tables to count yesses and noes or Trues and Falses.

Regards,
Maria

Howard,

Here is a link to some Microsoft help for pivot tables.

http://office.microsoft.com/en-au/excel-help/results.aspx?filter=1&ck=1&av=zxl120&qu=Pivot Tables&ex=2

Regards,
Maria

HowardC,

I dragged the Description field down to the Values area and it defaulted to count. Hopefully this is what you wanted.

Hi all, I have a database that includes the table structure shown in my attachment. My questions are as follows.

1. If I add a field called Date_Further_Info_Reqd, then is it possible to auto...

Richard,

Yes you can share the workbook. In Excel 2007 use - Review, Share Workbook - prior to this you can use Protect Sheet and a password if you want some areas restricted. In Excel 2003...

Does the same problem occur if there is actual data on more than one page?

Regards,
Maria

I don't know why you can't change the font, perhaps you don't have wingdings installed?? I have changed to Arial Font, hopefully this is now OK for you.

Also I missed one step, first you select...

Is this what you want (see file attached)?

Regards,
Maria

Yes, View ribbon, View Side by Side. You may also need to reset the window position to see the effect.

Regards,
Maria

In Excel 2007 there are the following 2 commands.

View, Save Workspace
Office Button, Publish, Create Document Workspace

These 2 commands work in very different ways, does anyone know why...

Hi,

When you first register your tablet with the Android Market, it then knows what device you have and will tell you if the app is not compatible.

Regards,
Maria

Steve, the F5 key is a quicker way to the goto special command - I use it all the time

Regards,
Maria

Ted,

I think part of the problem is that the mouse in question is what you might call an el-cheapo bought off the internet. My dearer Logitech & Microsoft meeces tell me when the battery is...

Hi all, I had a strange issue with my bluetooth mouse this morning when I powered up my laptop. The cursor moved in the opposite direction that I moved the mouse. I unplugged and replugged the...

Hi,

See my attached file, I created a lookup listing of all the sheet names with a link to the relevant cell to find the maximum in - I then used the Max function on this list then used a lookup...

Susan,

Would you be willing to upload your file? If you have sensitive data, I suggest you replace it with dummy data. Once you have uploaded your file I can have a look at it in Excel 2007.
...