How can we find data in different Excel sheets by VBA? [Solved/Closed]

Report
Posts
3
Registration date
Tuesday November 25, 2014
Status
Member
Last seen
November 29, 2014
-
Hi.I have 2 workbooks named DB1 and DB2.The first one involves 12 sheets sorted by months names for example:"Apr-14" ,each sheet contains a table with several columns of data descending base on days of that month with format of dd-mm-yy.Next workbook involves some calculation based on data on first one.
How can i find data in each of these sheets (DB1)based on desired date i need for calculation(whenever i want to get history) in my DB2 by VBA?