Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference
I have a tea of ten people working under me. I need to review their work.
They all save the work in a shared drive. They work is saved in folder and daily we create one folder with folde rname as date. I just pull reference in my master review file and i get data from all the ten excel sheets and i review the work. Issue is the excel becomes very slow because of these huge references. Secondly daily i have to manually change the path for these reference. Is there a batter way to do that. Can sombody suggest some code so that i can build a macro. Any suggession is valuable. Thanks! Boss |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reference
You should be able to find something here that helps you.
http://www.rondebruin.nl/tips.htm -- HTH, Barb Reinhardt "Boss" wrote: I have a tea of ten people working under me. I need to review their work. They all save the work in a shared drive. They work is saved in folder and daily we create one folder with folde rname as date. I just pull reference in my master review file and i get data from all the ten excel sheets and i review the work. Issue is the excel becomes very slow because of these huge references. Secondly daily i have to manually change the path for these reference. Is there a batter way to do that. Can sombody suggest some code so that i can build a macro. Any suggession is valuable. Thanks! Boss |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Column letter reference as number reference | Excel Programming | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |