Search : in
By :

Copy rows of data based on alpha condition

Last answer on Feb 11, 2009 7:37:50 am GMT bgb92, on Feb 11, 2009 5:16:34 am GMT 
 Report this message to moderators

Hello,
I have a summary worksheet that houses all records. I'd like to break that summary worksheet into in multiple worksheets grouped by last name, but still maintain my summary sheet for updating. I'd like to update one worksheet but have those updates transfer to the other worksheets.

I have a summary worksheet that stores information like lastname, first name, birthdate, email address & contact information. I'd like to take that information and pull it into another worksheet grouped by last name (worksheet 2 A-H, worksheet 3 I-P, worksheet 4 Q-Z)

Configuration: Windows XP
Internet Explorer 7.0

Best answers for « copy rows of data based on alpha condition » in :
Copy rows based on a condition Show Copy rows based on a condition Issue Solution Note Issue How can I have excel copy the entire row of data from worksheet Employee Inventory to another worksheet called EEs if column Q contains TERM. I've tried almost everything but...
Connect a database (MDB) to excel Show[VBA] Connecting a database (MDB) to excel Below is a tips of how to connect an Access database (MDB) in an application excel Add reference Microsoft DAO object librairy X.X In a general module (eg Module1) paste the code below...
(MRU) Most Recently Used - Definition and Tips ShowManual Method Using a software (MRU) Most Recently Used - Definition and Tips Most Recently Used (MRU) is a data based feature under Microsoft which detects in cached the most recently used items. In other terms, it means that same...
Databases - Using forms ShowUsing forms In order to use databases, the user must be provided with an interface that allows him or her to view data based on certain criteria. There is a tool for this: forms. A form is an interface with components for displaying, entering, or...

1

 solene77, on Feb 11, 2009 7:37:50 am GMT

Hi,
try this link:
www.duepoint.com/1863/julias_study_guide.xlsx
this should help you to solve your problem.
good luck.

Reply to solene77