Home |
Search |
Today's Posts |
#1
|
|||
|
|||
extract date from the most current date
Hi I want to pull data from various spreadsheets but only for the current
date. For example I have a numerous spreadsheets that contains data for 4/1, 4/2, 4/3...etc. This data is inputted daily for each date. There is specific data that I would like to pull from the most current date and so on into the future only getting data from the current date. I want to run a macro that pulls data from the most current date of each excel spreadsheet or automate the excel spreadsheet to pull from the most current date. Is this at all possible? |
#2
|
|||
|
|||
I've attached a simple example of one way to extract data matching a date
criterion to a new list. -- Jim "Cali00" wrote in message ... | Hi I want to pull data from various spreadsheets but only for the current | date. For example I have a numerous spreadsheets that contains data for 4/1, | 4/2, 4/3...etc. This data is inputted daily for each date. There is | specific data that I would like to pull from the most current date and so on | into the future only getting data from the current date. I want to run a | macro that pulls data from the most current date of each excel spreadsheet or | automate the excel spreadsheet to pull from the most current date. Is this | at all possible? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
formula IF returning current date | Excel Worksheet Functions | |||
extract numbers, convert to date | Excel Discussion (Misc queries) | |||
Calculating days between current date and a date in future NETWORKDAYS() function | Excel Worksheet Functions | |||
Lock in current date | Excel Discussion (Misc queries) | |||
How do I program a cell to automaticinput the current date as dat. | Excel Worksheet Functions |