I need a macro code which update existing excel sheet on daily basis by running macro report.Two columns are date & no of count in the report for each data provider under different report tab.so i need to update each row of excel date wise.Let say for 2010-05-10 it will update one row and corresonding count and for next date 2010-05-11 it should update next row & count of same sheet.There are 5 sheets in the same excel.
Can any one help me on this? 
HelpLine (BOB member since 2010-05-11)
(BOB member since 2003-11-27)