PC Review


Reply
Thread Tools Rate Thread

Copying certain column information quickly

 
 
=?Utf-8?B?SG9nYW5EODc=?=
Guest
Posts: n/a
 
      30th Oct 2007
As you know in Excel you could quickly copy the information you needed with a
drag of the mouse.

Because I need information copied repeatedly and easily for my access
unfirmiliar co workers.

Example

JOB CUSTOMER QUOTE #
A B1 110701
A(copied) A2 110701 (copied)
A(copied) C4 110701 (copied)

How do I do this quickly and efficiently for the computer challenged.
 
Reply With Quote
 
 
 
 
Arvin Meyer [MVP]
Guest
Posts: n/a
 
      30th Oct 2007
Sorry, Access is a database, not a spreadsheet, and can't be used like one.

You can write some code to select the rows that you want to include, then
put those row in memory, or export them to some other source. The easiest
way I know of to select contiguous rows is a query.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

"HoganD87" <(E-Mail Removed)> wrote in message
news:EF42F42C-6AF6-44D8-88CF-(E-Mail Removed)...
> As you know in Excel you could quickly copy the information you needed
> with a
> drag of the mouse.
>
> Because I need information copied repeatedly and easily for my access
> unfirmiliar co workers.
>
> Example
>
> JOB CUSTOMER QUOTE #
> A B1 110701
> A(copied) A2 110701 (copied)
> A(copied) C4 110701 (copied)
>
> How do I do this quickly and efficiently for the computer challenged.



 
Reply With Quote
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Copying formulas into column from row information suzilea Microsoft Excel Misc 2 4th Nov 2008 04:29 PM
add information quickly Pammy Microsoft Access 1 22nd Sep 2008 07:46 PM
Looking up a variable in one worksheet and copying information from another column to another worksheet?? Brad Torken Microsoft Excel Misc 2 10th Dec 2006 06:02 AM
Copying data from one spreadsheet to another quickly =?Utf-8?B?amFsYmVydDE5NzU=?= Microsoft Excel Misc 0 13th Sep 2006 05:49 PM
How do I make a column of checkboxes quickly? Kevin Kimbrell via OfficeKB.com Microsoft Excel Misc 1 1st Jun 2005 07:39 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 11:46 AM.