Results 1 to 14 of 14

Search for Serial # in another sheet and then copy from row below

Threaded View

  1. #1
    Registered User
    Join Date
    07-19-2011
    Location
    USA
    MS-Off Ver
    Excel 2003
    Posts
    73

    Search for Serial # in another sheet and then copy from row below

    In the attachment you will see a tab "Summary Info" and in the A column there are Serial Numbers. I would like to look up the serial number in the "Summary Info" sheet on the "Maint_Info" sheet and look across into the "Pro-Rated Thru Maintenance $" column and pull the cell right below it. So for example, if I lookup serial number "355252" on the "Maint_Info" sheet, I would like it to copy " $21,886.00" into D2 on the "Summary_Info" sheet. Thanks in advance.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] VBA to search internet and copy data into sheet based on search
    By DanzaNZ in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-03-2016, 06:17 PM
  2. Keyword search and copy row to new sheet: search term problem
    By completenovice in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 11-20-2014, 11:32 AM
  3. [SOLVED] How to search workbook for all serial numbers that are less than a value
    By onbeillp111 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 05-01-2014, 08:51 AM
  4. [SOLVED] Copy data from 1 sheet to another sheet base on serial number input
    By Curtis goh in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-17-2013, 11:37 PM
  5. [SOLVED] vba code to search for a serial nr
    By tekken in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-24-2013, 01:57 AM
  6. [SOLVED] Search for heading in data sheet and copy range to corresponding sheet in master workbook
    By sans in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 07-07-2012, 10:02 AM

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