Results 1 to 4 of 4

Pull stock code , description and pack from sheet1

Threaded View

  1. #1
    Forum Contributor
    Join Date
    01-04-2014
    Location
    East Africa
    MS-Off Ver
    MS OFFICE 2013 PRO PLUS
    Posts
    3,709

    Pull stock code , description and pack from sheet1

    Formula on a4 b4 and c4 to drag down

    Should work on 7500 rows of sheet1

    The feed will be b1 the keyword , meaning if I type ARIZONA ,
    it should pull all codes with the word Arizona anywhere on the
    description

    The expected answer for if I type QUARRY should be

    256.000.07	ROMAN = QUARRY BEIGE 30 X 60 = GL638001 	6 Pcs per Carton
    256.000.08	ROMAN = QUARRY BROWN 30 X 60 = GL638002 	6 Pcs per Carton
    256.000.09	ROMAN = QUARRY CORAL 30 X 60 = GL638003 	6 Pcs per Carton
    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. VBA Code to pull Stock Balance Sheet Data from a Stock Symbol in a cell
    By akash1229 in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-27-2015, 04:37 PM
  2. stock description changes
    By makinmomb in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-21-2014, 05:58 AM
  3. [SOLVED] I need code to pull radio option selection on sheet1 to sheet2
    By TAMMY32 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 09-07-2014, 11:46 PM
  4. Replies: 2
    Last Post: 07-22-2014, 07:44 AM
  5. Replies: 6
    Last Post: 07-01-2011, 09:38 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