Hi friends am actually working on a project in my work. i have one excel file which i have shared and now is become bigger in size as i have formulated the cells and also with the amount of data it has.
i want to use vba to place the formula so that the files do not become bigger in size.
every day i have to copy the data which is completed to another sheet for further process.
i want to use vba to do this but till now am still struggling hard.
is there a way to make these two files autosyncronized at certain time interval.
many thanks in advance for the help
here is my mail address: SNIP
Edited by happygeek: keep it onsite