Replies

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,
Maria

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 the top. You should be able to place your fields correctly this way. Once you have tested the placement of your fields, you can delete the .jpg picture from the background and simply leave the fields as placed, then save your Report for future printing.

Regards,
Maria

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

Regards,
Maria

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.

Regards,
Maria

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

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.

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 use – Tools, Share Workbook – prior to this you can use Tools, Protection, Protect Sheet and a password if you want some areas restricted.

I have noted in the past that some forum members actively discourage workbook sharing as files can get corrupted, however, I have several workbooks that get shared on a weekly or monthly basis between about 2 dozen users at a time, with very few problems most of the time, the occasional file does get corrupted and I then have to recreate the file which is a pain in the neck.

Regards,
Maria

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 the range that needs the conditional format, then you Choose Use Formula to determine Format and enter the formulae that determines the format, then click on format and choose the relevant format for that formula. for example = $C2>$B2 then format cell fill = Red. = $B2>$C2 format cell fill = Green. = $b2=$c2 format cell fill = Yellow.

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