You are here:
- Home
- Computing/Technology
- Business Software
- Excel
- Copy values from one sheet to the other
Excel/Copy values from one sheet to the other
Advertisement
Question
I am having two excel sheets, W1 and W2. In W1 i have certain charecters and in W2 i have the 3 corresponding values for the charecters in W1
My Problem is that the text for the charecters are not the same in W1 and W2, but are more or less the similar. The second thing is that the values are not listed in the same order in W1 and W2.
I need to have a logic to arrange all the values for the charecters in Sheet W1. Manually this can be done, but since there are more than 5000 points it will take moe time and accuracy is less.
I’m not following what needs to be done here – can you clarify – if it helps, you can email me at aidan.heritage@virgin.net - it SOUNDS as though it may simply be vlookup that is needed - if it helps, there is a useful dictionary of excel terms at http://www.aidanheritage.byethost3.com/excel/xlfdic01.xls which includes worked examples of many of the functions in excel including this one.
Related Articles
About Excel
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
This topic answers questions related to Microsoft Excel spreadsheet (or workbook) stand-alone or Mircrosoft Office Excel including Excel 2003, Excel 2007, Office 2000, and Office XP. You can get Excel help on Excel formulas(or functions), Excell macros, charting in Excel, advanced features, and the general use of Excel. This does not provide a general Excel tutorial nor the basics of using a spreadsheet. It provides specific answers to using Microsoft Excel only. If you do not see your Excel question answered in this area then please ask an Excel question here
Excel
Answers by Expert:
- Mary A. Lindsey
- Nathan Head
- Raj Narayan Banerjee
- Chad Welch
- Ken Cowen
- Damon Ostrander
- Gyula Gulyas
- Stuart Resnick
- Bill Hermanson
- Jerry Beaucaire
- Michelle Howell
- Isaac
- Edward H. Mori
- Aidan Heritage
- Tom Ogilvy
- Richard Roberts
- Richard Stephens
- JP
- Richard Rost
- Victor Lan
- Tushar Sakhalkar
- Philip Buckley
- David W. Cofer
- Amal
- Bob Umlas
- Jessica L.
- Shahid
- Jan Karel Pieterse
- Craig
- Adelaide carvalho
- Sixthsense
- Bill
- Anne Troy
Aidan Heritage
Expertise
I have provided first hand support since `95 for Microsoft Office majoring in Word and Excel - support for all versions from 2 onwards
Experience
My background is in the insurance industry and call centre areas, but have been called upon to provide many varied solutions.
Education/Credentials
I'm educated to UK A level standard, but as I left school some 30 years ago that is rather irrelevent - university of life has provided more of a background!
©2012 About.com, a part of The New York Times Company. All rights reserved.