Posts by aslat

  • Add Comma To Each Cell In Column

    Re: Add Comma To Each Cell In Column


    In cell A1 you have your first name (in your case it's Abadie)


    Type in cell B1 =A1&","


    This will result in Abadie,


    Then copy cell B1 and paste it all the way down to Bx (where x is the last cells corresponding to entries in column A


    Then copy all of column B, select edit>paste special and select 'values'...click OK

  • Add Rows When Reference Range Increases

    Re: Adding Rows When Reference Range Increases


    Sorry for the delay..


    After reading 'the golden rules of excel' sticky, I've took your advice and reduced averything to one sheet for all my data, using named ranges


    Thanks mate

  • Add Rows When Reference Range Increases

    I have the following: -


    Sheet1 A1:A20 = account numbers
    Sheet2 A1:A20 = references sheet 1 (=sheet1!A1)


    Sheet2 A21:C21 = Some totals and counts etc...


    The problem is that Sheet1 may increase or decrease in account numbers


    How can automatically add/delete the appropiate rows in sheet2?


    ie. If I only have 15 rows in sheet1, sheet 2 references just the 15 rows and the totals appear on row 16


    Hope I explained well enough

  • Bulk Email From Query

    I have a small database that I'm building for my local cricket team. The main contacts table is entered via a form that has various check boxes to indicate the roles of each player (umpire, main team, bowler, batter etc)


    I've managed to set up simple queries that lists all the umpires, main team members, bowlers, etc...


    How do I pull the just the email addresses from the 'umpire' query and have them placed in my email software ?


    Thanks in advance

  • Greyed Out On Not Ticking Checkbox

    Hi


    I have 4 check boxes on a Access Form.


    If someone checks the 4th box, I would like a text box to become available for user input, else the text box 'greyed out'


    Please can someone point me the right direction....

  • Automatic Unique List

    Re: Automatic Unique List


    Initially, this doesn't work...I get the dreaded 'Run time error 13'


    If I click on 'END' and start entereing data in column A, then it works...


    any ideas how to stop the initial Run time error?

  • Automatic Unique List

    Hi again..


    Is there anyway of automatically creating a unique list as data is being typed?


    In column A:-


    123
    123
    1234
    1234
    1235
    1235


    In column B
    123
    1234
    1235


    As the data is entered in column a, column B is poulated with the unique values?


    I know all about Advanced Filter>unique list but I really wanted to avoid the extra step

  • Set Print Area From Dropdown List

    Re: Set Print Area From Dropdown List


    Thanks guys. I used a bit of both.


    Its sort of working :(


    When it selects two separate ranges, it always prints on two pages. I can't for the life of me get it to print on the same page.

  • Set Print Area From Dropdown List

    Re: Set Print Area From Dropdown List


    I understand the first macro but don't know how to incorporate it into my sheet.


    I'll try and explain again: -


    I have a named range called 'print_area' containing Print Area 1, 2 and 3
    In A1, I have a data-validation drop down list that is populated from 'print_area'


    If print area 1 is chosen from the dropdown I would like it to print a specific range and so on...


    Hope this is a better explanation.

  • Set Print Area From Dropdown List

    HI (again)


    Is it possible to set a print area and then actually print it according to what is chosen from a dropdown list ?


    Ie
    If 'Print area 1' is chosen, it selects A5:D50 & A5:L50 and then prints
    If 'Print area 2' is chosen, it selects A5:D50 & M5:S50 and then prints


    and so on...


    Thanks in advance

  • Estimated Finish Time Of Project

    Re: Estimated Finish Time Of Project


    KJ


    Thanks for that.


    I included a rounddown to get the total number of whole 7-hour days and then incorporated the whole lot for the final result.


    Thansk for your time...