If this is your first visit, then welcome! Be sure to check out the FAQ by clicking the link above.Register here so that you can post in the forums or comment on the articles.
try: Click on the picture to get a clearer view. Oops, fotrgot the code:
Private Sub DateFormat() Dim myRange As Range
Try this
Private Sub DateFormat() Dim myRange As Range Dim Celda As Range Set myRange = Range("B2:B14")
A pivot table would work. If not, you need to have a macro as with VLOOPUP you do not kown how many rows will have each sheet....
Which information are you puling? If it is not thw alloed data type, you should unprotect the sheet. If not, try to pull information to a new spreadsheet....
Start by identifying each row, not only one out of 3 and then use SUMIF...
Knowledge Base Articles By Category
Recent Forum Posts
Check cell format is Date ignore blank cells
try:
Click on the picture to get a clearer view.
Oops, fotrgot the code: