Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or VB Code to Summarize Info.from 4 workbooks
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro or VB Code to Summarize Info.from 4 workbooks
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. -----Original Message----- 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. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to summarize data | Excel Worksheet Functions | |||
Macro to put info into certain columns based on info in another co | Excel Discussion (Misc queries) | |||
Sharing info across 2 workbooks | Excel Worksheet Functions | |||
macro or code to open multiple workbooks | Excel Discussion (Misc queries) | |||
Info From Different Workbooks... | Excel Discussion (Misc queries) |