Macro to sort and move data

Microsoft Excel 010 - complete package
July 26, 2011 at 14:21:04
Specs: Windows 7
I am looking for a macro to help me sort and move rows of data. I have the following data: Acme Corp Lead 40,000
Smith Corp Map 50,000
Jones Inc Lead 60,000

The macro I need help with would take the data in each row and move it to the first empty row in the second worksheet based on the 2nd column so that the result would look like the following:
Acme Corp Lead 40,000 Smith Corp Map 50,000
Jones Inc Lead 60,000

The reason I am looking to use a macro is the 2nd column (Lead-Map) will change with time and I want it to move automatically to the appropriate columns. Thanks for any help.


See More: Macro to sort and move data

Report •

#1
July 26, 2011 at 14:50:54
You didn't post any Column headings so we can't tell how your source or destination data is laid out.

Please click on the following line and read the instructions on how to post data in this forum. Thanks!

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.


Report •

#2
July 27, 2011 at 09:31:26
Sorry, here's the data in sheet Master.
Name   	      Pipeline	Rank	Annual	Monthly	Rep
Acme Corp	PROSPECT A	$12,000	$1,000	NC
Smith Corp	MAP	 B	$8,000	$667	NC
Jones Inc.	PROSPECT B	$20,000	$1,667	NC

I would like to see it grouped into the following sheet Summary.
Prospect	Rank	Annual	Monthly	Rep	Map	Rank	Annual	Monthly	Rep
Acme Corp	A	$12,000	$1,000	NC	Smith Corp	B	$8,000	$667	NC
Jones Inc.	B	$20,000	$1,667	NC					

The reason is so that as the Name changes from Prospect to Map it will automatically move all the data with it. Thanks for any help.


Report •
Related Solutions


Ask Question