Copy and paste to blank cells only

[MiteshG]

Hi,

Have a peculiar problem in excel that I am trying to solve.

I have data in an excel sheet under columns A through E (including column headers). I want to paste this data in another excel sheet.

However, while pasting, I want to past the data only if associated cell in other sheet is blank and not replace the data in entire row.

Example - Sheet 1

Name	Address	City	Country	Phone
Tom	La La Land	NY	USA	123456789
Harry	123 Street	Denver	USA	987654321

Sheet 2

Name	Address	City	Country	Phone
Tom		NJ	USA
Harry	123 Street		USA	324567891

While pasting the data from sheet 1 to sheet 2 for row 1, I would like to have the address as La La Land, however I would like to retain the city as NJ in sheet 2 (and not replace it with NY).

I understand that this may not be the best example but I didn't want to represent actual data due to confidentiality.

Since this has to be done for bigger volume of data (about 1000 rows), copy pasting individual cells is not an option. Any suggestions on how to achieve this?

Thank you in advance.

 

[Akuini]

@MiteshG
Welcome to MrExcel
Try this:
You need a blank sheet, say sheet3:
Copy data in sheet1 > go to sheet3 A1 > paste
Copy data in sheet2 > go to sheet3 A1 > right click > paste special > choose "Skip Blank" > OK

 

[MiteshG]

@MiteshG
Welcome to MrExcel
Try this:
You need a blank sheet, say sheet3:
Copy data in sheet1 > go to sheet3 A1 > paste
Copy data in sheet2 > go to sheet3 A1 > right click > paste special > choose "Skip Blank" > OK

Thank you. This helped.

 

[Akuini]

You're welcome, glad to help & thanks for the feedback.