How to copy a value from source workbook if if doesn't exist in Active workbook

p45cal · #2 07-15-2023, 02:16 PM

If the cells' row numbers correspond and the blanks you want to fill are truly blank then it could be as simple as:

Code:

'copying from Sheet1 to Sheet2 where sheet2 has true blank cells:
For Each cll In Sheets("Sheet2").Range("C3:C15").SpecialCells(xlCellTypeBlanks).Cells
  Sheets("Sheet1").Range(cll.Address).Copy cll
  'or
  'cll.Value = Sheets("Sheet1").Range(cll.Address).Value
Next cll

This was between sheets in the same workbook, so you'll need to qualify the workbooks as well.

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Display workbook filename in title bar and use personal workbook	Jamal NUMAN	Excel Programming	3	08-04-2022 02:56 AM
How do I copy a workbook to another workbook and keep the formatting within the new workbook	excelforsue	Excel	3	09-15-2020 03:37 AM
data entered in one workbook should be updated in other relevant workbook based on the date	vedha	Excel	0	04-24-2015 08:45 PM
Workbook with daily active sheet	MDMeyers	Excel	1	01-10-2015 04:48 AM
Range(Cell1,Cell2) Error on another workbook controlling some other workbook?	tinfanide	Excel Programming	1	02-09-2012 04:08 PM