Search:

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

Page 1 of 20 1 2 3 4

Search: Search took 0.06 seconds.

  1. Replies
    17
    Views
    1,405

    Hi RG ..I believe it shows up to 15 sheet...

    Hi RG

    ..I believe it shows up to 15 sheet names directly in the list.
    For more than that (e.g. 50 sheets), you see a scrollable list box.
    If you 'move' sheets, the list shows current sheet tab...
  2. Replies
    17
    Views
    1,405

    Hi Maud ..your original solution does...

    Hi Maud

    ..your original solution does everything that was asked for.

    One of the reasons a person may want to use such a method of switching to a sheet tab, is because they cannot directly 'see'...
  3. Replies
    9
    Views
    455

    Hi Brian ..you still get a 'Thanks' from me...

    Hi Brian

    ..you still get a 'Thanks' from me for your good manners, and politeness, and graciousness, and courtesy, and you get my respect for admitting you learnt something you didn't know before....
  4. Replies
    17
    Views
    1,405

    Hi Andrew ..that works great provided the...

    Hi Andrew

    ..that works great provided the double-clicked cell corresponds to a sheet that is not hidden.
    ..You could end up unintentionally on a different sheet otherwise.
    ..or even in Edit-mode...
  5. Replies
    7
    Views
    265

    Hi ..it would have been easier if you posted...

    Hi

    ..it would have been easier if you posted the sample file first.
    ..Then Maud would know your column [A] is empty.
    ..and there isn't an 'Agent' row after the very last block to be deleted....
  6. Hi Meleia This attached file uses just...

    Hi Meleia

    This attached file uses just formulas and named cells. The numbers are the same as Maud's vba results.

    Essentially, we can total all the units for each of the site types.
    We can then...
  7. Replies
    16
    Views
    756

    Hi The problem was related to how the named...

    Hi

    The problem was related to how the named range [listSuppliers] was being updated (in the vba code), when you added a new Supplier.

    I have now corrected this by assigning [listSuppliers] as...
  8. Replies
    9
    Views
    455

    Hi Brian ..in my post#5 file, I dealt with the...

    Hi Brian

    ..in my post#5 file, I dealt with the issue of the months that don't have 31days in them. You were on the right track by 'hiding' the relevant data items (but didn't 'hide' the actual...
  9. Replies
    9
    Views
    455

    Hi Brian see attached file for a fix. ...

    Hi Brian

    see attached file for a fix.

    Checking the x-axis date range is the same for each of the chart series:
    Chart1: Right-click on the Chart>Select Data
    In left-pane it shows the names of...
  10. Hi Meleia ..I am looking at three methods of...

    Hi Meleia

    ..I am looking at three methods of 'distributing' the 'cost' across the sites based on weighting % and site type.
    I need to think about this a little more before I post my...
  11. Replies
    16
    Views
    756

    Hi Top marks for making the date changes in...

    Hi

    Top marks for making the date changes in row 10, putting it back to Calendar year layout.

    Re: cell [A8] on sheet [Weekly Supplier Report]
    The date is driven by the week clickers
    If you...
  12. Replies
    20
    Views
    759

    Hi RG ..I remember you teaching that to me a...

    Hi RG

    ..I remember you teaching that to me a while ago.
    But I never new the noparse was temper mental

    zeddy
    •Excel Spaced Out Trooper
    .
  13. Replies
    9
    Views
    455

    Hi Brian ..you may have noticed in my example,...

    Hi Brian

    ..you may have noticed in my example, I used the INDEX function to get the chart data.

    zeddy
    •Excel Index Association
  14. Replies
    9
    Views
    455

    Hi Brian ..instead of using a Form for the...

    Hi Brian

    ..instead of using a Form for the selection, you could use 'sliders' to select the Month and Year.
    And by using formulas to 'get' the relevant data for the Chart, you can avoid the VBA...
  15. Replies
    20
    Views
    759

    Hi David ..did you see an empty...

    Hi David

    ..did you see an empty \AutomaticDestinations folder then???

    zeddy
    •Excel Tactical Surveillance Support
    .
  16. Replies
    20
    Views
    759

    Hi RG ..tried that noparse decoder code but...

    Hi RG

    ..tried that noparse decoder code but honestly, it had no effect!! go figure. Try copying it into one of your own posts and see what you get

    zeddy
    •Excel Whatshappening
  17. Replies
    22
    Views
    926

    Hi Howard ..many thanks for your thanks. I...

    Hi Howard

    ..many thanks for your thanks. I appreciate that!
    ..and I'm glad you liked the tool. I liked the calendar form especially.

    zeddy
    •Excel Eastern Hemisphere SkyWatcher
    .
  18. Hi Meleia OK, it makes more sense now. Mostly....

    Hi Meleia

    OK, it makes more sense now. Mostly.
    ..Let me think of an elegant formula, and I'll post it back tomorrow.

    zeddy
    •Excel Gigabertz Uploader
    .
  19. Replies
    20
    Views
    759

    Hi RG ..so is that a proper thanks I get...

    Hi RG

    ..so is that a proper thanks I get then??
    ..and how do I get rid of that pesky space in
    %AppData%\Microsoft\Windows\Recent\AutomaticDestinations

    zeddy
    •Excel Fancy Goods Chandler
    .
  20. Hi Meleia ..you need to have a rethink about...

    Hi Meleia

    ..you need to have a rethink about this.
    Suppose I gave you a formula as you ask.
    And then I change all the Site Types to A.
    If you imagine that you only have A's in your list, then...
  21. Replies
    22
    Views
    926

    Hi Howard re my post#12 ..I added some...

    Hi Howard

    re my post#12


    ..I added some lines to 'kill' any pre-existing file of the same name in the destination folder, before moving the file.
    ..of course, this means that for all files...
  22. Replies
    20
    Views
    759

    Hi As Maud said in post#2, it's an issue...

    Hi


    As Maud said in post#2, it's an issue with Windows. Specifically, with the Windows Registry.

    So to start with, make sure that, in addition to the two items mentioned by Maud in post#2,...
  23. Replies
    16
    Views
    756

    Hi It's a case of understanding how the Tool...

    Hi

    It's a case of understanding how the Tool currently works. First of all, you can see all the entered records for any chosen Supplier by using the [Filters On/OFF] button on sheet tab [Delivery...
  24. Replies
    22
    Views
    926

    Hi Howard ..there are many reasons why a...

    Hi Howard

    ..there are many reasons why a problem can occur when moving files. On a positive note, having the 'audit' file listing with the status has proved useful! Better than having just a...
  25. Replies
    19
    Views
    691

    Hi boo ..you are right to spread out the...

    Hi boo

    ..you are right to spread out the calculations so others can see the steps.
    It's not always about compressing everything into the smallest number of steps or most complex formulas.
    For...
Results 1 to 25 of 500
Page 1 of 20 1 2 3 4