Multiple workbooks trying to combine into one

Cliff - Aug 31, 2010 at 01:15 PM
 Ray - Aug 31, 2010 at 06:21 PM
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 response

I am reading two questions here.
1. Combine multiple workbooks
This link was under your question:
2. Some kind of data validation perhaps?
How and/or where is the date getting entered?

Can you elaborate please?