+ Reply to Thread
Results 1 to 5 of 5

Transfer data from multiple cells to new worksheet based on cell value

  1. #1
    Registered User
    Join Date
    02-25-2010
    Location
    Malta
    MS-Off Ver
    Excel 2007
    Posts
    7

    Transfer data from multiple cells to new worksheet based on cell value

    Hi, I am completely new to anything else than the really basic excel functions, so would love to get some help on the following. I am working daily with a particular worksheet of which in some cases data needs to be transferred to another sheet, as I need that for a different task. I have tried to write it out what I need to have solved, so here goes.

    If cell value in column E of the worksheet (Receipts PYMT 2010) equal 70% or 100%, the following needs to happen:
    - copy data in cells (same row) of column I and paste it in the next available cell of column B of new worksheet (Invoice Cost Overview 2010);
    - copy data in cells (same row) of column A and paste it in the next available cell of column C of new worksheet (Invoice Cost Overview 2010);
    - copy data in cells (same row) of column G and paste it in the next available cell of column D of new worksheet (Invoice Cost Overview 2010).

    The new worksheet (Invoice Cost Overview 2010) has its first row as header.

    Hopefully the above is clear, but do let me know if further information is needed.

    Any suggestions/solutions are much appreciated.

    Cheers,

    Erik
    Last edited by Lostinxcel; 03-08-2010 at 06:01 AM.

  2. #2
    Forum Contributor
    Join Date
    02-04-2010
    Location
    Hertfordshire, England
    MS-Off Ver
    Office 2007 (home) Office 365 (work)
    Posts
    134

    Re: Transfer data from multiple cells to new worksheet based on cell value

    Hi Lostinxcel

    Please can you attach a sample file, as it would be easy to suggest a solution.

    thanks

  3. #3
    Registered User
    Join Date
    02-25-2010
    Location
    Malta
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Transfer data from multiple cells to new worksheet based on cell value

    Hi Excelxx,

    Thanks for the quick reply. Please find attached the sample worksheets.

    Cheers.
    Attached Files Attached Files

  4. #4
    Forum Contributor
    Join Date
    02-04-2010
    Location
    Hertfordshire, England
    MS-Off Ver
    Office 2007 (home) Office 365 (work)
    Posts
    134

    Re: Transfer data from multiple cells to new worksheet based on cell value

    Hi Lostinxcel

    Sorry for the delay, was very busy yesterday.

    I have added some code to your spreadsheet which provides you with want you want.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    02-25-2010
    Location
    Malta
    MS-Off Ver
    Excel 2007
    Posts
    7

    Re: Transfer data from multiple cells to new worksheet based on cell value

    Excelxx,

    No problem, I was sick myself and only returned to the office today.
    Thanks a lot for the code. Works great.

    Cheers

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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