Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How do I copy cells, down, efficiently?

Discussion in 'Information Technology' started by Keyser, Jul 28, 2006.

  1. Keyser

    Keyser
    Expand Collapse
    Guest

    I'm trying to copy information in cells of a single column down quite a ways,
    and I would rather not (ctl v, d arrow) all the way down. Does anyone have
    any suggestions?
     
  2. Loading...

    Similar Threads Forum Date
    Opinion Akal Takht concerned on drug addiction, copying during exams Breaking News Nov 5, 2013
    SciTech New Quantum Dot Technique Combines Best of Optical and Electron Microscopy Breaking News Jun 17, 2013
    India Copy of 48th Rreport of 'LOKPAL BILL 2011' Presented in Parliament Breaking News Dec 10, 2011
    Bhagats Sheikh Farid Copyright? History of Sikhism Nov 14, 2011
    Christianity Public library find is only surviving copy of rebel hymn book Interfaith Dialogues Jan 8, 2011

  3. Rick B

    Rick B
    Expand Collapse
    Guest

    This is an ACCESS newsgroup. You seem to be asking an EXCEL question.
    Please post your question to an Excel newsgroup.

    Good Luck,

    --
    Rick B



    "Keyser" <Keyser@discussions.microsoft.com> wrote in message
    news:9F37DA72-222B-44EC-8A23-07EB8556CDBF@microsoft.com...
    > I'm trying to copy information in cells of a single column down quite a
    > ways,
    > and I would rather not (ctl v, d arrow) all the way down. Does anyone
    > have
    > any suggestions?
     
  4. Joan Wild

    Joan Wild
    Expand Collapse
    Guest

    If you are using Access, use an Update Query that updates the field to the
    value you want.

    --
    Joan Wild
    Microsoft Access MVP

    Keyser wrote:
    > I'm trying to copy information in cells of a single column down quite
    > a ways, and I would rather not (ctl v, d arrow) all the way down.
    > Does anyone have any suggestions?
     
  5. '69 Camaro

    '69 Camaro
    Expand Collapse
    Guest

    Hi, Keyser.

    > I'm trying to copy information in cells of a single column down quite a
    > ways,
    > and I would rather not (ctl v, d arrow) all the way down.


    If all records have the same value for this column (attribute), then you
    need to determine whether or not it's actually necessary, and not just
    "understood" in the business logic of the application. For example, if the
    table is storing records of deliveries of orders to customers and deliveries
    are only made within a certain mile radius of your business so that all
    deliveries are made in your state, then it might be redundant to always store
    the state along with the street address of the customer.

    However, if you've determined that you really do need to store the same
    value in every record in the table, then a simple UPDATE query will suffice.

    Try:

    UPDATE MyTable
    SET MyColumn = 'MyValue';

    .. . . where MyTable is the name of the table, MyColumn is the name of the
    column that needs this value, and MyValue is the string literal value that
    needs to be set for every record.

    If it's a numeric value, then the query would be something like:

    UPDATE MyTable
    SET MyColumn = 1234;

    If it's a date value, then the query would be something like:

    UPDATE MyTable
    SET MyColumn = #4/1/2006#;

    HTH.
    Gunny

    See http://www.QBuilt.com for all your database needs.
    See http://www.Access.QBuilt.com for Microsoft Access tips and tutorials.
    http://www.Access.QBuilt.com/html/expert_contributors2.html for contact info.


    "Keyser" wrote:

    > I'm trying to copy information in cells of a single column down quite a ways,
    > and I would rather not (ctl v, d arrow) all the way down. Does anyone have
    > any suggestions?
     

Share This Page