Multiple workbooks trying to combine into one

Closed
Cliff - Aug 31, 2010 at 01:15 PM
 Ray - Aug 31, 2010 at 06:21 PM
Hello,
I have multiple workbooks I'm trying to combine into one, so I can perform some data analysis. I'm trying to have a date only show up when a date is actually entered. If no date is entered in the original, the return is 1/0/1900; however, I want the return to be left blank if no date is entered in the original. Please help a beginner!


1 reply

I am reading two questions here.
1. Combine multiple workbooks
This link was under your question: https://ccm.net/forum/affich-255405-copy-multiple-sheets-to-another-sheet-vba
2. Some kind of data validation perhaps?
How and/or where is the date getting entered?

Can you elaborate please?
0