Welcome to SPN

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

Sign Up Now!
  1.   Become a Supporter    ::   Make a Contribution   
    Target (Recurring Monthly): $200 :: Achieved: $98

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?
     
Since you're here... we have a small favor to ask...

More people are visiting & reading SPN than ever but far fewer are paying to sustain it. Advertising revenues across the online media have fallen fast. So you can see why we need to ask for your help. Donating to SPN's is vote for free speech, for diversity of opinions, for the right of the people to stand up to religious bigotry. Without any affiliation to any organization, this constant struggle takes a lot of hard work to sustain as we entirely depend on the contributions of our esteemed writers/readers. We do it because we believe our perspective matters – because it might well be your perspective, too... Fund our efforts and together we can keep the world informed about the real Sikh Sikhi Sikhism. If everyone who writes or reads our content, who likes it, helps us to pay for it, our future would be much more secure. Every Contribution Matters, Contribute Generously!

    Become a Supporter      ::     Make a Contribution     



Share This Page