+ Reply to Thread
Results 1 to 3 of 3

Need Formula to Transfer Column Data to another Column; Omitting Cells with no data

  1. #1
    Registered User
    Join Date
    12-12-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Need Formula to Transfer Column Data to another Column; Omitting Cells with no data

    I am stuck on this spreadsheet, would really appreciate any help!

    Weekly Job Hours Worked Spreadsheet-1.xlsx

    I need to copy over the data on the master spreadsheet "Job's in Process" to a sub sheet "Monday". I want to copy the data so that if on the master spreadsheet (starting at G72) if a row doesn't have data (say G64) it is omitted, so the spreadsheet "Monday" has the column data carried over without any blank rows.

    Then, I want to take the information on Monday's spreadsheet and if there are any "Hours Worked Today" have that populate the data back on the master spreadsheet as a snapshot summary.

    I am stuck transferring the data from the master spreadsheet "Job's in Process" to the sub sheet "Monday"?

    Thanks,
    Mike
    Attached Files Attached Files
    Last edited by LotoBoost; 12-16-2013 at 05:36 PM.

  2. #2
    Registered User
    Join Date
    12-12-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need Formula to Transfer Column Data to another Column; Omitting Cells with no data

    This is the correct spreadsheet:
    Weekly Job Hours Worked Spreadsheet-1.xlsx

  3. #3
    Registered User
    Join Date
    12-12-2013
    Location
    Maryland, USA
    MS-Off Ver
    Excel 2007
    Posts
    6

    Re: Need Formula to Transfer Column Data to another Column; Omitting Cells with no data

    Any ideas on how to do this?

+ 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. Replies: 3
    Last Post: 12-12-2013, 04:00 PM
  2. Formula for data transfer from rows to column
    By xWiZardx in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-27-2010, 12:10 AM
  3. Column Chart Omitting Data
    By lmw0189 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 09-16-2009, 03:52 AM
  4. [SOLVED] transfer data into row cells from column cells in Excel
    By Bernard Modlinsky in forum Excel General
    Replies: 3
    Last Post: 08-12-2006, 03:15 PM
  5. [SOLVED] Adding Column of mixed data omitting the dates
    By lpullen in forum Excel General
    Replies: 2
    Last Post: 11-17-2005, 12:45 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