I have a file A in which a column needs to be updated daily with values from a column in file B080909. There's a new file B everyday and the name is in date format (080909).
I know i can do this with Excel/Access but im not sure how to. Can anyone guide me to the right way?
Thank you so much!!!