Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds; generated 14 minute(s) ago.

  1. Thread: formula help

    by zeddy
    Replies
    4
    Views
    86

    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
  2. Replies
    6
    Views
    123

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

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

    Hi Howard

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

    zeddy
  4. 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
  5. Replies
    7
    Views
    389

    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...
  6. 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:

    ...
  7. Replies
    7
    Views
    389

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

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

    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,...
  10. Replies
    11
    Views
    359

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

    Hi Steve

    ..you were quicker than me, again.

    zeddy
  11. Replies
    11
    Views
    359

    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....
  12. 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
  13. 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
  14. Thread: Table Headers

    by zeddy
    Replies
    2
    Views
    138

    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...
  15. 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:...
  16. 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 /...
  17. 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...
  18. Replies
    4
    Views
    302

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

    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...
  20. 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...
  21. 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
  22. Replies
    15
    Views
    477

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

    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
  24. Replies
    3
    Views
    206

    Hi Steve/Maudibe Many thanks for your...

    Hi Steve/Maudibe

    Many thanks for your suggestions. Top marks! I'll use both.

    In the existing version, the source was being copied using the Cells.Copy command.
    I had to include a vba section...
  25. Replies
    3
    Views
    206

    Replace a worksheet currently in use

    Hi All

    I have a worksheet [FRED] that is being referenced in formulas on other sheets.
    I would like to replace this entire sheet with a copy of another sheet, [MARY].
    I could just delete the...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4