better thank this from any expert ?
On 28 November 2014 at 18:11, daya p wrote:
> thank you sir
>
> On 28 November 2014 at 16:33, Mandeep Baluja
> wrote:
>
>>
>> Kindly find the solution i have used two helper column and a macro.
>>
>> Regards,
>> Mandeep Baluja
>> Excel Specialist.
>> https://
thank you sir
On 28 November 2014 at 16:33, Mandeep Baluja wrote:
>
> Kindly find the solution i have used two helper column and a macro.
>
> Regards,
> Mandeep Baluja
> Excel Specialist.
> https://www.linkedin.com/profile/view?id=312532939
> https://www.facebook.com/VBAEXCELSQL?ref=hl
>
>
>
>
>
Kindly find the solution i have used two helper column and a macro.
Regards,
Mandeep Baluja
Excel Specialist.
https://www.linkedin.com/profile/view?id=312532939
https://www.facebook.com/VBAEXCELSQL?ref=hl
On Thursday, November 27, 2014 8:00:57 PM UTC+5:30, daya p wrote:
>
> Sir,
> good even
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,
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
10 matches
Mail list logo
