Try to Copy cells from Sheet1 to Sheet2

mikehk · #1 09-21-2017, 09:18 PM

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Moves multiple rows from Sheet1 to Sheet2	khawajaanwar	Excel Programming	2	09-09-2016 11:21 AM
How to update Sheet1 from Sheet2 automatically?	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
How to merge two cells from sheet1 to one cell in sheet2 in next sheet	KIM SOLIS	Excel	6	10-30-2011 11:14 PM