here started
09-Oct-14 08:10:34
here day data end
09-Oct-14 09:48:04
On 28 November 2014 at 12:34, daya p wrote:
> here started
> 08-Oct-14
>
> 08:10:23
> this is that day end
>
> 08-Oct-14 08:10:31
>
> On 28 November 2014 at 12:22, Mandeep Baluja
> wrote:
>
>> Do you want to get data in nex
here started
08-Oct-14
08:10:23
this is that day end
08-Oct-14 08:10:31
On 28 November 2014 at 12:22, Mandeep Baluja wrote:
> Do you want to get data in next sheet on Day wise criteria or time wise
> criteria. row you have highlighted was for 8th nov and 9 th nov .
>
>
> On Thursday, Novemb
Do you want to get data in next sheet on Day wise criteria or time wise
criteria. row you have highlighted was for 8th nov and 9 th nov .
On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote:
>
> Sir,
> good evening to all
> i need help on attached sheet
> its a machine data of finan
sir, this code from bahri in c# php something
sir pls help convert it to excel macro
thank you
GSM LAC/CID -> loc test
body {
font-family: Verdana, Helvetica, Geneva, Arial,
SunSans-Regular, sans-serif;
font-size:12;
}
td {
font-family: Verdana, Helvetica, Geneva, Arial,
SunSans-Regular
Sir,
there is no pattern
its already sorted entry
only select & copy of a date & first entered time(min time of that day) row
and last entered time ( max time of that day) copied int next sheet
upto n th data..
regards:
Daya
On 28 November 2014 at 10:54, Mandeep Baluja wrote:
> Hello daya,
>
>
Hello daya,
there is no pattern to select rows in your Data. Define the pattern first.
On Friday, November 28, 2014 10:53:00 AM UTC+5:30, daya p wrote:
>
> sir,
> there is a huge data in my file
>
> On 28 November 2014 at 10:07, Mandeep Baluja > wrote:
>
>> Sub test()
>>
>> Dim sh As Worksheet
sir,
there is a huge data in my file
On 28 November 2014 at 10:07, Mandeep Baluja wrote:
> Sub test()
>
> Dim sh As Worksheet
> Dim sh1 As Worksheet
> Dim sh2 As Worksheet
>
> Set sh1 = ActiveWorkbook.Sheets("fullData")
> Set sh2 = ActiveWorkbook.Sheets("sheet2")
>
> sh1.Select
> Range("2:2,4:4,
Sub test()
Dim sh As Worksheet
Dim sh1 As Worksheet
Dim sh2 As Worksheet
Set sh1 = ActiveWorkbook.Sheets("fullData")
Set sh2 = ActiveWorkbook.Sheets("sheet2")
sh1.Select
Range("2:2,4:4,5:5,10:10,11:11,15:15,16:16,17:17,22:22,26:26").Copy
sh2.Range("A2").PasteSpecial
End Sub
for time query ki
Hi Joseph,
PFA
Regards
Ashish
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) Use concise, accurate thread titles. Poor thread titles, like Pl
Hey Muneera,
One last change has been done in this code where I mentioned * '*Change
done here', basically it was not taking a Slash to get inside a directory.
Now it's is working fine.
Sub XLS_to_CSV()
Dim wb As Workbook
Dim SourcePath As String
Dim strFile As String, strDir As String
Dim
Hi,
Please provide VBA code based on the instructions given in the excel file.
Thanks,
Joseph
--
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
https://www.facebook.com/discussexcel
FORUM RULES
1) U
Did this worked?
On Nov 27, 2014 1:38 PM, "Vaibhav Joshi" wrote:
> Hey,
>
> put this formula in row 4 & drag
> down...=IF(SUMPRODUCT(N(A$4:A$9<=A4),N(B$4:B$9>=B4))>1,TIME(0,0,0),B4-A4)
>
>
> Cheers!!!
>
> +
> *I did not do this for you. God is here working through me for you.*
>
> On Wed, Nov
Sir,
good evening to all
i need help on attached sheet
its a machine data of finance bill collection
in attached file some sample data of customers data
Q) first customer & last customer detail automatically copy into next sheet
like i highlighted with yellow color those row copied into next shee
Replace source line with this
Set j = Application.FileDialog(msoFileDialogFolderPicker)
j.Show
SourcePath = j.SelectedItems(1)
On Wednesday, November 26, 2014 4:40:03 PM UTC+5:30, Muneera Shabana wrote:
>
> Good Morning,
>
> Hope you are having a great day!
>
> *Objecti
Thanks Mandeep
But I dont to define the source path, rather browse and open the folder for
converting the files.
please help!
On Wednesday, 26 November 2014 12:57:30 UTC+1, Mandeep Baluja wrote:
> Sub XLS_to_CSV()
>
> Dim wb As Workbook
> Dim strFile As String, strDir As String
>
> SourcePat
Pl share the workbook with us
On Thu, Nov 27, 2014 at 2:56 PM, Shrinivas Shevde
wrote:
> Dear All
> Please find below macro.
> Previously it was running very fine but from last few days it takes time (2
> to 3 min).I could not trace out can any one help me for finding out
> problem.
>
> Macro is
Dear All
Please find below macro.
Previously it was running very fine but from last few days it takes time (2
to 3 min).I could not trace out can any one help me for finding out
problem.
Macro is just for copying some data from one sheet and paste to other shhet
and removes unwanted column
Sub B
Hey,
put this formula in row 4 & drag
down...=IF(SUMPRODUCT(N(A$4:A$9<=A4),N(B$4:B$9>=B4))>1,TIME(0,0,0),B4-A4)
Cheers!!!
+
*I did not do this for you. God is here working through me for you.*
On Wed, Nov 26, 2014 at 9:51 AM, son nguyen wrote:
> Hi Paul,
>
> I'm sorry as my past explain
18 matches
Mail list logo
