PC Review


Reply
Thread Tools Rate Thread

Copy data from on workbook to another...with a catch

 
 
Ron
Guest
Posts: n/a
 
      11th Jun 2009
I have data on multiple people in a workbook
A B C
Vader, Darth
6/9/09 AUX 1:53
Skywalker, Luke
6/9/09 AUX 9:41
etc (There are other lines, but I'm keying on the word AUX) (Some names may
have no data.)

I need to copy the whole line with the word AUX to another spreadsheet.
I have 2 options. All names on one page(col A).Blank line between data and
next name. (Like above but with a blank line above the names.)
I would need to insert the data in the blank line after Vader's data (may
already have 20 lines), moving the rest of the lines down, leaving a blank
line between data and next name. Then go get the line with AUX under
Skywalker, and do the same, inserting the data in the blank line after
Skywalker, moving the rest down. etc

2nd option is to have a separate sheet with each name and just add the data
to the last line of the sheet for the name.

Don't know which is more feasible, but I'm sure both could be done...make it
easy on yourselves.

Thanks,
Ron

 
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
Macro to copy specific data from master workbook to another workbook Mark767 Microsoft Excel Programming 13 1st Sep 2009 08:57 PM
Copy data from Workbook Alpha & reorganize it in Workbook Bravo u473 Microsoft Excel Programming 1 31st Oct 2007 02:37 AM
1.Open workbook. 2 copy data. 3 replace data. 4 save workbook. Cristobalitotom Microsoft Excel Programming 0 6th Jul 2006 12:24 AM
loop through a column on a workbook copying data on each row to another workbook, then copy data back to the original workbook burl_rfc Microsoft Excel Programming 1 1st Apr 2006 08:48 PM
Selecting data from 1 workbook to copy and paste to a 2nd workbook =?Utf-8?B?SmFja1NwYW0=?= Microsoft Excel Programming 2 20th Jul 2005 02:33 AM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 08:09 AM.