Dave
What is "current month"? Is that a workbook? A sheet? A column in a
sheet? A row in a sheet? Understand that you are the only person who knows
what you have and what you want. HTH Otto

"dave303159" wrote in message
...
i want to pull data from another workbook into a workbook. what formula
can
i use that will pull only data from the current month that has data in it?