Hello Dear,
Are you looking for dependent list,or you want shorting of data.
Have a look on attached sheet,I hope it will fulfill your requirement.
Hope it Will Help
Happy To Help
:)
Prashant Tripathi
On Wed, Apr 21, 2010 at 4:52 PM, royhamill wrote:
> Hello,
> I have 2 lists of dat
Hello,
I have 2 lists of data in different worksheets of the same workbook
similar to below:
ProductCity
Apples London
Oranges Birmingham
Pears Manchester
I want to create 1 list (2 columns) in 1 worksheet that looks like:
Product