cell comparison

S

Satyam Reddy

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
 
S

Shawn777

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".
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top