Bryan_Geo
02-04-2020, 09:47 AM
Hello.
I do apologize if this has been asked before.I did try to find a similar question.
I am looking to get a VBA code that will extract data from one spreadsheet to another.
the criteria is it will copy the whole row based on a new date that queries the other spreadsheet.
Eg. 1 01/12/1990
1 05/05/2001
1 04/19/2008
2 06/20/2001
2 09/20/2009
2 12/01/2010
the ones and twos being a repeating common ID with a date. On the extraction sheet there will be the exact same common ID but with a newer date.
any help or guidance is greatly appreciated.
I do apologize if this has been asked before.I did try to find a similar question.
I am looking to get a VBA code that will extract data from one spreadsheet to another.
the criteria is it will copy the whole row based on a new date that queries the other spreadsheet.
Eg. 1 01/12/1990
1 05/05/2001
1 04/19/2008
2 06/20/2001
2 09/20/2009
2 12/01/2010
the ones and twos being a repeating common ID with a date. On the extraction sheet there will be the exact same common ID but with a newer date.
any help or guidance is greatly appreciated.