A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Copy & Paste



 
 
Thread Tools Display Modes
  #1  
Old March 26th, 2010, 02:54 PM posted to microsoft.public.excel.misc
Jim
external usenet poster
 
Posts: 1,404
Default Copy & Paste

Hello,

I'm wondering if there is a way to copy and paste information from one cell
to multiple cells when there is intermitant data in a column. For example,
Example:

Column A
In row 1 I have the word "operations"
with rows 2 - 10 blank and then
In row 11 I have the word "Courier"
and rows 12-22 blank
In row 23 I have the word "Sales"
with rows 24 - 32 blank. Etc...

Is there an easier way to command a copy and paste witout having to address
each cell with text?

Thanks
Jim
  #2  
Old March 26th, 2010, 03:21 PM posted to microsoft.public.excel.misc
Jim Thomlinson
external usenet poster
 
Posts: 2,641
Default Copy & Paste

did you wan tto fill in the blanks or what exactly did you want to do. Show a
before and after so taht we can give the the proper steps.
--
HTH...

Jim Thomlinson


"Jim" wrote:

Hello,

I'm wondering if there is a way to copy and paste information from one cell
to multiple cells when there is intermitant data in a column. For example,
Example:

Column A
In row 1 I have the word "operations"
with rows 2 - 10 blank and then
In row 11 I have the word "Courier"
and rows 12-22 blank
In row 23 I have the word "Sales"
with rows 24 - 32 blank. Etc...

Is there an easier way to command a copy and paste witout having to address
each cell with text?

Thanks
Jim

  #3  
Old March 27th, 2010, 12:17 AM posted to microsoft.public.excel.misc
Art
external usenet poster
 
Posts: 4
Default Copy & Paste

On 3/26/10 9:54 AM, Jim wrote:

Hello,

I'm wondering if there is a way to copy and paste information from one cell
to multiple cells when there is intermitant data in a column. For example,
Example:

Column A
In row 1 I have the word "operations"
with rows 2 - 10 blank and then
In row 11 I have the word "Courier"
and rows 12-22 blank
In row 23 I have the word "Sales"
with rows 24 - 32 blank. Etc...

Is there an easier way to command a copy and paste witout having to address
each cell with text?

Thanks
Jim

Jim,

The Data/Filter/Advance Filter command might do what you want.

In your example, do the following:

1) Insert a blank row ABOVE your first row of entries (A1 in your example).

2) In cell A1 put a title for the entries for this column (eg: mydata).

3) Set up a filtering criteria in two successive cells that are not part
of your data range (eg: Z1:Z2). For example:

cell Z1: the title you entered for the column A entries from A1
cell Z2: *

Then, execute the Data/Filter/Advance Filter command:

1) Enter the data range of the data you wish to filter. Make sure you
include row 1 that has the column title in the range.

2) Enter the cells for the criteria range (Z1:Z2 in the example)

3) Chose the action that you want - either filter the range in place or
copy to another location. A single cell reference will suffice. I'd
suggest using the copy option until you get the filtering the way you
want as the filter command is usually undo-able.

4) Optionally, you can choose to have duplicate records deleted.

In the criteria example above, the * wildcard character indicates a
match of any character. Thus, a blank cell in a column A cell will fail
this test and won't be part of the result. The Excel Help has a number
of examples of setting up filter criteria.

--
Regards,
Art
 




Thread Tools
Display Modes

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

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


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


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.