V
Vikram Dhemare
Hello Everybody,
I have a workbook wherein have a imported web page text formated data. In
the same workbook
I have another sheet named "Dbase", wherein I use to keep the web data as a
database by using
copy paste vba code. Web page having fields like Date & Time. In Col F,
having the name "DesiredDate",
I want the result - if time in Col. C is less than "06:30:00 AM", then the
DesiredDate in Col F of
that particular row should be (Date - 1). For Example if Cell B7 having text
like 28.10.2006 & Cell C7
having time of "6:12:38 am", then value Cell F7 should be 27/10/2006 & if
Cell C7 having text like
28.10.2006 & Cell C7 having time of "6:31:55 am" then the answer in Cell F7
should be 28/10/2006.
The Sheet Dbase having data almost about 50'000 rows i.e. from 01.04.2006 to
28.10.2006. Hope this is clear.
SOme contents from table given below :
Col A Col B Col C ColE Col F Col F
VIN Date Time TPS Part No DesiredDate
152323 27.10.2006 23:58:30 STD ATM0112 27/10/2006
152324 27.10.2006 23:59:54 STD ATM0112 27/10/2006
152432 28.10.2006 3:30:23 STD ATM0112 27/10/2006
152434 28.10.2006 4:16:00 STD ATM0112 27/10/2006
152482 28.10.2006 6:12:38 STD ATM0112 27/10/2006
152483 28.10.2006 6:31:55 STD ATM0112 28/10/2006
152486 28.10.2006 6:35:41 STD ATM0861 28/10/2006
Help in this regard will be highly appreciated. Thanks in advance.
I have a workbook wherein have a imported web page text formated data. In
the same workbook
I have another sheet named "Dbase", wherein I use to keep the web data as a
database by using
copy paste vba code. Web page having fields like Date & Time. In Col F,
having the name "DesiredDate",
I want the result - if time in Col. C is less than "06:30:00 AM", then the
DesiredDate in Col F of
that particular row should be (Date - 1). For Example if Cell B7 having text
like 28.10.2006 & Cell C7
having time of "6:12:38 am", then value Cell F7 should be 27/10/2006 & if
Cell C7 having text like
28.10.2006 & Cell C7 having time of "6:31:55 am" then the answer in Cell F7
should be 28/10/2006.
The Sheet Dbase having data almost about 50'000 rows i.e. from 01.04.2006 to
28.10.2006. Hope this is clear.
SOme contents from table given below :
Col A Col B Col C ColE Col F Col F
VIN Date Time TPS Part No DesiredDate
152323 27.10.2006 23:58:30 STD ATM0112 27/10/2006
152324 27.10.2006 23:59:54 STD ATM0112 27/10/2006
152432 28.10.2006 3:30:23 STD ATM0112 27/10/2006
152434 28.10.2006 4:16:00 STD ATM0112 27/10/2006
152482 28.10.2006 6:12:38 STD ATM0112 27/10/2006
152483 28.10.2006 6:31:55 STD ATM0112 28/10/2006
152486 28.10.2006 6:35:41 STD ATM0861 28/10/2006
Help in this regard will be highly appreciated. Thanks in advance.