Results 1 to 3 of 3

Copy from Sheet 2, but remain blank if no data

Threaded View

  1. #1
    Registered User
    Join Date
    11-12-2011
    Location
    Leeds, Endland
    MS-Off Ver
    Excel 2007
    Posts
    12

    Question Copy from Sheet 2, but remain blank if no data

    Hello, I have two spreadsheets, sheet 1 and sheet 2. Sheet 2 has the data. Sheet 1 copies the data from Sheet 2 like this:-
    ='Sheet 2'!A1
    If Sheet 2 cell A1 has data, its a straight forward copy, if theres no data, i get a 0. Im wanting the cell to be blank if there's no data to copy accross.

    After this step im doing a straight forward copy all and paste all into Access. Im trying to avoid finding all the 0's and deleting them.

    Thank you.
    Last edited by noellloyd; 11-14-2011 at 06:33 AM.

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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