Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.04 seconds.

  1. Thread: Excel tables

    by zeddy
    Replies
    24
    Views
    688

    Hi ..I was expecting someone to report how I...

    Hi

    ..I was expecting someone to report how I had goofed up and forgotten to do the Totals on the [ Tally(total) ] sheet, in the sample file I posted in post#24. And how it was easy to put an...
  2. Thread: Excel tables

    by zeddy
    Replies
    24
    Views
    688

    Hi Maud I used a bit of your stuff in my...

    Hi Maud

    I used a bit of your stuff in my version.
    (You accidentally repeated cells [D4] and [E4] on your sheet [Index] )

    Now, I had a bit of trouble with that French stuff, so I decided to...
  3. Replies
    7
    Views
    152

    Hi Lou ..just as a matter of interest, save a...

    Hi Lou

    ..just as a matter of interest, save a copy of the file in .xlsb format.
    What size is it then????

    (NOTE: Excel .xlsb files can have macros in them)

    zeddy
  4. Hi When setting up the rule for [c37] you need...

    Hi

    When setting up the rule for [c37] you need to remove all dollar signs from c37 as well.
    see attached sample file.

    zeddy
  5. Replies
    17
    Views
    494

    Hi Harry many thanks for your thanks. Nice...

    Hi Harry

    many thanks for your thanks.
    Nice website! Stunning pics.
    Those photo fades have made me dizzy.
    It's like trying to read Tequilla Mockingbird.

    zeddy
  6. Thread: Excel tables

    by zeddy
    Replies
    24
    Views
    688

    Hi RG OK - your post19 fixes my item 2!! ...

    Hi RG

    OK - your post19 fixes my item 2!!

    zeddy
  7. Thread: Excel tables

    by zeddy
    Replies
    24
    Views
    688

    Hi RG A couple of observations with your file...

    Hi RG

    A couple of observations with your file in post#14
    1. right-click will also toggle the tick on/off in the cell.
    This may not be what you want to happen.
    2. If you select the name...
  8. Hi Welcome to the Lounge! When you set up...

    Hi

    Welcome to the Lounge!

    When you set up the rule for [c37], remove the default dollar signs from the D37 reference.
    This will make it a 'relative' formula, which will then automatically...
  9. The point I was making was, if you delete the...

    The point I was making was, if you delete the contents of the dropdown cell, you could have the adjacent cell cleared automatically as well.
    Also, if you have already selected say, 3, from the...
  10. Replies
    17
    Views
    494

    Hi Harry Answers to your questions: 1. In the...

    Hi Harry

    Answers to your questions:
    1. In the file you supplied, there are many blank rows interspersed with data rows. My first method used [a1].CurrentRegion to 'grab' the data block to be...
  11. Replies
    8
    Views
    203

    Hi Maud I will certainly use it. Nice code. ...

    Hi Maud

    I will certainly use it.
    Nice code.

    zeddy
  12. Replies
    17
    Views
    494

    Hi hmw ..it was a lot easier to fix with your...

    Hi hmw

    ..it was a lot easier to fix with your sample file.

    Try the updated attached file.

    zeddy
  13. Replies
    8
    Views
    203

    Hi RG ..a very nice solution! ..I would add...

    Hi RG

    ..a very nice solution!

    ..I would add a line..
    sht.Visible = True

    before..
    sht.Activate
  14. Replies
    8
    Views
    203

    Hi Maud Aha! Sort of. After carefully reading...

    Hi Maud

    Aha! Sort of.
    After carefully reading the first post, what we have is ~50 sheets, each with a unique 'ITEMCODE' in cell [A1] on each of the sheets.

    So rather than using a search...
  15. Replies
    8
    Views
    203

    Hi alyhaye ..are there any hidden...

    Hi alyhaye

    ..are there any hidden worksheets????
    ..are all worksheets visible???

    zeddy
  16. Replies
    17
    Views
    494

    Hi hmw Maud has shown how you can add a macro...

    Hi hmw

    Maud has shown how you can add a macro to your Personal Macro Workbook.

    Another way is to load a particular workbook that will do that particular job.
    The attached .xlsm macro file is...
  17. Replies
    19
    Views
    628

    Hi Lou That's great news for us. When you buy...

    Hi Lou

    That's great news for us.
    When you buy your tickets, you are buying the dream.
    And that is worth the price.

    Don't go swimming without a beach guard on duty, and don't use an umbrella...
  18. Replies
    19
    Views
    628

    Hi Lou ..just give him an extra thank you...

    Hi Lou

    ..just give him an extra thank you click then.

    We will miss your posts here if you get that $100million ticket.

    zeddy
  19. Replies
    19
    Views
    628

    Hi Lou ..I think Maud should get a share of...

    Hi Lou

    ..I think Maud should get a share of the winnings then.

    zeddy
  20. Replies
    17
    Views
    494

    Change ActiveSheet in Maud's code to sht to allow...

    Change ActiveSheet in Maud's code to sht to allow for different number of data rows on each sheet.

    I prefer the simplicity of pre-Excel2007 sorting methods (which still work) if the sorting...
  21. Replies
    27
    Views
    857

    Hi Ferenc ..I just realised it is the...

    Hi Ferenc

    ..I just realised it is the cellpointer location you are talking about.
    It is a minor fix, I just need to add a line..
    Target.Select
    ..in each of the sheet change routines:
    sheet...
  22. Replies
    27
    Views
    857

    Hi Ferenc ..when a record is moved to a sheet,...

    Hi Ferenc

    ..when a record is moved to a sheet, it is appended to the bottom of the sheet. The records are then sorted.

    I'll have another look and report back tomorrow - I'm on combat duty at...
  23. Hi Maud I like your SUMPRODUCT method best! ...

    Hi Maud

    I like your SUMPRODUCT method best!


    =SUMPRODUCT((E2:G9511)*((B2:B9511=2009)*(C2:C9511=1)*(D2:D9511=1))) ..if you want to start from row2

    ..and welcome to this Lounge PJ

    zeddy
  24. [SOLVED] Hi Jaggi It would be easier to work with a...

    Hi Jaggi

    It would be easier to work with a sample file.
    You could put dummy data in the sample file - we are not interested in any sensitive data.
    I can make some improvements in the code.

    Do...
  25. Replies
    27
    Views
    857

    Hi Ferenc Welcome to the world of conditional...

    Hi Ferenc

    Welcome to the world of conditional formatting nightmares! Every time you copy and paste within a range that has conditional formatting, a new 'rule' is created for the worksheet....
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4