+ Reply to Thread
Results 1 to 5 of 5

Extract Data from Sheet1 and insert into Sheet2 in relevant column and next available row

  1. #1
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Extract Data from Sheet1 and insert into Sheet2 in relevant column and next available row

    Hi Guys, can anyone help me with this.

    In the attached workbook i've copy and pasted the body text for a quote request i received via my website customer enquiry form into sheet1.

    I'd then like to extract the data from it into the relevant columns in sheet2 on the next available row.

    The text that's highlighted in red are the column headers in sheet2 and the text directly below in green is the data i wish to extract in the relevant columns in sheet2

    Possibly more complicated is the email address highlighted in green in row1 to the next available row in sheet2 Email column and the Date in column B, sheet1 into Date column in sheet2.

    The rows and columns will always be the same but some data fields may be empty with different enquiries.

    This is a kinda workaround for my previous problem request

    Appreciate any time and effort if someone can help with this

    Regards
    John
    Attached Files Attached Files

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,258

    Re: Extract Data from Sheet1 and insert into Sheet2 in relevant column and next available

    I am somehow once again not able to insert code...
    Attached Images Attached Images
    Attached Files Attached Files
    Last edited by sintek; 10-14-2020 at 07:39 AM.
    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!!!

  3. #3
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Extract Data from Sheet1 and insert into Sheet2 in relevant column and next available

    Hi Sintek, Thanks for your time and expertise with this, it works great.

    1 thing though is it brings in the word 'Donegal' before the email address and '*via*inbound-smtp.cp.blacknight.com*' after the email address with new entries i add, i can add a macro to find and replace so it's no biggy.

    Many Thanks
    Attached Files Attached Files

  4. #4
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    9,258

    Re: Extract Data from Sheet1 and insert into Sheet2 in relevant column and next available

    Strange...the spaces on either side of email are not regarded as spaces...Delete them and insert space again and you will see what I mean...

  5. #5
    Forum Contributor
    Join Date
    04-25-2011
    Location
    Donegal, Ireland
    MS-Off Ver
    Excel 2013
    Posts
    133

    Re: Extract Data from Sheet1 and insert into Sheet2 in relevant column and next available

    Perfect, thanks again sintek

+ 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] copy data from sheet1 to sheet2 based on column (A) sheet1 and column (C) sheet2
    By AWITCHER in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 05-13-2014, 03:20 PM
  2. Replies: 6
    Last Post: 07-25-2013, 02:58 PM
  3. [SOLVED] Split column value from Sheet1 and insert as row in sheet2
    By gupta1vipin in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-24-2013, 05:12 PM
  4. [SOLVED] Take Data From Column on Sheet1 and Insert Into Next Blank Row on Sheet2 Then Clear Sheet1
    By abutler911 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-09-2013, 06:30 PM
  5. To Extract data from sheet1 to sheet2
    By RAJUHULIYA in forum Excel General
    Replies: 1
    Last Post: 04-20-2012, 05:04 AM
  6. Extract Data from Sheet1 and rearrange in Sheet2
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 01-06-2011, 01:27 PM
  7. how to insert column from Sheet2 to Sheet1
    By IvicaOS in forum Excel General
    Replies: 6
    Last Post: 04-23-2007, 02:13 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1