Macro to generate a new column denpending upon existing one!

I

Inder

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(TimeIn>10)
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
 
I

Inder

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(TimeIn>10)
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
Click to expand...

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

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

Similar Threads

Modified:-> Macro to Generate a new Column!!! 1
Modified:-> Macro to Generate a new Column!!! 1
Generate Correlated variable to an existing data set 1
Matching a column of new data to existing larger data set. 1
Formula to sum based on a change in another column 2
Add column with data to an existing table 8
Excel macro to copy the rightmost column to a new column 2
query to show where no data in a stated column 0

Top