Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: office 2003

    by zeddy
    Replies
    7
    Views
    124

    Hi I have four versions of Office installed on...

    Hi

    I have four versions of Office installed on my laptop.
    I don't have any problems.
    Latest versions of Office install allows you the choice to 'keep' previous versions, if you wish. (You can...
  2. Replies
    15
    Views
    1,021

    ..or you could also enter E2...

    ..or you could also enter
    E2 =IF(MIN(C2,D2)>3,"Bonus","")
    ..and copy down

    zeddy
  3. Thread: formula help

    by zeddy
    Replies
    4
    Views
    113

    Hi Another way is to use this custom format on...

    Hi

    Another way is to use this custom format on the column:
    mm"/1/2014"

    This will keep the start date value, but will display it as the Anniversary date.

    zeddy
  4. Replies
    6
    Views
    188

    Hi RG/Arcturus You don't need to use Access. ...

    Hi RG/Arcturus

    You don't need to use Access.

    I opened the file, and created a simple pivot table on an empty sheet.
    I used entire Column [B] Account# as my data source.
    I chose Account# as my...
  5. Replies
    7
    Views
    417

    Hi Howard ..now back at home. Did you check...

    Hi Howard

    ..now back at home.
    Did you check previous posting out?

    zeddy
  6. Hi Steve Another way could be to use formulas...

    Hi Steve

    Another way could be to use formulas and Excel's camera tool.
    see example attached.

    zeddy
  7. Replies
    7
    Views
    417

    Hi Howard ..the flight was OK, but next day I...

    Hi Howard

    ..the flight was OK, but next day I was admitted to hospital again. Internal gunk removed. Still here. Nothing major. More ops to come.
    Apologies for delay.

    I have attached an...
  8. Hi Mattock12 ..welcome to the Lounge! You...

    Hi Mattock12

    ..welcome to the Lounge!

    You just need to adjust your formula to subtract 1 if there are any "No DT" in the range, so use this:

    ...
  9. Replies
    7
    Views
    417

    Hi Howard ..oops! I just attached what the...

    Hi Howard

    ..oops! I just attached what the newest file (but from the wrong folder!)
    I did it again.
    ..here it is.

    leaving shortly!

    zeddy
  10. Replies
    7
    Views
    417

    Hi Howard I have modified your code slightly -...

    Hi Howard

    I have modified your code slightly - I'm sure you will see the changes I made.
    see attached.

    I added a Worksheet Activate routine for sheet [Br1]
    When you switch to sheet [Br1], the...
  11. Replies
    4
    Views
    292

    Hi Trying to preserve existing filters after...

    Hi

    Trying to preserve existing filters after 'refreshing' data can be unreliable depending on the type of filters you are using.
    For example selected ranges (xlTop10Items, xlBottom10Items,...
  12. Replies
    11
    Views
    414

    Hi Steve ..you were quicker than me, again. ...

    Hi Steve

    ..you were quicker than me, again.

    zeddy
  13. Replies
    11
    Views
    414

    Hi Kerry First of all, when using lookups or...

    Hi Kerry

    First of all, when using lookups or match, you must compare apples with apples, i.e. if your cost center value is 'text' in your extract, then it must match a text value in your source....
  14. Hi Martin I could tell from your accent. So...

    Hi Martin

    I could tell from your accent.
    So I'm assuming you're on the Trans-Siberian express.
    Didn't know they had wi-fi on that.

    zeddy
  15. Hi Martin ..why not just go to Leeds? (it's...

    Hi Martin

    ..why not just go to Leeds?
    (it's twinned with Ulan Baator)

    zeddy
  16. Thread: Table Headers

    by zeddy
    Replies
    2
    Views
    160

    Hi rvWoody You can hide specified dropdown...

    Hi rvWoody

    You can hide specified dropdown filter arrows using VBA as follows:



    sub hideMyFilter()

    [a1].currentregion.AutoFilter Field:=3, VisibleDropDown:=False '3=column [C] = third...
  17. Hi This is standard 'auto-correct' behaviour....

    Hi

    This is standard 'auto-correct' behaviour.
    In Excel 2007, typing three consecutive full-stops will be replaced by the single ellipsis character.
    If you want to turn this off, in Excel 2007:...
  18. Hi RG I took your xlsb file, deleted all the...

    Hi RG

    I took your xlsb file, deleted all the code, changed it to a .xlsx file, and just added another format rule to the data range.
    I toggled this rule to a cell setting (i.e. to make an ON /...
  19. Hi Farrukh See attached file for one method of...

    Hi Farrukh

    See attached file for one method of returning data based on matching the lookup entries in two columns.
    I combine the two columns into one lookup code on each sheet, in an adjacent...
  20. Replies
    4
    Views
    341

    Hi Tom, Steve & RG Many thanks for your...

    Hi Tom, Steve & RG

    Many thanks for your responses.
    I thought I might start with looking at what's on the left-hand side of any equals sign, as in..
    xxxxxxx = whatever

    ..and perhaps look at...
  21. Replies
    4
    Views
    341

    listing variables used in a vba routine

    Hi

    If I wanted to properly document a vba routine, I would find it very useful if there was a utility that could list all the variables used in each subroutine in a vba module. If everyone used...
  22. Hi RG re "Note: the ## are just because I...

    Hi RG

    re "Note: the ## are just because I didn't adjust the row width for large numbers"

    I know you meant 'column width'. So how about adding something like this :




    'We cannot just use...
  23. Hi Beryl ..have a look at the attached file....

    Hi Beryl

    ..have a look at the attached file.
    I added some columns to simplify things.
    The formulas are now simpler.

    If you have any questions, please ask.

    zeddy
  24. Replies
    15
    Views
    507

    Hi Maudibe ..heh heh. I knew you knew that....

    Hi Maudibe

    ..heh heh. I knew you knew that.
    ..I was waiting for Alan to discover that Font.ColorIndex = 1 is for black.

    zeddy
  25. Replies
    15
    Views
    507

    Hi ..you could use something like:...

    Hi

    ..you could use something like:
    rcell.Offset(0, 1).Font.ColorIndex = 3

    ..where 3 will give you Red

    zeddy
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4