Microsoft Office Forums

Go Back   Microsoft Office Forums > Microsoft Excel > Excel

Reply
 
LinkBack Thread Tools Display Modes
  #1  
Old 09-21-2017, 09:18 PM
mikehk mikehk is offline Windows 10 Office 2013
Novice
 
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
  #2  
Old 09-21-2017, 11:19 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

One way :
Enter your formula as described above =Sheet1!A1 then pull down the handle at the lower right corner of the cell where you entered the formula as far as needed
Using IF with range will not work
As for the cells containing a 0, is there a formula in them, and which is it?
You can eventually check " do not show zero values " in the XL options
Reply With Quote
  #3  
Old 09-22-2017, 03:12 AM
mikehk mikehk is offline Windows 10 Office 2013
Novice
 
Join Date: Sep 2017
Posts: 15
mikehk is on a distinguished road
Default

Thanks.
I got it working....by using

=IF(ISBLANK(Jan!$C2),"",Jan!C2)

Is it possible to copy past / rename the formula?
I would like to replace Jan to Feb / Mar / Apr ...so on.
The formulas are for a whole month of Jan, then same
for Feb, Mar, Apr....
Reply With Quote
  #4  
Old 09-22-2017, 03:27 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Windows 7 64bit Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 1,901
Pecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nicePecoflyer is just really nice
Default

Perhaps try http://www.rondebruin.nl/win/addins/rdbmerge.htm
Reply With Quote
Reply
Please reply to this thread with any new information or opinions.

Thread Tools
Display Modes


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


All times are GMT -7. The time now is 07:02 PM.


Powered by vBulletin® Version 3.8.1
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
MSOfficeForums.com is not affiliated with Microsoft