Hi everybody,
I need your help with that task:
I've got a summary workbook which contain information about daily performance of lines in one of the department in my factory.
Informations are coming from daily files - called with this format "MBmmdd", where MB means code of department, mm is month and dd is of course day; for example for
6th June it will be MB0606.
I made formulas (VLOOKUP) to pull out info from daily file into the summary workbook but the problem is that every day I need to copy the formula from day before and change name of source file in that formula plus daily input files can't be generated up front so if I want to prepare formulas up front source files doesn't exist so I need to do a lot of ESCaping if you no what I mean.
What I am looking for is a macro which will automatically create formulas for all blank columns up to day before (because info is one day backdated and today we are inputting data for yesterday and so on), saving my time on copying and then changing the name of source file in the formulas.
I want macro to create formulas only for those columns which are blank because some of the formulas after some time I am replacing with "values only" to prevent file from growing to big.
Is this even possible?
Thanks in advance for any help.
PS. I have uploaded sample summary workbook with formulas I am using so maybe that will help and better explain what I am trying to get.
Bookmarks