Macro to generate a new column denpending upon existing one!
 

hi
my query is regarding Macros in Excelsheet! i have already an excel
report generated from a VB application. which is Protected.. i mean
it is
unedittable.i want to add few more columns in that report ..
depdending upon a condition enforced on already existing columns in
the excel report.
for example...
TimeIn TimeOut
10.01.00 AM 06.00.00 PM

Above 2 r already existing fields in excel report. i want to generate
a column depdending upon a condition enforced on the values in above 2
fields.
Suppose i want to generate a column with the condition as follows
If(TimeIn10)
if the above condition is true then a new column should get generated
with its true value as 11.00.00 AM.

thanx n regards
Inder

Macro to generate a new column denpending upon existing one!
 

On Jul 10, 11:29 am, Inder wrote:
hi
my query is regarding Macros in Excelsheet! i have already an excel
report generated from a VB application. which is Protected.. i mean
it is
unedittable.i want to add few more columns in that report ..
depdending upon a condition enforced on already existing columns in
the excel report.
for example...
TimeIn TimeOut
10.01.00 AM 06.00.00 PM

Above 2 r already existing fields in excel report. i want to generate
a column depdending upon a condition enforced on the values in above 2
fields.
Suppose i want to generate a column with the condition as follows
If(TimeIn10)
if the above condition is true then a new column should get generated
with its true value as 11.00.00 AM.

thanx n regards
Inder

Can any body ... help me out! i need it urgent!