L
Luc
Is it possible for cells to calculate remotely? hhm, let me explain.
I have a file that has timesheet codes (around 1000). this file gets
updated (more codes added) about once a week or so.
I have a template that i use on a daily basis in which i add asign codes to
tasks i perform during the day. i'd like to be able to know when the
timesheet codes file has been updated so i can go and copy all the data and
put it in my template. (the timesheet codes is on server which i don't have
acccess to when out of the office)
I can set up formulas that do an IF function and if it changes then = 1 and
then sum all 1000 cells. if the sum is >1 i know a cell has been
modified...but this involves many formulas and makes the file very large.
I would rather have a simple formula in my template that tells me if the
timesheet codes file has been modified and i can then go and copy it accross.
make anmy sense at all? thx for any help!
I have a file that has timesheet codes (around 1000). this file gets
updated (more codes added) about once a week or so.
I have a template that i use on a daily basis in which i add asign codes to
tasks i perform during the day. i'd like to be able to know when the
timesheet codes file has been updated so i can go and copy all the data and
put it in my template. (the timesheet codes is on server which i don't have
acccess to when out of the office)
I can set up formulas that do an IF function and if it changes then = 1 and
then sum all 1000 cells. if the sum is >1 i know a cell has been
modified...but this involves many formulas and makes the file very large.
I would rather have a simple formula in my template that tells me if the
timesheet codes file has been modified and i can then go and copy it accross.
make anmy sense at all? thx for any help!