Simple Looping Query

[andrewc]

Hi,

In A1:A1000 I have a list of product names; Product A, Product B etc, each appearing more than once. I would like to create a simple macro that extracts from column A, and puts into a new range starting at C1, each of the names of the products. So C1 would contain the text "Product A", C2 would contain the text "Product B" etc until column C contains the list of product names from A1:A1000.

I have little doubt that this requires just a few lines of VBA code but even that's beyond me, so can someone please suggest a solution?

Thanks!

[elayaz]

Perhaps,,

Select the range.

Data-> Advance filter--> copy to another location & Unique records only..

[andrewc]

Thanks for the quick reply, Elayaz!

Can anyone please suggest how to accomplish this using VBA?

Thanks

[elayaz]

Try this..

Please Login or Register  to view this content.

[andrewc]

Thanks again.

Can I please ask one silly question:

When I use this code it does what I required except that it returns two instances in column C of the first product name in column A. Any idea why this would be? I've checked that the two items returned aren't different text.

[elayaz]

The list should have a header row, otherwise it will treat the first line as a header row, so first entry will repeat.

Insert a row in the top of column A and give a name to the list ( like "product list")

Open the code and the change the range to a1:a1001 and run the code.

It should work perfectly.


---------------------------------------------------------------------------
If my reply helped, Please add reputation (click on the star below the post)
If the reply solves your problem, Don't forget to mark the thread as "Solved" (Thread Tools->Mark thread as Solved)

[andrewc]

Perfect, thank you!