Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Copy within Excel using VBA
I am using Excel as a Contact Database. The various columns include Name,
Address, Phone, etc. The column of interest for this post is the "Birthday" Column I would like to set up a pushbutton that searches through the "Birthday" column, finds birthdays that are within the current month, and then places those names and birthdays in 2 side-by-side columns. I would also like to create one for the "next" month. I have been using the "Month" and "Find" commands combined with a For loop. I am having trouble figuring out how to place the Name and Birthday into a cell, and then place the next Name and next Birthday into another cell. I am familiar with programming, just not Visual Basic. I could use some help. This seems like an easy thing to do. Thanks in advance!! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Copy within Excel using VBA
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Search and Copy within Excel using VBA
Try something like
For i = 1 to 500 if Month(Cell(i,2)) = Month(Date) then ' code ElseIf Month(Cell(i,2)) = Month(Date) + 1 'code End If next -- steveB Remove "AYN" from email to respond "sapper44" wrote in message ... I am using Excel as a Contact Database. The various columns include Name, Address, Phone, etc. The column of interest for this post is the "Birthday" Column I would like to set up a pushbutton that searches through the "Birthday" column, finds birthdays that are within the current month, and then places those names and birthdays in 2 side-by-side columns. I would also like to create one for the "next" month. I have been using the "Month" and "Find" commands combined with a For loop. I am having trouble figuring out how to place the Name and Birthday into a cell, and then place the next Name and next Birthday into another cell. I am familiar with programming, just not Visual Basic. I could use some help. This seems like an easy thing to do. Thanks in advance!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Search and copy | Excel Discussion (Misc queries) | |||
How to search column, copy row, and copy to another sheet in same | Excel Discussion (Misc queries) | |||
Search, Copy, Paste Macro in Excel | Excel Worksheet Functions | |||
Search and copy | Excel Discussion (Misc queries) | |||
Excel Copy/Search/Paste Help Needed ASAP! | Excel Programming |