Results 1 to 5 of 5

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

Threaded View

Lostinxcel Transfer data from multiple... 03-04-2010, 04:38 AM
excelxx Re: Transfer data from... 03-04-2010, 05:15 AM
Lostinxcel Re: Transfer data from... 03-04-2010, 05:44 AM
excelxx Re: Transfer data from... 03-05-2010, 06:32 AM
Lostinxcel Re: Transfer data from... 03-08-2010, 05:57 AM
  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.

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