Search:

Type: Posts; User: simmo7; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.02 seconds.

  1. Pivot Table - show summarized data

    Arcturus 16a,

    In Excel 2007, right click on the field and go to field settings, change from Show item labels in tabular form to show item labels in outline form and make sure both boxes are...
  2. Replies
    4
    Views
    351

    Hi Trevor, Is the report based on an Access...

    Hi Trevor,

    Is the report based on an Access query? If so, I would put a criteria in the query under the order number field as = not null.

    Regards,
    Maria
  3. Replies
    14
    Views
    1,679

    Thanks Maud, This will be very helpful. ...

    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...
  4. Replies
    14
    Views
    1,679

    Maud, I am assuming that if I wanted to use...

    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,...
  5. Replies
    1
    Views
    433

    Dr Dre, I have done something similar to this...

    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...
  6. Thread: Lost Macros

    by simmo7
    Replies
    2
    Views
    377

    Hi, You need to tell the Citrix version of Excel...

    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
    ...
  7. Replies
    4
    Views
    625

    Joel, If you have Excel 2007/2010 you can use...

    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
  8. Replies
    3
    Views
    696

    You can use the Data Consolidate command (Excel...

    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.
    ...
  9. Replies
    4
    Views
    1,496

    Rory, Thanks, your formula worked slightly...

    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
  10. Replies
    4
    Views
    1,496

    Bob, I deliberately did not use F2 as I am not...

    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
  11. Replies
    4
    Views
    1,496

    Pasting a volatile formula in Excel 2007

    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...
  12. Replies
    5
    Views
    1,230

    Pivot Table Question

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

    Regards,
    Maria
  13. Replies
    4
    Views
    4,783

    Howard, Here is a link to some Microsoft help...

    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
  14. Replies
    4
    Views
    4,783

    HowardC, I dragged the Description field down...

    HowardC,

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

    Need help with adding new fields

    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...
  16. Replies
    6
    Views
    971

    Richard, Yes you can share the workbook. In...

    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...
  17. Does the same problem occur if there is actual...

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

    Regards,
    Maria
  18. conditional formatting

    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...
  19. Conditional Format

    Is this what you want (see file attached)?

    Regards,
    Maria
  20. Yes, View ribbon, View Side by Side. You may...

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

    Regards,
    Maria
  21. Replies
    0
    Views
    622

    Excel Commands confusion

    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...
  22. Replies
    19
    Views
    8,134

    Hi, When you first register your tablet with...

    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
  23. Replies
    7
    Views
    877

    Steve, the F5 key is a quicker way to the goto...

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

    Regards,
    Maria
  24. Replies
    5
    Views
    1,947

    Ted, I think part of the problem is that the...

    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...
  25. Replies
    5
    Views
    1,947

    Strange Mouse issue

    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...
Results 1 to 25 of 73
Page 1 of 3 1 2 3