| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Modified:- Macro to Generate a new Column!!!
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. I need it Urgently... Plz Help!!!!!! thanx n regards Inder |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Modified:- Macro to Generate a new Column!!!
This is not clear to me, but maybe something like
If Range("A2").Value TimeSerial(10,0,0) then Columns(2).Insert Range("B2").Value = TimeSerial(11,0,0) End If -- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Inder" wrote in message ups.com... 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. I need it Urgently... Plz Help!!!!!! thanx n regards Inder |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Last Modified date on cell or column | Excel Discussion (Misc queries) | |||
| Macro to generate a new column denpending upon existing one! | Excel Worksheet Functions | |||
| Macro to generate a file from another | Excel Worksheet Functions | |||
| In Excel can you have a cell generate the last dated modified?? | Excel Discussion (Misc queries) | |||
| How to record macro to print pages modified today | Excel Worksheet Functions | |||
Hybrid Mode
