+ Reply to Thread
Results 1 to 9 of 9

Adding data to a column based on data from a seperate cell

  1. 04-14-2017, 07:26 AM #1
    JohnnyBoyxxx
    JohnnyBoyxxx is offline
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Adding data to a column based on data from a seperate cell

    Hi guys, My dilemma is that on a daily basis I receive a product list of around 700-800 items.

    In the sample list provided on sheet 1 i've shown a portion of how the raw data is when i receive it.

    This data is always broken into 3 categories, Open Boxed, Refurbished and Renew.

    I then have to create a 'condition' column in G and fill those cells based on the 3 categories so that
    when completed it looks like it does in sheet 2.

    I feel i should be able to do this but it's driving me nuts trying to work it out, anay help would be great guys.

    Regards
    John
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 04-14-2017, 10:42 AM #2
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: Adding data to a column based on data from a seperate cell

    Hi JohnnyBoyxxx

    This works...a bit long though
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by sintek; 04-14-2017 at 10:55 AM. Reason: Changed code and added new sample
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!
    Reply With QuoteRegister To Reply
  3. 04-14-2017, 10:49 AM #3
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: Adding data to a column based on data from a seperate cell

    Oh my word...I just realised that all this code does is duplicate the first Sheet......What!!!!!!!!!!!!!
    Reply With QuoteRegister To Reply
  4. 04-14-2017, 11:50 AM #4
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Adding data to a column based on data from a seperate cell

    5B:
    Please Login or Register  to view this content.
    1. I care dog
    2. I am a loop maniac
    3. Forum rules link : Click here
    3.33. Don't forget to mark the thread as solved, this is important
    Reply With QuoteRegister To Reply
  5. 04-14-2017, 12:20 PM #5
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: Adding data to a column based on data from a seperate cell

    Quote Originally Posted by sintek View Post
    Oh my word...I just realised that all this code does is duplicate the first Sheet......What!!!!!!!!!!!!!
    @ karedog
    What a dummy I am hey Lol
    Reply With QuoteRegister To Reply
  6. 04-14-2017, 12:41 PM #6
    JohnnyBoyxxx
    JohnnyBoyxxx is offline
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Adding data to a column based on data from a seperate cell

    Absolutely perfect karedog, nice work.

    Many thanks for all your efforts guys.

    Regards
    John
    Reply With QuoteRegister To Reply
  7. 04-14-2017, 12:52 PM #7
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Adding data to a column based on data from a seperate cell

    You are welcome Johny, thanks for marking the thread as solved and rep.points.

    Regards
    Reply With QuoteRegister To Reply
  8. 04-14-2017, 12:58 PM #8
    karedog
    karedog is offline
    Forum Guru karedog's Avatar
    Join Date
    10-03-2014
    Location
    Indonesia
    MS-Off Ver
    2003
    Posts
    2,971

    Re: Adding data to a column based on data from a seperate cell

    Quote Originally Posted by sintek View Post
    @ karedog
    What a dummy I am hey Lol
    No you are not, a dummy is preserved human body when he/she 's died (like the one in Egypt's tomb", yet you are still alive
    Or aren't you ?
    Reply With QuoteRegister To Reply
  9. 04-14-2017, 01:37 PM #9
    sintek
    sintek is offline
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,176

    Re: Adding data to a column based on data from a seperate cell

    Alive i am....
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Data blending - Retreving data from rows in seperate pages, based on IDs and names
    By Philbert1 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 08-29-2016, 06:37 PM
  2. Adding seriall number based on data in another column
    By Mero Mero in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 08-25-2015, 08:14 PM
  3. Splitting data into seperate spreadsheets based on column values
    By narendrabr in forum Excel Programming / VBA / Macros
    Replies: 22
    Last Post: 02-03-2014, 07:16 AM
  4. VBA code to seperate the data into different sheet based on column 4
    By acong in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-14-2013, 05:31 AM
  5. One Long Column of Data...Need to seperate into multiple columns denoted by blank cell
    By Mucciolo in forum Excel General
    Replies: 12
    Last Post: 06-26-2013, 02:39 AM
  6. [SOLVED] Adding Or Subtracting Cells Based On A Date Within A Seperate Cell
    By Gtrtim112 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 05-09-2013, 03:09 PM
  7. [SOLVED] Finding data based on column and row from seperate charts
    By oreosxe in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-10-2012, 01:58 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1