Microsoft Office Forums

Go Back   Microsoft Office Forums > >

 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 09-21-2017, 09:18 PM
mikehk mikehk is offline Try to Copy cells from Sheet1 to Sheet2 Windows 10 Try to Copy cells from Sheet1 to Sheet2 Office 2013
Novice
Try to Copy cells from Sheet1 to Sheet2
 
Join Date: Sep 2017
Posts: 15
mikehk is on a distinguished road
Unhappy Try to Copy cells from Sheet1 to Sheet2

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
Reply With Quote
 



Similar Threads
Thread Thread Starter Forum Replies Last Post
Try to Copy cells from Sheet1 to Sheet2 Moves multiple rows from Sheet1 to Sheet2 khawajaanwar Excel Programming 2 09-09-2016 11:21 AM
Try to Copy cells from Sheet1 to Sheet2 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
Try to Copy cells from Sheet1 to Sheet2 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

Other Forums: Access Forums

All times are GMT -7. The time now is 03:30 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2025, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2025 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft