Macro or VB Code to Summarize Info.from 4 workbooks

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can anyone tell me how to write a macro or code that would automatically copy
the text contents of a cell from Workbook A to Workbook E only if that cell
in Workbook A is not Empty. And if the cell in Workbook A is empty, then
continue to Workbook C, and D?

My ultimate purpose is to include a summary of all the text inputted to
Workbooks A-D in Workbook E. I want to see only the cells that contain text
from Workbooks A-D in Workbook E.
 
To start you off, the test you want is:
If IsEmpty(Range("A1")) Then
'do your copy
End If
Geof.

You might want to look into workbook consolidation.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA code for pasting links -- modifying RDB code for summary workbook 10
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
How to reference a cell from anther workbook without opening it 0
Macro shortcuts are running macros in different open workbook 3
Open Workbook Macro - with a twist 1
Open four Wbooks, copy four columns from each to Master Wbook 16
Cell values to an array, then array transpose to another workbook 8
Import multiple workbooks to current workbook in specified row number 0

Back
Top