+ Reply to Thread
Results 1 to 4 of 4

Macro or Formula to Label Ebay Items from Sheet1 to Sheet2

  1. #1
    Registered User
    Join Date
    12-02-2019
    Location
    Bay City, Michigan
    MS-Off Ver
    2019
    Posts
    2

    Question Macro or Formula to Label Ebay Items from Sheet1 to Sheet2

    I have a massive spreadsheet of ebay sales 30,000+ Rows and 20+ columns. Half of the sales are mine, Half are sales of a business partner. I am hoping to get some help from a guru to label these.

    The idea of how it would work....
    Sheet1 has a Column B with Item numbers of sold items (item numbers have many duplicates some not)
    Sheet2 has Column A with item numbers, Column B with the labels that I want to pull over to sheet 1. (The Item Numbers are a unique number set)
    One other issue or concern, Not all rows have a item number in the item number Column... So the formula could leave this blank or label as none)

    If needed I could potentially do this in access but have very little knowledge.

    Thank you in advance! I assume this has been answered before but I do not know how to search for it, If anyone knows a formula need to look up as well

    I have attached a very simple version xls file to demonstrate.
    Attached Files Attached Files

  2. #2
    Forum Expert PaulM100's Avatar
    Join Date
    10-09-2017
    Location
    UK
    MS-Off Ver
    2016
    Posts
    2,100

    Re: Macro or Formula to Label Ebay Items from Sheet1 to Sheet2

    Try =IFERROR(VLOOKUP(B2,Sheet2!$A:$B,2,0),"")
    Click the * to say thanks.

  3. #3
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... based in Ireland... but I could be anywhere in the world
    MS-Off Ver
    Office 365 for PC.
    Posts
    33,856

    Re: Macro or Formula to Label Ebay Items from Sheet1 to Sheet2

    In C2, copied down:

    =IFERROR(VLOOKUP(B2,Sheet2!A:B,2,FALSE),"")

    will do that.
    Glenn



  4. #4
    Registered User
    Join Date
    12-02-2019
    Location
    Bay City, Michigan
    MS-Off Ver
    2019
    Posts
    2

    Re: Macro or Formula to Label Ebay Items from Sheet1 to Sheet2

    Thank you so much. You saved me weeks of work!

    Reputation points added!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] A macro which pulls the data from sheet2 to sheet1 basis of scenarios selected in sheet1
    By Manish_Gupta in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 03-15-2015, 01:46 PM
  2. Macro count items in sheet2 and provide count in embedded label in sheet1
    By jaredmccullough in forum Excel Programming / VBA / Macros
    Replies: 11
    Last Post: 02-05-2015, 11:27 AM
  3. [SOLVED] Copy called out items from sheet1 to sheet2
    By MICowboy13 in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 01-09-2014, 12:45 PM
  4. Show Difference of sheet1-sheet2 in sheet3 if items match?
    By nyichiban in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-23-2013, 04:03 PM
  5. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  6. Macro to copy range of cell from sheet1 to sheet2 based on a cell value in sheet2
    By drgwhizz in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-25-2012, 10:39 AM
  7. Showing the number of items in sheet1 based on datas in sheet2
    By Saky in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-02-2010, 02:37 PM

Tags for this Thread

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