#1
|
|||
|
|||
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 |
#2
|
||||
|
||||
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
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
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.... |
#4
|
||||
|
||||
Perhaps try http://www.rondebruin.nl/win/addins/rdbmerge.htm
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
|
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 |