+ Reply to Thread
Results 1 to 3 of 3

Copy cell data from one w/sheet to another with unused cells left blank

  1. #1
    Registered User
    Join Date
    07-04-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    49

    Copy cell data from one w/sheet to another with unused cells left blank

    Hi - i've got a workbook with two sheets. Sheet1 has a list of place names in column A and dates in column B. I want the same list to be entered onto Sheet2 in the same order. I can use the formula: ='Sheet1'!A1 and essentially it works just fine except in cells where no data exists on Sheet1.
    If I drag that formula down to empty cells on Sheet2 I end up with a 0 in column A where no data exists in the corresponding cell on Sheet1. The date column on Sheet2 has 00-Jan in the cells where no date exists in the corresponding cell on Sheet1.
    What I'm after is for the blank cells on Sheet1 to also be blank on Sheet2 until data is entered into Sheet1. it just makes it all look cleaner and more professional.

    thanks,
    Attached Files Attached Files
    Last edited by steve@stanley; 07-06-2012 at 10:02 AM. Reason: add attachment

  2. #2
    Forum Contributor
    Join Date
    01-24-2011
    Location
    Sheppey
    MS-Off Ver
    Excel 2010
    Posts
    239

    Re: Copy cell data from one w/sheet to another with unused cells left blank

    Try something like - =IF(Sheet1!A1="","",Sheet1!A1)

  3. #3
    Registered User
    Join Date
    07-04-2012
    Location
    London
    MS-Off Ver
    Excel 2007
    Posts
    49

    Re: Copy cell data from one w/sheet to another with unused cells left blank

    Perfect, thank you

+ 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