S
Satyam Reddy
The coding is to be done in VBSCRIPT OR VB .
I have an excel work book and the work book contains 3 excel sheets namely
sheet1, sheet2, sheet3. All these sheets contain data in them . when a button
is clicked or when a function is called then 3 new excel sheets namely
sheetA, sheetB, sheetC - are to be added to the existing workbook such that
sheetA is adjacent to sheet1, sheetB is adjacnet to sheet2, sheetC is
adjacent to sheet3. The content of the new sheets will be the output of an
SQL statement(generally the select statement). Now the content of sheet1 and
sheetA , sheet2 and sheetB , sheet3 and sheetC must be done and if there is
any difference then the text in the cell which is different must be marked
with red .
Thanks in advance.
Regards,
Satyam Reddy
I have an excel work book and the work book contains 3 excel sheets namely
sheet1, sheet2, sheet3. All these sheets contain data in them . when a button
is clicked or when a function is called then 3 new excel sheets namely
sheetA, sheetB, sheetC - are to be added to the existing workbook such that
sheetA is adjacent to sheet1, sheetB is adjacnet to sheet2, sheetC is
adjacent to sheet3. The content of the new sheets will be the output of an
SQL statement(generally the select statement). Now the content of sheet1 and
sheetA , sheet2 and sheetB , sheet3 and sheetC must be done and if there is
any difference then the text in the cell which is different must be marked
with red .
Thanks in advance.
Regards,
Satyam Reddy