multiple workbooks trying to combine into one Closed

Question

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!  


Configuration: Windows 7 / Internet Explorer 8.0

Ray · Answer

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?

Multiple workbooks trying to combine into one

1 response

Similar discussions

Subscribe To Our Newsletter!