2 sheets, shtClient1 and ShtData...
ShtData gets new data imported to it daily, the new replaces the old, it comes from an acces query that filters the max date for each month, so right now i have 6/30/01, 7/31/01, 8/30/01, 9/30/01 and 10/12/01. tomorrow it will be the same except 10/15/01, instead of 10/12/01.
the data that is imported has a company code and some other info. ShtClient1, only has 12 rows, one for each month. i am trying to do some sort of lookup that it will look for the company code and match it with the month and pull the other data, (i will have a seperate sheet for each client) but the problem i am running into is that on ShtData it is in the format 10/12/01 and shtClient1 i need the format to be in months only ie. "October" Any suggestions?
Thanks,
Smiley B-)
ShtData gets new data imported to it daily, the new replaces the old, it comes from an acces query that filters the max date for each month, so right now i have 6/30/01, 7/31/01, 8/30/01, 9/30/01 and 10/12/01. tomorrow it will be the same except 10/15/01, instead of 10/12/01.
the data that is imported has a company code and some other info. ShtClient1, only has 12 rows, one for each month. i am trying to do some sort of lookup that it will look for the company code and match it with the month and pull the other data, (i will have a seperate sheet for each client) but the problem i am running into is that on ShtData it is in the format 10/12/01 and shtClient1 i need the format to be in months only ie. "October" Any suggestions?
Thanks,
Smiley B-)
