Hi there All!
So i have looked for a similar thread and can't find, so posting my own. here goes....
I have a database that I dump into an excel spreadsheet every 6 weeks after new updates get done to the db.
So I have created a separate sheet in the workbook to make up a birthday list.
So in my sheet, "DB" I have my Data, Headers are row 5 and info only starts on row 6 (Just the way the DB exports)
In my DB sheet:
Name (Col E), Last Name (Col D), Birthday (Col M), Marital Status (Col P), Home Phone (Col R), Mobile Phone (Col S)
So Here's what I want to do,
Select Start and End Dates (Month and day only...) and it copies the data from DB sheet to the Birthday sheet
Columns A - H:
Birthdate, Name, Surname, Age (Calculated by Birthday), Martial Status, Home Phone, Mobile Phone
If it can sort by month and day of buthday it would be great?
Thank you for your time to read my request!
Matt
So i have looked for a similar thread and can't find, so posting my own. here goes....
I have a database that I dump into an excel spreadsheet every 6 weeks after new updates get done to the db.
So I have created a separate sheet in the workbook to make up a birthday list.
So in my sheet, "DB" I have my Data, Headers are row 5 and info only starts on row 6 (Just the way the DB exports)
In my DB sheet:
Name (Col E), Last Name (Col D), Birthday (Col M), Marital Status (Col P), Home Phone (Col R), Mobile Phone (Col S)
So Here's what I want to do,
Select Start and End Dates (Month and day only...) and it copies the data from DB sheet to the Birthday sheet
Columns A - H:
Birthdate, Name, Surname, Age (Calculated by Birthday), Martial Status, Home Phone, Mobile Phone
If it can sort by month and day of buthday it would be great?
Thank you for your time to read my request!
Matt