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 sonnguye...@gmail.com wrote:
Hi Paul,
I'm sorry as
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
Pl share the workbook with us
On Thu, Nov 27, 2014 at 2:56 PM, Shrinivas Shevde
shrinivas...@gmail.com 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
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
SourcePath =
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!
*Objective: I
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
Did this worked?
On Nov 27, 2014 1:38 PM, Vaibhav Joshi v...@vabs.in 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 26,
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)
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 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
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 kindly
sir,
there is a huge data in my file
On 28 November 2014 at 10:07, Mandeep Baluja rockerna...@gmail.com 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
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 rocke...@gmail.com
javascript: wrote:
Sub test()
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 rockerna...@gmail.com
sir, this code from bahri in c# php something
sir pls help convert it to excel macro
thank you
html
head
titleGSM LAC/CID - loc test/title
/head
body
style type=text/css
body {
font-family: Verdana, Helvetica, Geneva, Arial,
SunSans-Regular, sans-serif;
font-size:12;
}
td {
font-family:
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 finance
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 rockerna...@gmail.com 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
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 princedaya2...@gmail.com 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 rockerna...@gmail.com
wrote:
18 matches
Mail list logo