searching all workbook sheets

J

jamie

i have 2 workbooks

workbook1 has in each sheet in cell a1 has a date of the 1st of each month
in a year. workbook2, a cell needs to look at find data in workbook1, if date
in a1 are the current month and year, day does not matter, carry out a task,
i am not sure how to look in each cell of a workbook though, please could you
advise?

thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

searching all sheets in a wb 0
Open UserForm From A Different Workbook 17
Calendar Logic: Recurring Dates 3
Using VLookup with 2 Workbooks 0
Search & insert 6
Using VB to pull formats and data from another workbook 0
use month in cell date to sum all relevant cells 2
YTD SUMIF based on current date 3

Top