Windows 7 Forums

Welcome to Windows 7 Forums. Our forum is dedicated to helping you find support and solutions for any problems regarding your Windows 7 PC be it Dell, HP, Acer, Asus or a custom build. We also provide an extensive Windows 7 tutorial section that covers a wide range of tips and tricks.

Windows 7: Excel 2010 help

19 May 2012   #1

Windows 7 Ultimate x64
Excel 2010 help

I have a document in Excel 2010 which contains 2 columns. Data from 2nd column is constant, does not change and is assigned to data in 1st column. Names and surnames are great example, so I will use this case for explanation.

Currently there are 200 unique names in 1st column and of course 200 surnames, attached to them in every row. There won't be any new names ever.

This is functionality I'd like to have. I often have to copy some of those names from external database (software) in various numbers. Let's say 50 random names to 1st column. But when I do that, I have to manually write down surnames to 2nd column, because they come from another database (software) which is not synchronized with the first one, so I cant just copy/paste them.

Is there any way to save (connect?) all 200 surnames to all 200 names in Excel, so when I would copy some of names from external database to 1st column, Excel would automatically attach appropriate surname to 2nd row?

I hope I was clear. Thanks for help in advance!

My System SpecsSystem Spec

21 May 2012   #2

Linux Mint 17 Cinnamon | Win 7 Ult x64


Seven Forums is an excellent place to get answers. But sometimes, you might find that there is a more focused, dedicated forum for a specific topic, such as in this case.

One of the best excel resources with a bunch of extremely helpful people is at | Excel Resources | Excel Seminars | Excel Products.

Jump on the forums there. I'm sure you will have your answer very quickly.

good luck
My System SpecsSystem Spec
24 May 2012   #3

Windows 7 Ultimate x64

Thanks for redirection.
My System SpecsSystem Spec


 Excel 2010 help

Thread Tools

Similar help and support threads for2: Excel 2010 help
Thread Forum
Excel 2010 Microsoft Office
Formatting Excel 2010, Excel 2003 Microsoft Office
Solved Excel 2010 Microsoft Office
Excel 2010 and Web Queries Microsoft Office
Excel 2010 sorting Microsoft Office
Incredible Excel 2010 Microsoft Office

Our Sites

Site Links

About Us

Find Us

Windows 7 Forums is an independent web site and has not been authorized, sponsored, or otherwise approved by Microsoft Corporation. "Windows 7" and related materials are trademarks of Microsoft Corp.

Designer Media Ltd

All times are GMT -5. The time now is 11:02 AM.
Twitter Facebook Google+

Windows 7 Forums

Seven Forums Android App Seven Forums IOS App

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33