machunt
02-25-2012, 12:25 AM
Hello Forum,
This is my first post.
I have a problem and was wondering if this could be possible using excel.
I have a folder on my network drive month wise containing various excel files, some are 10 some 12 and some even around 40.
I have a file ( called Rate ), which I update manually on the beginning of every month. What I want is some thing Macro or VBA button that will simply update all the numbers and percentage ( which is present in my rate workbook ) to a specific month. For example Jan.
The common part is that a sheet called "PI Rate" is present im my desktop file (called Rate) as well as in all the files in the folders in the network. I want this sheet to be updated only without disturbing any other sheet.
Is it possible.
Thanking you.
Mac
This is my first post.
I have a problem and was wondering if this could be possible using excel.
I have a folder on my network drive month wise containing various excel files, some are 10 some 12 and some even around 40.
I have a file ( called Rate ), which I update manually on the beginning of every month. What I want is some thing Macro or VBA button that will simply update all the numbers and percentage ( which is present in my rate workbook ) to a specific month. For example Jan.
The common part is that a sheet called "PI Rate" is present im my desktop file (called Rate) as well as in all the files in the folders in the network. I want this sheet to be updated only without disturbing any other sheet.
Is it possible.
Thanking you.
Mac