Results 1 to 3 of 3

Finding converted number from different worksheet

Threaded View

  1. #1
    Registered User
    Join Date
    05-20-2009
    Location
    Encino, CA
    MS-Off Ver
    Excel 2003
    Posts
    30

    Question Finding converted number from different worksheet

    Hey there...
    I have a batch of numbers that need to be converted to their corresponding number... I have a workbook, lets call it 'CoastConversion' that has two columns of numbers... Column A is WestCoast and Column B is the EastCoast equivalent of the number... what I need is a code that will do the following:
    -Take the list of numbers (usually in a blank worksheet 'Sheet1' in Column A)
    -Find it in column A (WestCoast) in the 'CoastConversion' workbook and copy its converted value from column B (EastCoast)
    -paste its converted value to Column B on 'Sheet1'

    I hope this makes sense... I just want to find an easier way to convert these numbers than copying each individual cell and then using the Find function to locate it in the conversion workbook ('CoastConversion')
    Please let me know if I am not being clear enough or if i can provide any additional information... And as always... THANK YOU for any info you can provide! You guys are life savers on this website
    Last edited by panamakevin; 08-05-2010 at 11:24 AM. Reason: solved
    ::I just found out that the brain is like a computer. If that's true, then there really aren't any stupid people. Just people running DOS.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1