Hi everyone,
i have two excel files say "mail-team1" and "mail-team2"
Both are same and the cloumn headers like date, time, mail from, content, Action taken, target, remarks.
Everytime a new mail comes, team1 will insert a row below the header and add the details (ie, recent mail is on top) from date to content in "mail-team1" file .
Action taken, target, remarks are filled by team2 in "mail-team2" file.
I need a macro that if team1 inserts 1 or more rows in "mail-team1", that will automatically updated to "mail-team2" without opening "mail-team1".
Help in this will be highly appreciated...
i have two excel files say "mail-team1" and "mail-team2"
Both are same and the cloumn headers like date, time, mail from, content, Action taken, target, remarks.
Everytime a new mail comes, team1 will insert a row below the header and add the details (ie, recent mail is on top) from date to content in "mail-team1" file .
Action taken, target, remarks are filled by team2 in "mail-team2" file.
I need a macro that if team1 inserts 1 or more rows in "mail-team1", that will automatically updated to "mail-team2" without opening "mail-team1".
Help in this will be highly appreciated...