![]() |
#1
|
|||
|
|||
![]()
I am trying to copy cells
A1 A2 A3 A4...and so on... from Sheet1 to Sheet2, is there any easy way to copy all cells at one time since I am trying to copy by using =Sheet1!A1, one at a time! Also I note that the empty cells in Sheet1 shows zero (0) in Sheet2 ![]() I would like those cells to be empty as well. Need help with this....please cell Sheet1!B1:C1 is a date =IF(D2="","",(Sheet1!B1:C1))....returns #VALUE =IF(Sheet2!D2="","",(Sheet1!B1:C1))....returns blank cell |
|
![]() |
||||
Thread | Thread Starter | Forum | Replies | Last Post |
![]() |
khawajaanwar | Excel Programming | 2 | 09-09-2016 11:21 AM |
![]() |
Xyz_999 | Excel | 4 | 09-06-2016 01:53 AM |
Transferring info from 1column on sheet2 to sheet1 | rogcar75 | Excel | 22 | 08-26-2014 05:07 PM |
How to populate cells in Sheet2 with Data Source query using cell data from Sheet1 | bobznkazoo | Excel | 2 | 03-27-2014 11:14 AM |
![]() |
KIM SOLIS | Excel | 6 | 10-30-2011 11:14 PM |