Hi all,
A little background on what trying to do. We have some financial sheets in sub folders of the main folder in My Documents. Currently we are copying and pasting Values from the previous year in. What I am trying to do is populate that data automatically based on the month & year of the current workbook.
Any help would be greatly appreciated.
Thanks in advance
Jeremy
A little background on what trying to do. We have some financial sheets in sub folders of the main folder in My Documents. Currently we are copying and pasting Values from the previous year in. What I am trying to do is populate that data automatically based on the month & year of the current workbook.
Any help would be greatly appreciated.
Thanks in advance
Jeremy