I have an excel work book and it has 5 sheets in it namely sheet1, sheet2,
sheet3,sheet4,sheet5. These excel sheets already contain some data in them .
when ever a button in an application is is clicked or a function is called
then 5 new sheets(namely sheetA, sheetB, sheetC, sheetD, sheetE) must be
added to the already existing work book in such a way that sheetA is
adjacent to sheet1, sheetB is adjacent to sheet2 and so on upto sheetE is
adjacent to sheet5. the content of these new sheets will be the output of a
sql statement . And finally the contents of the cell must be compared
between sheet1 and sheetA , sheet2 and sheetB and so on must happen and if
there is any difference then that text color of content in the cells must be
changed to red . Thanks in Advance. Regards, Satyam Reddy

Have you tried the Macro Recorder. You goto Tools\Macro\Record a Macro and
then manually do all the steps below. Excel records those steps for you and
preforms them whenever you hit Tools\Macro\Macros\"What you named it".

"Satyam Reddy" wrote:

> I have an excel work book and it has 5 sheets in it namely sheet1, sheet2,
> sheet3,sheet4,sheet5. These excel sheets already contain some data in them .
> when ever a button in an application is is clicked or a function is called
> then 5 new sheets(namely sheetA, sheetB, sheetC, sheetD, sheetE) must be
> added to the already existing work book in such a way that sheetA is
> adjacent to sheet1, sheetB is adjacent to sheet2 and so on upto sheetE is
> adjacent to sheet5. the content of these new sheets will be the output of a
> sql statement . And finally the contents of the cell must be compared
> between sheet1 and sheetA , sheet2 and sheetB and so on must happen and if
> there is any difference then that text color of content in the cells must be
> changed to red . Thanks in Advance. Regards, Satyam Reddy