Try to Copy cells from Sheet1 to Sheet2

		Microsoft Office Forums > Microsoft Excel > Excel
Try to Copy cells from Sheet1 to Sheet2

FAQ

Thread Tools

Display Modes

09-22-2017, 03:12 AM

mikehk

Windows 10 Try to Copy cells from Sheet1 to Sheet2

Office 2013

Novice

Join Date: Sep 2017

Posts: 15

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....

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 01:08 PM.