Re: $$Excel-Macros$$ Fwd: Need your Help on Priority

[Pankaj Sharma]

Didn't get your query, what you want to do in this sheet, pls mention
example with result.



*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

On Tue, Feb 28, 2017 at 9:22 PM, Mohd Sadiq  wrote:

> Hello Team ,
>
>
>
>
> Hope you are doing well,
>
>
>
> Here is attached a file where I need Interval / Day wise staffing which is
> mentioned in “H” Column, I am trying it multiple times to fixed Night Shift
> issue but unfortunately I’m not getting resolution L
>
>
>
> Request you to Pls help on the same on priority.
>
>
>
>
>
>
> Regards
> Mohd Sadiq
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ $$Help Required$$

[Pankaj Sharma]

use this:

={IFERROR(VLOOKUP($A3$1,CHOOSE({1,2},$M$13:$M$22&$O$13:$O$22,$N$13:$N$22),2,0),0)}



*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

On Sat, Jun 18, 2016 at 9:50 PM, Neeraj Chauhan 
wrote:

> Dear Experts,
>
>
>
> Kindly find the attached sheet I want reduce or addition amount against
> particular Indus id and date wise.
>
> Kindly give me solution
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book68 solve.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Comine Text

[Pankaj Sharma]

chk



*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

On Sat, Apr 2, 2016 at 11:20 PM, vickey  wrote:

>
>
> Hi,
>
> Please help me out to solve this problem, I have following table. Now what
> I want to have result as third column "Combine".
>
> Srn Name Combine
> 1 A A, B, C
> B
> C
> 2 D D, E
> E
> 3 F F, G, H, I, J
> G
> H
> I
> J
> 4 K K
> 5 O O, P
> P
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Combine.xls
Description: MS-Excel spreadsheet

$$Excel-Macros$$ Re: Need help Using Isblank and days360 in Macro

[Pankaj Sharma]

Hi Maju,,,i think if you provide some example sheet, you will get your 
answer very soon.


 



On Wednesday, March 9, 2016 at 8:23:53 PM UTC+5:30, Maju wrote:
>
> Hello all!
>
>  
>
> Please I need macro help with the below in red: 
>
> What is the best way to achieve this without using the formula that I got 
> from running the macro and also making the code short? I have already 
> completed the Sum in column AH
>
>  
>
>  
>
>1. 
>
>Column AI to the last row should have the below :
>
> =IF(ISBLANK(I2)," ",YEAR(I2+184)) this in VBA is 
>
> ActiveCell.FormulaR1C1 = "=IF(ISBLANK(RC[-29]),"" "",YEAR(RC[-29]+184))"
>
>
>  2 Column AJ to the last row should have the below
>
> =IF(ISBLANK(G2)," ",IF(ISBLANK(I2)," ",DAYS360(G2,I2)))  this in VBA is
>
> "=IF(ISBLANK(R[-1]C[-31]),"" "",IF(ISBLANK(R[-1]C[-29]),"" 
> "",DAYS360(R[-1]C[-31],R[-1]C[-29])))"
>
>  
>
> 3. Column AK to the last row should have the below
>
> =IF(ISBLANK(I2)," ",DAYS360(I2,TODAY()))this in VBA is
>
> "=IF(ISBLANK(R[-2]C[-29]),"" "",DAYS360(R[-2]C[-29],TODAY()))"
>
>  
>
>  
>
> This is summing the value in Ah
>
>   Dim CurCell As Object
>
>   'Summing severals rows and putting the value in column AH
>
>   For Each CurCell In Range("ah2:ah" & Cells(Rows.Count, 
> "B").End(xlUp).Row)
>
>   CurCell.Value = CurCell.Offset(0, -10).Value _
>
>   + CurCell.Offset(0, -9).Value + CurCell.Offset(0, 
> -8).Value + CurCell.Offset(0, -7).Value + CurCell.Offset(0, -6).Value
>
> CurCell.NumberFormat = "_($* #,##0.00_);_($* (#,##0.00);_($* 
> ""-""??_);_(@_)"
>
> Next
>
>  
> Thanks
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Re: GOAL SEEK

[Pankaj Sharma]

Hi buddy,

Find the below link to understand Goal Seek basic... 

https://youtu.be/7QIBvMPC9vM




 
*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*   
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj 
*

  
*We meet for a reason, either you're a blessing or a lesson...*

On Thursday, March 10, 2016 at 8:13:14 PM UTC+5:30, GENIUS wrote:
>
> in the attachment I have a macro in which  GOAL SEEK has been specified.   
> can anyone explain it to me how the figures in column E calculated when we 
> press GOAL SEEK button
> in another word, I want to understand  how this macro has been written
>
>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Fwd: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

[Pankaj Sharma]

Hi Dev,, little long process but working as per your requirement.

Check this out 


Option Explicit

Sub SortRangeData()

Dim sh1 As Worksheet, sh2 As Worksheet
Dim rng1 As Range, rng2 As Range, rng As Range, data As Range
Dim arr As Variant, arr2 As String, txt As String
Dim i As Long
Set sh1 = ActiveSheet

On Error Resume Next
Set data = Application.Selection
Set data = Application.InputBox("Selet Data", Type:=8)

Application.DisplayAlerts = False
Application.ScreenUpdating = False

For Each rng1 In data
arr = VBA.Split(rng1, ",")
Worksheets.Add after:=Sheets(Sheets.Count)
Set sh2 = ActiveSheet
For i = 0 To UBound(arr)
sh2.Cells((i + 1), 1).Value = arr(i)
Next i

sh2.Range("A1", Range("A" & Rows.Count).End(xlUp)).Select
With Selection
sh2.Sort.SortFields.Clear
sh2.Sort.SortFields.Add Key:=Range("A1"), Order:=xlAscending
End With
With sh2.Sort
.SetRange Selection
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
For Each rng In Selection
txt = rng & ","
arr2 = arr2 & txt
Next rng
sh2.Delete
rng1.Value = arr2
arr2 = ""
Next rng1
If ActiveSheet.Name <> sh1.Name Then sh1.Activate

Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub












*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

-- Forwarded message --
From: Devendra Sahay 
Date: Fri, Jan 15, 2016 at 2:35 PM
Subject: Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell
To: excel-macros@googlegroups.com


Hi Mandeep,

Please revert, as I am facing a big issue because of this.

Thanks


On Fri, Jan 15, 2016 at 11:33 AM, Devendra Sahay <
devendrasahanypt...@gmail.com> wrote:

>  Hi Mandeep,
>
> Please revert.
>
>
> On Thu, Jan 14, 2016 at 5:37 PM, Devendra Sahay <
> devendrasahanypt...@gmail.com> wrote:
>
>> Hi,
>>
>> I dont want to sort column a, I want to sort the comma separated data
>> alphabetically & numerically in column 2.
>>
>> but the code which i have shared, it shorts the data of column a & b
>> both, So all the data shuffled
>>
>> This is the required format of the data.
>>
>> Col 1Col 2
>> A10,15,5 year,8year
>> B15,17,20year
>> D12,30,50 year
>>
>>
>>
>> On Thu, Jan 14, 2016 at 5:27 PM, Mandeep Baluja 
>> wrote:
>>
>>>   Hey Devendra,
>>>
>>> Asked for output format? your query is not understandable. data shuffled
>>> all the data ??,
>>>
>>> Show me the output you require for this data given below :-
>>>
>>> Col 1Col 2
>>> A10,8year,5 year,15
>>> B15,20year,17
>>> D30,50 year,12
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>>
>> With Regard !!!
>> Devendra Rahi
>>
>>
>
>
> --
>
> With Regard !!!
> Devendra Rahi
>
>


-- 

With Regard !!!
Devendra Rahi

-- 
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 Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not 

Re: $$Excel-Macros$$ Sorting Comma Separated Values in a cell

[Pankaj Sharma]

Result type2 is here:


Sub SortRangeData2()

Dim sh1 As Worksheet, sh2 As Worksheet
Dim rng1 As Range, rng2 As Range, rng As Range, data As Range
Dim arr As Variant, arr2 As String, txt As String
Dim i As Long, lr As Long
Set sh1 = ActiveSheet

On Error Resume Next
Set data = Application.Selection
Set data = Application.InputBox("Selet Data", Type:=8)

Application.DisplayAlerts = False
Application.ScreenUpdating = False

Worksheets.Add after:=Sheets(Sheets.Count)
Set sh2 = ActiveSheet

For Each rng1 In data
arr = VBA.Split(rng1, ",")
For i = 0 To UBound(arr)
sh2.Cells((i + 1), 1).Value = arr(i)
sh2.Cells((i + 1), 2).FormulaR1C1 = "=LEN(RC[-1])"
Next i

lr = sh2.Range("A" & Rows.Count).End(xlUp).Row
sh2.Range("A1:B" & lr).Select
With Selection
sh2.Sort.SortFields.Clear
sh2.Sort.SortFields.Add Key:=Range("B1"), Order:=xlAscending
sh2.Sort.SortFields.Add Key:=Range("A1"), Order:=xlAscending
End With

With sh2.Sort
.SetRange Selection
.Header = xlNo
.MatchCase = False
.Orientation = xlTopToBottom
.SortMethod = xlPinYin
.Apply
End With
sh2.Range("D1").Select

sh2.Range("A1:A" & lr).Select
For Each rng In Selection
txt = rng & ","
arr2 = arr2 & txt
Next rng

sh2.Range("A1:B" & lr).Clear
rng1.Offset(0, 2).Value = arr2
arr2 = ""
Next rng1

sh2.Delete
If ActiveSheet.Name <> sh1.Name Then sh1.Activate

Application.DisplayAlerts = True
Application.ScreenUpdating = True

End Sub






*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
*


*We meet for a reason, either you're a blessing or a lesson...*

On Fri, Jan 15, 2016 at 6:02 PM, Mandeep Baluja 
wrote:

> Hey Devendra,
>
> This code made me insane :*0,Let me tell you why ??
> 1) Numerous of Keywords Integers,Y,Years,SR Doesn't understood the meaning
> what they are denoting Except years.
> 2) Took(Almost 2.5 hour).
>
> Sorting is easy when all are numbers but difficult when Text values !!
> the previous code you were using was doing nothing like sorting they are
> just comparing on the basis of Text values That code was comparing Text
> values like 10-12 years,11-15 years in which 10,10years,15 years in which 1
> comes first and they are providing you the same.
>
> I Tried my best to solve your problem but this code will gives you
> different result if your Data keywords will change.
>
> I followed this way for Sorting if I go as per sorting rule of numbers !!
> Sorting -Way ->>> Interger--->then> Y values> years values
> --->Rest of values(which are not integer not years,not Y God knows What
> they are)
>
> Here's the code !!! Note this code very specific for keywords you have
> provided to me Y,Years,Integers,SR,Normal
>
>
> Sub SOA()
>
> On Error Resume Next
>
> Application.ScreenUpdating = False
>
> Dim ws As Worksheet
> Dim counter As Long: counter = 1
> Dim Nrows  As Long
>
> Set ws = ActiveWorkbook.Sheets("Sheet3")
> Set ws1 = ActiveWorkbook.Sheets("Data")
>
> Nrows = ws1.Cells(Rows.Count, 2).End(xlUp).Row 'Get no of rows
>
> For Rownum = 2 To Nrows
>  ws.Cells.ClearContents 'Clear the rough sheet
>Set temp = Nothing 'A variable to hold the result
>
> Dim varout1() As Variant
> Dim varout() As Variant
>
> var1 = Split(ws1.Cells(Rownum, "B"), ",")
> For i = LBound(var1) To UBound(var1)
> If IsNumeric(var1(i)) Then
> ReDim Preserve varout1(1 To counter)
> varout1(counter) = var1(i)
> counter = counter + 1
> End If
> Next
> Sheets("sheet3").Range("a1").Resize(UBound(varout1), 1) =
> Application.Transpose(varout1)
>
> '
> counter = 1
> Debug.Print ws1.Cells(Rownum, "B")
> var1 = Split(ws1.Cells(Rownum, "B"), ",")
> For i = LBound(var1) To UBound(var1)
> If Right(var1(i), 1) = "Y" Then
> ReDim Preserve varout1(1 To counter)
> varout1(counter) = var1(i)
> counter = counter + 1
> End If
> Next
> Sheets("sheet3").Range("c1").Resize(UBound(varout1), 1) =
> Application.Transpose(varout1)
> Sheets("sheet3").Range("D1").Resize(UBound(varout1), 1) =
> Application.Transpose(varout1)
> '-
> counter = 1
> var1 = Split(ws1.Cells(Rownum, "B"), ",")
> For i = LBound(var1) To UBound(var1)
> If 

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

[Pankaj Sharma]

check this out !!!



*PJ  *

*MIS Analyst*


*Greater Kailash-1, New Delhi.*

*Instagram*  *pj_sharma_*

*Tweeter*
*dude_sharma_pj**Facebook**   www.facebook.com/dude.pj
<http://www.facebook.com/dude.pj>*


*We meet for a reason, either you're a blessing or a lesson...*

On Wed, Jan 13, 2016 at 6:04 PM, mohd sadiq <mohdsadiq...@gmail.com> wrote:

> Team , Please help to closed it on priority
>
> On Fri, Jan 8, 2016 at 2:03 PM, mohd sadiq <mohdsadiq...@gmail.com> wrote:
>
>> Opsss , sorry
>>
>> PFA the same.
>>
>> On Thu, Jan 7, 2016 at 7:16 PM, Pankaj Sharma <pankaj123...@gmail.com>
>> wrote:
>>
>>> where is the attachment. ???
>>>
>>>
>>>
>>> *Pankaj Sharma  *
>>>
>>> *MIS Analyst*
>>>
>>> *Greater Kailash-1, New Delhi*
>>>
>>> *Email   *
>>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>>
>>>
>>>
>>>
>>> On Thu, Jan 7, 2016 at 6:52 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>> wrote:
>>>
>>>> Dear Pankaj ,
>>>>
>>>> I have one more query on this .
>>>>
>>>> Request you to please refer the attached mail for your easy referece.
>>>>
>>>>
>>>> On Wed, Jan 6, 2016 at 9:08 PM, Pankaj Sharma <pankaj123...@gmail.com>
>>>> wrote:
>>>>
>>>>> it's already done i think.. pfa
>>>>>
>>>>>
>>>>>
>>>>> *Pankaj Sharma  *
>>>>>
>>>>> *MIS Analyst*
>>>>>
>>>>> *Greater Kailash-1, New Delhi*
>>>>>
>>>>> *Email   *
>>>>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>>>>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Wed, Jan 6, 2016 at 6:15 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Dera Team ,
>>>>>>
>>>>>> Please help on the same
>>>>>>
>>>>>> On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>>>>> wrote:
>>>>>>
>>>>>>> Hello Pankaj ,
>>>>>>>
>>>>>>> Pls help on the same
>>>>>>>
>>>>>>> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>>>>>> wrote:
>>>>>>>
>>>>>>>> Hello ,
>>>>>>>>
>>>>>>>> I need put Week OFF (WO) basis of attached excel (Day wise WO
>>>>>>>> count) (Excel attached with your reference.( if change day wise Week 
>>>>>>>> OFF
>>>>>>>> count then it should be automatically changed in Roster sheet.
>>>>>>>>
>>>>>>>> Example-
>>>>>>>>
>>>>>>>> We have 20 agents in a Shift and we need to give Weekly OFF to
>>>>>>>> everyone basis of attached sheet but WO should not be repeat more than 
>>>>>>>> one.
>>>>>>>>
>>>>>>>> *Sample- *
>>>>>>>>
>>>>>>>> Shift Timing-- 05:00-14:00
>>>>>>>> Shift Count -- 20
>>>>>>>>
>>>>>>>> We can give Weekly OFF basis of Following days count.
>>>>>>>>
>>>>>>>> Monday-3
>>>>>>>> Tue- 3
>>>>>>>> Wed-2
>>>>>>>> Thu-2
>>>>>>>> Fri-2
>>>>>>>> Sat-3
>>>>>>>> Sun-5
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Regards
>>>>>>>> Mohd Sadiq
>>>>>>>> E-mail :- mohdsadiq...@gmail.com
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> Regards
>>>

Re: $$Excel-Macros$$ Correction required in highlet cell & refresh d15 automatically when last any entry of any raw change

[Pankaj Sharma]

in Conditional formatting use formula:

=AND($F5>=TODAY(),$F5<=TODAY()+14)

Applied to :
=$A$5:$AI9



and secondly in Function GetConcat formula coding use :

Application.Volatile

for Auto refresh





*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Sun, Jan 10, 2016 at 1:27 PM, Pankaj Sharma <pankaj123...@gmail.com>
wrote:

> Check it !
>
>
> *Pankaj Sharma  *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>
>
>
>
> -- Forwarded message --
> From: big smile <bigsmile...@gmail.com>
> Date: Sun, Jan 10, 2016 at 11:19 AM
> Subject: $$Excel-Macros$$ Correction required in highlet cell & refresh
> d15 automatically when last any entry of any raw change
> To: excel-macros@googlegroups.com
>
>
>
>
>
> Respected All
>
> I have attached excel files too  It has some still issue . I think there
> is some correction required   in the formula  1]  When  F column falls
> under 15 days before today -- only that time full raw should be yellow  Today
> is 9/1/2016  so any date from 9/1/2016 to 24/1/16 -- then only full raw
> should be yellow  But at present it happens even if due date is before
> today also -- ex  f6 is  15/12/2015  then also it become yellow 2] In
> Cell - D 15  not work according to my question  If I make any changes in
> any cell   ex -- If I make the change in Raw 9 In stead of mediclaim I
> put shop in e9 also  change in R 9 -- some change  Then all the details
> pertaining -- respectively  change in D 15 at present it not change for D
> 15 3] I have to refesh my cell entry then It show change I want that if I
> make any changes in any raw  then last updated raw details  then it
> should automatically updates all  details of that raw  & show it on Cell
> D15 Thanks in advance
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Fwd: $$Excel-Macros$$ Refresh d15 automatically when last any entry of any raw change

[Pankaj Sharma]

use this:


Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Long: r = Target.Row
If r >= 5 And r < Sheet1.Range("A" & Rows.Count).End(xlUp).Row Then
r = r - 3
Range("C15").FormulaR1C1 = "=OFFSET(R[-12]C[1]," & r & ",0)"
End If
End Sub



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype*
*   pankaj.sharma_pj**Facebook  www.facebook.com/dude.pj
<http://www.facebook.com/dude.pj>*




-- Forwarded message --
From: big smile <bigsmile...@gmail.com>
Date: Sun, Jan 10, 2016 at 6:18 PM
Subject: $$Excel-Macros$$ Refresh d15 automatically when last any entry of
any raw change
To: excel-macros@googlegroups.com


Respected All Thanks  a lot  High light  Raw works properly  But still
Second option do not work

Enclosed file for details  1] In Cell - D 15  not work according to my
question  If I make any changes in any cell   ex -- If I make the change
any other raw  Then all the details pertaining -- respectively raw  change
in D 15 at present it comes only I change raw 9 To be more precise if I
make the changes in raw 8  then what  ever is in D8 should come in D 15 If
make the changes in raw 6 then what  ever is in D6 should come in D 15 I
want that if I make any changes in any raw  then last updated raw details  then
it should automatically updates all  details of that raw  & show it on Cell
D15 Thanks in advance








On 10 January 2016 at 14:18, Pankaj Sharma <pankaj123...@gmail.com> wrote:

> in Conditional formatting use formula:
>
> =AND($F5>=TODAY(),$F5<=TODAY()+14)
>
> Applied to :
> =$A$5:$AI9
>
>
>
> and secondly in Function GetConcat formula coding use :
>
> Application.Volatile
>
> for Auto refresh
>
>
>
>
>
> *Pankaj Sharma  *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>
>
>
>
> On Sun, Jan 10, 2016 at 1:27 PM, Pankaj Sharma <pankaj123...@gmail.com>
> wrote:
>
>> Check it !
>>
>>
>> *Pankaj Sharma  *
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email   *
>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message --
>> From: big smile <bigsmile...@gmail.com>
>> Date: Sun, Jan 10, 2016 at 11:19 AM
>> Subject: $$Excel-Macros$$ Correction required in highlet cell & refresh
>> d15 automatically when last any entry of any raw change
>> To: excel-macros@googlegroups.com
>>
>>
>>
>>
>>
>> Respected All
>>
>> I have attached excel files too  It has some still issue . I think there
>> is some correction required   in the formula  1]  When  F column falls
>> under 15 days before today -- only that time full raw should be yellow  Today
>> is 9/1/2016  so any date from 9/1/2016 to 24/1/16 -- then only full raw
>> should be yellow  But at present it happens even if due date is before
>> today also -- ex  f6 is  15/12/2015  then also it become yellow 2] In
>> Cell - D 15  not work according to my question  If I make any changes in
>> any cell   ex -- If I make the change in Raw 9 In stead of mediclaim I
>> put shop in e9 also  change in R 9 -- some change  Then all the details
>> pertaining -- respectively  change in D 15 at present it not change for
>> D 15 3] I have to refesh my cell entry then It show change I want that
>> if I make any changes in any raw  then last updated raw details  then it
>> should automatically updates all  details of that raw  & show it on Cell
>> D15 Thanks in advance
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge th

$$Excel-Macros$$ Fwd: Need Help

[Pankaj Sharma]

use this:

Sub Reporting()
Dim abc As Long: abc = Sheet1.Range("A" & Rows.Count).End(xlUp).Row
Sheet1.Range("B7:B" & abc).FormulaR1C1 =
"=IF(RC1="""","""",TEXT(RC1,""mmm"")&""-""(RC1,""yy""))"
End Sub



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




-- Forwarded message --
From: Debottam Roy <debottamro...@gmail.com>
Date: Sun, Jan 10, 2016 at 5:18 PM
Subject: Need Help
To: Excel Prince <excelpri...@googlegroups.com>


Hello Sir,

I have attached one file. I faced one problem Please suggest.

I have tried multiple times but still I got partial correct result. Please
help me as early as possible.

Thanks and Regards:

Dev
Contact No: 9958975076

-- 
You received this message because you are subscribed to the Google Groups
"Excel Prince" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excelprince+unsubscr...@googlegroups.com.
To post to this group, send email to excelpri...@googlegroups.com.
To view this discussion on the web visit
https://groups.google.com/d/msgid/excelprince/CADhaybARRbxSffkFiUk3nZVqUL22uLvVvLPYWgtW8WOEeWWHcQ%40mail.gmail.com
<https://groups.google.com/d/msgid/excelprince/CADhaybARRbxSffkFiUk3nZVqUL22uLvVvLPYWgtW8WOEeWWHcQ%40mail.gmail.com?utm_medium=email_source=footer>
.
For more options, visit https://groups.google.com/d/optout.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1(test).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

[Pankaj Sharma]

it's already done i think.. pfa



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Wed, Jan 6, 2016 at 6:15 PM, mohd sadiq <mohdsadiq...@gmail.com> wrote:

> Dera Team ,
>
> Please help on the same
>
> On Mon, Jan 4, 2016 at 4:34 PM, mohd sadiq <mohdsadiq...@gmail.com> wrote:
>
>> Hello Pankaj ,
>>
>> Pls help on the same
>>
>> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq <mohdsadiq...@gmail.com>
>> wrote:
>>
>>> Hello ,
>>>
>>> I need put Week OFF (WO) basis of attached excel (Day wise WO count)
>>> (Excel attached with your reference.( if change day wise Week OFF count
>>> then it should be automatically changed in Roster sheet.
>>>
>>> Example-
>>>
>>> We have 20 agents in a Shift and we need to give Weekly OFF to everyone
>>> basis of attached sheet but WO should not be repeat more than one.
>>>
>>> *Sample- *
>>>
>>> Shift Timing-- 05:00-14:00
>>> Shift Count -- 20
>>>
>>> We can give Weekly OFF basis of Following days count.
>>>
>>> Monday-3
>>> Tue- 3
>>> Wed-2
>>> Thu-2
>>> Fri-2
>>> Sat-3
>>> Sun-5
>>>
>>>
>>>
>>>
>>> Regards
>>> Mohd Sadiq
>>> E-mail :- mohdsadiq...@gmail.com
>>>
>>
>>
>>
>> --
>> Regards
>> Mohd Sadiq
>> contact no:- 9565809193
>> E-mail :- mohdsadiq...@gmail.com
>>
>
>
>
> --
> Regards
> Mohd Sadiq
> contact no:- 9565809193
> E-mail :- mohdsadiq...@gmail.com
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Solved 2.xlsx
Description: MS-Excel 2007 spreadsheet

Fwd: $$Excel-Macros$$ Re: Enable/Disable text box based on User Login

[Pankaj Sharma]

Hi Rajeev,


You can also use this Form too. ☺


user1

USER
PASSWORD

user2
GUEST



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




-- Forwarded message --
From: Rajeev Kumar <rajeevk...@gmail.com>
Date: Wed, Dec 30, 2015 at 2:08 PM
Subject: Re: $$Excel-Macros$$ Re: Enable/Disable text box based on User
Login
To: excel-macros@googlegroups.com


Thanks a lot

Cheers

On Wed, Dec 30, 2015 at 11:33 AM, Abhishek Jain <abhishek@gmail.com>
wrote:

> Dear Rajeev,
>
> Please see attached.
>
> User 1 -
>
> ADMIN
> admin123
>
> User 2
> GUEST
> guest123
>
> *Both user names and passwords are case-sensitive.*
>
> HTH, Abhishek
>
> On Wed, Dec 30, 2015 at 1:11 PM, Rajeev Kumar <rajeevk...@gmail.com>
> wrote:
>
>> Please find attached file and help as per requirement.
>>
>> Thanks in advance
>>
>> On Wed, Dec 30, 2015 at 9:40 AM, Mandeep Baluja <rockerna...@gmail.com>
>> wrote:
>>
>>> Check this attachment !! userid for admin is : admin and password is 123
>>> same as for Guest.
>>>
>>> Regards,
>>> Mandeep baluja
>>> https://www.facebook.com/groups/825221420889809/
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>>
>>
>> --
>> Rajeev Kumar
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem

Re: $$Excel-Macros$$ plz help

[Pankaj Sharma]

have you seen attachment. If no than check it.  



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Sun, Dec 27, 2015 at 5:53 PM, SUDHIR VERMA <newinex...@gmail.com> wrote:

> Dear
> Bu
> But it is not working.
>
> On Saturday, 26 December 2015, Pankaj Sharma <pankaj123...@gmail.com>
> wrote:
>
>> use this:
>>
>>
>> "=TEXT(IF(LEFT(B6,17)="Ship (P/U) Date:
>> ",TRIM(MID(B6,18,10)),K5),"MM/DD/")"
>>
>> instead of "=TEXT(IF(LEFT(B10,17)="Ship (P/U) Date:
>> ",RIGHT(B10,11),K9),"MM/DD/")"
>>
>>
>>
>> *Pankaj Sharma  *
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email   *
>> *pankaj123...@gmail.com**Skype**   pankaj.sharma_pj*
>>
>>
>>
>>
>> -- Forwarded message --
>> From: SUDHIR VERMA <newinex...@gmail.com>
>> Date: Sat, Dec 26, 2015 at 4:20 PM
>> Subject: $$Excel-Macros$$ plz help
>> To: excel-macros <excel-macros@googlegroups.com>
>>
>>
>> Sir,
>>
>> I am attached excel report for required help date difference.
>>
>>
>> Thanking You
>>
>> Regards
>> Sudhir
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Fedex report (Solved).xlsx
Description: MS-Excel 2007 spreadsheet

Fwd: $$Excel-Macros$$ plz help

[Pankaj Sharma]

use this:


"=TEXT(IF(LEFT(B6,17)="Ship (P/U) Date:
",TRIM(MID(B6,18,10)),K5),"MM/DD/")"

instead of "=TEXT(IF(LEFT(B10,17)="Ship (P/U) Date:
",RIGHT(B10,11),K9),"MM/DD/")"



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




-- Forwarded message --
From: SUDHIR VERMA <newinex...@gmail.com>
Date: Sat, Dec 26, 2015 at 4:20 PM
Subject: $$Excel-Macros$$ plz help
To: excel-macros <excel-macros@googlegroups.com>


Sir,

I am attached excel report for required help date difference.


Thanking You

Regards
Sudhir

-- 
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 Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Fedex report (Solved).xlsx
Description: MS-Excel 2007 spreadsheet

Fwd: $$Excel-Macros$$ Need Help on attached sheet

[Pankaj Sharma]

Use this :


Sub Data_Formatting()

Dim rw As Long
For rw = 17 To ActiveSheet.UsedRange.Rows.Count Step 6
With Worksheets("Required").Range("B" & Rows.Count).End(xlUp)
.Offset(1, 0).Value = Range("D" & rw).Value
.Offset(1, 1).Value = Range("D" & rw).Offset(3).Value
.Offset(1, 2).Value = Range("F" & rw).Value
.Offset(1, 3).Value = Range("M" & rw).Value
.Offset(1, 4).Value = Range("O" & rw).Offset(3).Value
.Offset(1, 5).Value = Range("R" & rw).Value
.Offset(1, 6).Value = Range("T" & rw).Offset(3).Value
.Offset(1, 7).Value = Range("V" & rw).Value
.Offset(1, 8).Value = Range("Z" & rw).Offset(3).Value
.Offset(1, 9).Value = Range("AB" & rw).Value
.Offset(1, 10).Value = Range("AD" & rw).Offset(3).Value
.Offset(1, 11).Value = Range("AF" & rw).Value
.Offset(1, 12).Value = Range("AK" & rw).Offset(2).Value
.Offset(1, 13).Value = Range("AK" & rw).Value
End With
Next rw

End Sub




*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




-- Forwarded message --
From: vikas khen <vikk...@gmail.com>
Date: Thu, Dec 24, 2015 at 7:37 AM
Subject: $$Excel-Macros$$ Need Help on attached sheet
To: excel-macros@googlegroups.com


Dear Team,

Please find the attached excel sheet in which the raw data is sheet 1 and
the required output is in Sheet 2.

It would be very helpful if you help me on this.


Regards


-- 
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 Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
will not get quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security
measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE : Don't ever post confidential data in a workbook. Forum owners and
members are not responsible for any loss.
---
You received this message because you are subscribed to the Google Groups
"MS EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an
email to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


WeeklyBooking (Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Transform data - help required

[Pankaj Sharma]

okay, now check it



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Tue, Dec 22, 2015 at 3:20 PM, Rashi Singh <rashising...@gmail.com> wrote:

> Thanks. but it is not picking as per my requirement sir.
>
> I have attached a file where i highlighted green, that is the format i
> require. Please find attachment.
>
>
> Regards,
> Rashi
>
>
> On Tue, Dec 22, 2015 at 2:35 PM, Pankaj Sharma <pankaj123...@gmail.com>
> wrote:
>
>> pfa
>>
>>
>>
>> *Pankaj Sharma  *
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email   *
>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>
>>
>>
>>
>> On Tue, Dec 22, 2015 at 9:28 AM, Rashi Singh <rashising...@gmail.com>
>> wrote:
>>
>>> Hi, there some small changes in line item. Suppose there are two or more
>>> line item in single Customer, than the transform data gives some small
>>> mismatch. Please find attachment.
>>>
>>> Can you please guide and solve. Once again thanking in advance.
>>>
>>> Regards,
>>> Rashi
>>>
>>> On Mon, Dec 21, 2015 at 5:41 PM, Rashi Singh <rashising...@gmail.com>
>>> wrote:
>>>
>>>> Thanks Pankaj for helping. Very nice. thanks again.
>>>>
>>>>
>>>>
>>>> Regards,
>>>> Rashi
>>>>
>>>>
>>>> On Mon, Dec 21, 2015 at 4:18 PM, Pankaj Sharma <pankaj123...@gmail.com>
>>>> wrote:
>>>>
>>>>> check it
>>>>>
>>>>>
>>>>>
>>>>> *Pankaj Sharma  *
>>>>>
>>>>> *MIS Analyst*
>>>>>
>>>>> *Greater Kailash-1, New Delhi*
>>>>>
>>>>> *Email   *
>>>>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>>>>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> On Mon, Dec 21, 2015 at 10:54 AM, Rashi Singh <rashising...@gmail.com>
>>>>> wrote:
>>>>>
>>>>>> Dear all,
>>>>>>
>>>>>> I have been try to record macro to transform my raw data to required
>>>>>> data. but couldn't done as per enclosed xl sheet. please please help me 
>>>>>> in
>>>>>> transforming in enclosed format.
>>>>>>
>>>>>> Thanking in advance to all.
>>>>>>
>>>>>>
>>>>>>
>>>>>>
>>>>>> --Rashi
>>>>>>
>>>>>> --
>>>>>> 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
>>>>>> Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need
>>>>>> Advice will not get quick attention or may not be answered.
>>>>>> 2) Don't post a question in the thread of another member.
>>>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>>>> measure.
>>>>>> 4) Acknowledge the responses you receive, good or bad.
>>>>>> 5) Jobs posting is not allowed.
>>>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>>>
>>>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>>>> and members are not responsible for any loss.
>>>>>> ---
>>>>>> You received this message because you are subscribed to the Google
>>>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>>>> To unsubscribe from this group and stop receiving emails from it,
>>>>>> send an email to excel-macros+unsubscr...@googlegroups.com.
>>

Re: $$Excel-Macros$$ Transform data - help required

[Pankaj Sharma]

pfa



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Tue, Dec 22, 2015 at 9:28 AM, Rashi Singh <rashising...@gmail.com> wrote:

> Hi, there some small changes in line item. Suppose there are two or more
> line item in single Customer, than the transform data gives some small
> mismatch. Please find attachment.
>
> Can you please guide and solve. Once again thanking in advance.
>
> Regards,
> Rashi
>
> On Mon, Dec 21, 2015 at 5:41 PM, Rashi Singh <rashising...@gmail.com>
> wrote:
>
>> Thanks Pankaj for helping. Very nice. thanks again.
>>
>>
>>
>> Regards,
>> Rashi
>>
>>
>> On Mon, Dec 21, 2015 at 4:18 PM, Pankaj Sharma <pankaj123...@gmail.com>
>> wrote:
>>
>>> check it
>>>
>>>
>>>
>>> *Pankaj Sharma  *
>>>
>>> *MIS Analyst*
>>>
>>> *Greater Kailash-1, New Delhi*
>>>
>>> *Email   *
>>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>>
>>>
>>>
>>>
>>> On Mon, Dec 21, 2015 at 10:54 AM, Rashi Singh <rashising...@gmail.com>
>>> wrote:
>>>
>>>> Dear all,
>>>>
>>>> I have been try to record macro to transform my raw data to required
>>>> data. but couldn't done as per enclosed xl sheet. please please help me in
>>>> transforming in enclosed format.
>>>>
>>>> Thanking in advance to all.
>>>>
>>>>
>>>>
>>>>
>>>> --Rashi
>>>>
>>>> --
>>>> 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 Please
>>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>>> will not get quick attention or may not be answered.
>>>> 2) Don't post a question in the thread of another member.
>>>> 3) Don't post questions regarding breaking or bypassing any security
>>>> measure.
>>>> 4) Acknowledge the responses you receive, good or bad.
>>>> 5) Jobs posting is not allowed.
>>>> 6) Sharing copyrighted material and their links is not allowed.
>>>>
>>>> NOTE : Don't ever post confidential data in a workbook. Forum owners
>>>> and members are not responsible for any loss.
>>>> ---
>>>> You received this message because you are subscribed to the Google
>>>> Groups "MS EXCEL AND VBA MACROS" group.
>>>> To unsubscribe from this group and stop receiving emails from it, send
>>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>>> To post to this group, send email to excel-macros@googlegroups.com.
>>>> Visit this group at https://groups.google.com/group/excel-macros.
>>>> For more options, visit https://groups.google.com/d/optout.
>>>>
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and s

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

[Pankaj Sharma]

check it !



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N <ganeshg...@gmail.com> wrote:

> Dear team,
>
> I want to find the any of the given list of value matches (part) in the
> particular cell using formula or macro.
>
> Please find the attached excel.
>
> If the solution in formula that would be great!!
>
> If you have any concern let me know.
>
> Thanks Team,
> Regards,
> Ganesh N
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Macro required (solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ help on find the list matches to the cell part value

[Pankaj Sharma]

Dear Ganesh,

I hope it should be ok.


Sub lookup_list()
Dim wf As Object: Set wf = Application.WorksheetFunction
Dim list As Range: Set list = Range("A1", Range("A" &
Rows.Count).End(xlUp))
Dim v1 As Long, v2 As Long, r As Long, a As Long, b As Long


On Error Resume Next
For r = 2 To Range("E" & Rows.Count).End(xlUp).Row
v1 = Split(Split(Cells(r, 5).Value, "-")(1), "/")(0)
v2 = Split(Split(Cells(r, 5).Value, "-")(1), "/")(1)

If v1 < v2 Then
a = wf.CountIf(list, "<=" & v2)
b = wf.CountIf(list, ">=" & v1)
ElseIf v1 > v2 Then
a = wf.CountIf(list, ">=" & v2)
b = wf.CountIf(list, "<=" & v1)
    End If
If a > 0 And b > 0 Then Cells(r, 9).Value = "YES" _
Else Cells(r, 9).Value = "NO"
Next r
On Error GoTo 0

End Sub




*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Tue, Dec 22, 2015 at 6:10 PM, Ganesh N <ganeshg...@gmail.com> wrote:

> Dear Team,
>
> Thanks, But I not get the correct answer.
>
> I will say again in the column A I have the list of number. In column E I
> have some date. I want to check any one in the list (column A) is appearing
> in column E single cell. If cell E2 have the any number in Column A then i
> need the answer as "Yes" else "No". But all the solution which i got from
> the team are not giving the required result. Kindly help.
>
> Thanks & Regards,
> Ganesh N
>
> On Tue, Dec 22, 2015 at 5:58 PM, Pankaj Sharma <pankaj123...@gmail.com>
> wrote:
>
>> check it !
>>
>>
>>
>> *Pankaj Sharma  *
>>
>> *MIS Analyst*
>>
>> *Greater Kailash-1, New Delhi*
>>
>> *Email   *
>> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
>> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>>
>>
>>
>>
>> On Tue, Dec 22, 2015 at 5:07 PM, Ganesh N <ganeshg...@gmail.com> wrote:
>>
>>> Dear team,
>>>
>>> I want to find the any of the given list of value matches (part) in the
>>> particular cell using formula or macro.
>>>
>>> Please find the attached excel.
>>>
>>> If the solution in formula that would be great!!
>>>
>>> If you have any concern let me know.
>>>
>>> Thanks Team,
>>> Regards,
>>> Ganesh N
>>>
>>> --
>>> 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 Please
>>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>>> will not get quick attention or may not be answered.
>>> 2) Don't post a question in the thread of another member.
>>> 3) Don't post questions regarding breaking or bypassing any security
>>> measure.
>>> 4) Acknowledge the responses you receive, good or bad.
>>> 5) Jobs posting is not allowed.
>>> 6) Sharing copyrighted material and their links is not allowed.
>>>
>>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>>> members are not responsible for any loss.
>>> ---
>>> You received this message because you are subscribed to the Google
>>> Groups "MS EXCEL AND VBA MACROS" group.
>>> To unsubscribe from this group and stop receiving emails from it, send
>>> an email to excel-macros+unsubscr...@googlegroups.com.
>>> To post to this group, send email to excel-macros@googlegroups.com.
>>> Visit this group at https://groups.google.com/group/excel-macros.
>>> For more options, visit https://groups.google.com/d/optout.
>>>
>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> wil

Re: $$Excel-Macros$$ REPLACE

[Pankaj Sharma]

use this:

=TRIM(LEFT(A5,27) & " " & RIGHT(A5,4) & " " & MID(A5,28,14))



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Wed, Dec 23, 2015 at 12:24 PM, Vinod Kumar <vinod...@gmail.com> wrote:

> Dear Team,
>
> PFA required your help in replacing the content from last to med.
>
> Regards,
> Vinod
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book1 (Solved).xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Transform data - help required

[Pankaj Sharma]

check it



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Mon, Dec 21, 2015 at 10:54 AM, Rashi Singh <rashising...@gmail.com>
wrote:

> Dear all,
>
> I have been try to record macro to transform my raw data to required data.
> but couldn't done as per enclosed xl sheet. please please help me in
> transforming in enclosed format.
>
> Thanking in advance to all.
>
>
>
>
> --Rashi
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Transform Data (Solved).xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

[Pankaj Sharma]

Formula updated in example sheet



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Tue, Dec 15, 2015 at 11:13 PM, Pankaj Sharma <pankaj123...@gmail.com>
wrote:

> done!
>
>
>
> *Pankaj Sharma  *
>
> *MIS Analyst*
>
> *Greater Kailash-1, New Delhi*
>
> *Email   *
> *p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com
> <ankaj123...@gmail.com>**Skype**   pankaj.sharma_pj*
>
>
>
>
> On Tue, Dec 15, 2015 at 7:51 PM, mohd sadiq <mohdsadiq...@gmail.com>
> wrote:
>
>> Dear All ,
>>
>> Pls help on the same.
>> On Dec 14, 2015 3:00 PM, "mohd sadiq" <mohdsadiq...@gmail.com> wrote:
>>
>>> yet I am not getting solution :(
>>>
>>>
>>> Rgds, Mohd Sadiq
>>>
>>>
>>> On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>> wrote:
>>>
>>>> Dear Team ,
>>>>
>>>> Please help on the same as i need to make it on on priority.
>>>>
>>>>
>>>> Thanx
>>>>
>>>>
>>>> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>>> wrote:
>>>>
>>>>> Hello ,
>>>>>
>>>>> I need put Week OFF (WO) basis of attached excel (Day wise WO count)
>>>>> (Excel attached with your reference.( if change day wise Week OFF count
>>>>> then it should be automatically changed in Roster sheet.
>>>>>
>>>>> Example-
>>>>>
>>>>> We have 20 agents in a Shift and we need to give Weekly OFF to
>>>>> everyone basis of attached sheet but WO should not be repeat more than 
>>>>> one.
>>>>>
>>>>> *Sample- *
>>>>>
>>>>> Shift Timing-- 05:00-14:00
>>>>> Shift Count -- 20
>>>>>
>>>>> We can give Weekly OFF basis of Following days count.
>>>>>
>>>>> Monday-3
>>>>> Tue- 3
>>>>> Wed-2
>>>>> Thu-2
>>>>> Fri-2
>>>>> Sat-3
>>>>> Sun-5
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> Regards
>>>>> Mohd Sadiq
>>>>> E-mail :- mohdsadiq...@gmail.com
>>>>>
>>>>
>>>>
>>>>
>>>> --
>>>> Regards
>>>> Mohd Sadiq
>>>> contact no:- 9565809193
>>>> E-mail :- mohdsadiq...@gmail.com
>>>>
>>>
>>>
>>>
>>> --
>>> Regards
>>> Mohd Sadiq
>>> contact no:- 9565809193
>>> E-mail :- mohdsadiq...@gmail.com
>>>
>> --
>> 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 Please
>> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
>> will not get quick attention or may not be answered.
>> 2) Don't post a question in the thread of another member.
>> 3) Don't post questions regarding breaking or bypassing any security
>> measure.
>> 4) Acknowledge the responses you receive, good or bad.
>> 5) Jobs posting is not allowed.
>> 6) Sharing copyrighted material and their links is not allowed.
>>
>> NOTE : Don't ever post confidential data in a workbook. Forum owners and
>> members are not responsible for any loss.
>> ---
>> You received this message because you are subscribed to the Google Groups
>> "MS EXCEL AND VBA MACROS" group.
>> To unsubscribe from this group and stop receiving emails from it, send an
>> email to excel-macros+unsubscr...@googlegroups.com.
>> To post to this group, send email to excel-macros@googlegroups.com.
>> Visit this group at https://groups.google.com/group/excel-macros.
>> For more options, visit https://groups.google.com/d/optout.
>>
>
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

[Pankaj Sharma]

done!



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Tue, Dec 15, 2015 at 7:51 PM, mohd sadiq <mohdsadiq...@gmail.com> wrote:

> Dear All ,
>
> Pls help on the same.
> On Dec 14, 2015 3:00 PM, "mohd sadiq" <mohdsadiq...@gmail.com> wrote:
>
>> yet I am not getting solution :(
>>
>>
>> Rgds, Mohd Sadiq
>>
>>
>> On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq <mohdsadiq...@gmail.com>
>> wrote:
>>
>>> Dear Team ,
>>>
>>> Please help on the same as i need to make it on on priority.
>>>
>>>
>>> Thanx
>>>
>>>
>>> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq <mohdsadiq...@gmail.com>
>>> wrote:
>>>
>>>> Hello ,
>>>>
>>>> I need put Week OFF (WO) basis of attached excel (Day wise WO count)
>>>> (Excel attached with your reference.( if change day wise Week OFF count
>>>> then it should be automatically changed in Roster sheet.
>>>>
>>>> Example-
>>>>
>>>> We have 20 agents in a Shift and we need to give Weekly OFF to everyone
>>>> basis of attached sheet but WO should not be repeat more than one.
>>>>
>>>> *Sample- *
>>>>
>>>> Shift Timing-- 05:00-14:00
>>>> Shift Count -- 20
>>>>
>>>> We can give Weekly OFF basis of Following days count.
>>>>
>>>> Monday-3
>>>> Tue- 3
>>>> Wed-2
>>>> Thu-2
>>>> Fri-2
>>>> Sat-3
>>>> Sun-5
>>>>
>>>>
>>>>
>>>>
>>>> Regards
>>>> Mohd Sadiq
>>>> E-mail :- mohdsadiq...@gmail.com
>>>>
>>>
>>>
>>>
>>> --
>>> Regards
>>> Mohd Sadiq
>>> contact no:- 9565809193
>>> E-mail :- mohdsadiq...@gmail.com
>>>
>>
>>
>>
>> --
>> Regards
>> Mohd Sadiq
>> contact no:- 9565809193
>> E-mail :- mohdsadiq...@gmail.com
>>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at https://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Solved 1.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Excel Need to Assign Weekly OFF by Formula

[Pankaj Sharma]

check it!



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Fri, Dec 11, 2015 at 12:06 PM, mohd sadiq <mohdsadiq...@gmail.com> wrote:

> Dear Team ,
>
> Please help on the same as i need to make it on on priority.
>
>
> Thanx
>
>
> On Thu, Dec 10, 2015 at 7:01 PM, mohd sadiq <mohdsadiq...@gmail.com>
> wrote:
>
>> Hello ,
>>
>> I need put Week OFF (WO) basis of attached excel (Day wise WO count)
>> (Excel attached with your reference.( if change day wise Week OFF count
>> then it should be automatically changed in Roster sheet.
>>
>> Example-
>>
>> We have 20 agents in a Shift and we need to give Weekly OFF to everyone
>> basis of attached sheet but WO should not be repeat more than one.
>>
>> *Sample- *
>>
>> Shift Timing-- 05:00-14:00
>> Shift Count -- 20
>>
>> We can give Weekly OFF basis of Following days count.
>>
>> Monday-3
>> Tue- 3
>> Wed-2
>> Thu-2
>> Fri-2
>> Sat-3
>> Sun-5
>>
>>
>>
>>
>> Regards
>> Mohd Sadiq
>> E-mail :- mohdsadiq...@gmail.com
>>
>
>
>
> --
> Regards
> Mohd Sadiq
> contact no:- 9565809193
> E-mail :- mohdsadiq...@gmail.com
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Solved.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ FW: Get text value in pivot data field.

[Pankaj Sharma]

Share a example sheet. Q & A



*Pankaj Sharma  *

*MIS Analyst*

*Greater Kailash-1, New Delhi*

*Email   *
*p <sharmapankaj...@yahoo.com>ankaj123...@gmail.com <ankaj123...@gmail.com>*
*Skype**   pankaj.sharma_pj*




On Wed, Dec 2, 2015 at 6:10 AM, Nilkanth Raval <nilkanth.ra...@gmail.com>
wrote:

> Hi All,
>
> Can you please help me to get text value in pivot table data field.
>
>
> Thanks,
>
> Nilkanth Raval
>
> 9004280428
>
> - Original Message -
> *From*: Nilkanth Raval
> *To*: "excel-macros@googlegroups.com"
> *Date*: Thu Nov 26 06:05:43 GMT+05:30 2015
> *Subject*: Get text value in pivot data field.
>
> Hi All,
>
> Does any one has macro to get text value in Pivot data field? Please help
> me.
>
> Thanks,
>
> Nilkanth Raval
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Required help for count of present days

[Pankaj Sharma]

Hi Jetendra,

PFA



*Pankaj Sharma  *

*MIS Analyst*

*9599220030*

*Greater Kailash-1, New Delhi*

*Email   **sharmapankaj...@yahoo.com <sharmapankaj...@yahoo.com>*

*Skype**   pankaj.sharma_pj*




On Thu, Oct 1, 2015 at 6:23 PM, Jitendra Kumar <jitendr...@gmail.com> wrote:

> Dear All,
>
>
>
> Please help for count of available manpower for A,B & C company.
>
>
>
>
>
>
>
>
>
> *Regards,*
>
> *Jitendra Kumar*  *+91-9650449202 <%2B91-9650449202> *
>
>
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


help for attendance (Solved).xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ Re: Data Extract After "/"

[Pankaj Sharma]

Hi Anand,
You can also use this

=IF(ISERROR(FIND("/",A1)),A1,RIGHT(A1,LEN(A1)-FIND("~",SUBSTITUTE(A1,"/","~",LEN(A1)-LEN(SUBSTITUTE(A1,"/",""))




*Pankaj Sharma  *

*MIS Analyst*

*9599220030*

*Greater Kailash-1, New Delhi*

*Email   **sharmapankaj...@yahoo.com <sharmapankaj...@yahoo.com>*

*Skype**   pankaj.sharma_pj*




On Wed, Sep 23, 2015 at 4:41 PM, Anand Tiwari <anand.tiwari...@gmail.com>
wrote:

>
> On 23 September 2015 at 16:35, Mandeep Baluja <rockerna...@gmail.com>
> wrote:
>
>> 999
>
>
> ​Thanks you so much Mandeep Jee​
>
>
> *Regards,*
> *Anand Tiwari*
>
>
> --
> 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 Please
> Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will not get quick attention or may not be answered.
> 2) Don't post a question in the thread of another member.
> 3) Don't post questions regarding breaking or bypassing any security
> measure.
> 4) Acknowledge the responses you receive, good or bad.
> 5) Jobs posting is not allowed.
> 6) Sharing copyrighted material and their links is not allowed.
>
> NOTE : Don't ever post confidential data in a workbook. Forum owners and
> members are not responsible for any loss.
> ---
> You received this message because you are subscribed to the Google Groups
> "MS EXCEL AND VBA MACROS" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to excel-macros+unsubscr...@googlegroups.com.
> To post to this group, send email to excel-macros@googlegroups.com.
> Visit this group at http://groups.google.com/group/excel-macros.
> For more options, visit https://groups.google.com/d/optout.
>

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ need Excel formula

[Pankaj Sharma]

HI Expert,,

i need a formula to find last collected Amount from client.For example PFA.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Need last collected amt.xlsx
Description: MS-Excel 2007 spreadsheet

Re: $$Excel-Macros$$ need Excel formula

[Pankaj Sharma]

Thank you Abhishek Jain 

On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com
wrote:

 HTH

 On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com
 wrote:

 HI Expert,,

 i need a formula to find last collected Amount from client.For example
 PFA.






 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ need Excel formula

[Pankaj Sharma]

yup,, nice trick to get last small value...
very useful

On Thu, Aug 27, 2015 at 4:13 PM, Abhishek Jain abhishek@gmail.com
wrote:

 Just one thing though...I forgot to freeze the ranges which might result
 in incorrect values. The correct formula would be -

 =LOOKUP(2,1/($A$1:$A$17=F2),$B$1:$B$17)

 Regards,


 On Thu, Aug 27, 2015 at 3:51 PM, Pankaj Sharma pankaj123...@gmail.com
 wrote:

 Thank you Abhishek Jain 

 On Thu, Aug 27, 2015 at 3:37 PM, Abhishek Jain abhishek@gmail.com
 wrote:

 HTH

 On Thu, Aug 27, 2015 at 3:18 PM, Pankaj Sharma pankaj123...@gmail.com
 wrote:

 HI Expert,,

 i need a formula to find last collected Amount from client.For example
 PFA.






 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners
 and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge

Re: $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as per Targets Achieved

[Pankaj Sharma]

Dear Ashok,

I don't think there is any easiest way to calculate this with excel
formula's.

You can do with run a macro or better if you make a slab chart on the right
side or other sheet to calculate the same. This will be easy if you have to
change slab criteria in future.




On Wed, Aug 19, 2015 at 3:03 PM, Ashok Soni soni.ashok1...@gmail.com
wrote:

 Dear Rajan Sir,

 I need a formula in excel which can calculate commission on target amount.
 i describe as bellow:

 1.  suppose i have 10 branches and more than 3 employee in each.
 2. i have different % slab of commission.
 3. commission should be calculate stab by stab.
  i have explain it in excel file, if you think it is not explain properly
 please provide your contact no. i will call you.
 i have attached of excel file.
 please help me

 On Monday, September 10, 2012 at 7:23:40 PM UTC+5:30, Rajan Verma wrote:

 *See the attached*





 *Regards*

 *Rajan verma*

 *+91 7838100659 %2B91%207838100659 [IM-Gtalk]*



 *From:* excel-...@googlegroups.com [mailto:excel-...@googlegroups.com] *On
 Behalf Of *Rashid Khan
 *Sent:* 10 September 2012 1:20
 *To:* excel-macros
 *Subject:* $$Excel-Macros$$ Formula to Calculate Slab Wise Commission as
 per Targets Achieved



 Hello All,

 We have a group of employees having various Grades and Position.

 1)  A fixed target of sales to be achieved every month as shown in
 Col D (Target).

 2)  Each level has different Target Criteria as shown in Col C5.

 3)  Commission Criteria is shown in F3:K3

 4)  Achievement Criteria is shown in F2:K2

 5)  Target achieved by each is shown in Col E5 downwards.

 Can anyone please provide a formula which will calculate the commission
 according to the Target achieved against each employee? If they achieve
 75-79% they get 50% of target achieved, 80-85% then 60% and so on so forth.

 I require the formula in F5:K5 (red color cells) to drag it down and
 across to get the desired figures.

 Thanks

 Rashid Khan

 --
 Join official facebook page of this forum @
 https://www.facebook.com/discussexcel

 FORUM RULES (1120+ members already BANNED for violation)

 1) Use concise, accurate thread titles. Poor thread titles, like Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.

 2) Don't post a question in the thread of another member.

 3) Don't post questions regarding breaking or bypassing any security
 measure.

 4) Acknowledge the responses you receive, good or bad.

 5) Cross-promotion of, or links to, forums competitive to this forum in
 signatures are prohibited.

 6) Jobs posting is not allowed.

 7) Sharing copyrighted ebooks/pirated ebooks/their links is not allowed.

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To post to this group, send email to excel-...@googlegroups.com.
 To unsubscribe from this group, send email to
 excel-macros...@googlegroups.com.



 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting 

Re: $$Excel-Macros$$ FORMULA REQUIRED

[Pankaj Sharma]

use this

=INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0))

or

if you don't want to see #N/A error so use this one


=IFERROR(INDEX($L$2:$R$87,MATCH($B2,$K$2:$K$87,0),MATCH($C2,$L$1:$R$1,0)),-)





*Regards,*
*PJ*




On Thu, Jul 30, 2015 at 8:01 PM, Izhar izharra...@gmail.com wrote:

 I need figure in color column, the figure must be taken from column L to
 column R into the column G on the bases of article number, color and size.
 As an example I have put some figures in column G manually, these figures
 may be find in column L to R, I understand that the function we may use
 over here is VLOOKUP but I cant do it.  Please help me

 Thanks in advance.

 --
 *Izhar Ul Haq*



 Cell# 009203069072597

 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Fwd: Delivery Status Notification (Failure)

[Pankaj Sharma]

Attachment ??


On Mon, May 25, 2015 at 3:10 PM, Chandan Bisht csb.bi...@gmail.com wrote:


 Hi Group

 Need help by vba...

 i have two data sheets Main and Database, and i need to pick data from
 database to main by to use Find function..which data not found that output
 should be blank.

 example file attached..

 Thankx  Rgds,

 Chandra Singh Bisht

  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Query on Extract word

[Pankaj Sharma]

little mistake,, but now done


=IFERROR(TRIM(CONCATENATE(MOC
,MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,)))+3),2),1))47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(A1351,.,),-,),
,)))+3),2),1))58)),0,-1),No MOC)

On Wed, May 20, 2015 at 9:03 PM, Pankaj Sharma pankaj123...@gmail.com
wrote:

  Dear Kalyan,



 It’s Done!!!

 PFA



 =IFERROR(TRIM(CONCATENATE(MOC ,MID(SUBSTITUTE(SUBSTITUTE(A1351,-,),
 ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,),
 ,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,),
 ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,),
 ,)))+3),2),1))47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,),
 ,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,),
 ,)))+3),2),1))58)),0,-1),No MOC)



 PFA




 Regards



 Pankaj Sharma (PJ)





 *From:* excel-macros@googlegroups.com [mailto:
 excel-macros@googlegroups.com] *On Behalf Of *Kal xcel
 *Sent:* Wednesday, May 20, 2015 10:38 AM
 *To:* excel-macros@googlegroups.com
 *Subject:* $$Excel-Macros$$ Query on Extract word



 Dear Experts,

 Please help. Query is in the attached sheet.


 --

 *Kalyan Chattopadhyay*



 *Executive Corporate MIS*

 *Joy Cosmetics*

 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Query on Extract word (Solved).xlsx
Description: MS-Excel 2007 spreadsheet

RE: $$Excel-Macros$$ Query on Extract word

[Pankaj Sharma]

Dear Kalyan,

 

It’s Done!!! 

PFA

 

=IFERROR(TRIM(CONCATENATE(MOC ,MID(SUBSTITUTE(SUBSTITUTE(A1351,-,), 
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,), 
,)))+3),2+(IF(AND((CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,), 
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,), 
,)))+3),2),1))47),(CODE(RIGHT(MID(SUBSTITUTE(SUBSTITUTE(A1351,-,), 
,),(FIND(MOC,UPPER(SUBSTITUTE(SUBSTITUTE(A1351,-,), 
,)))+3),2),1))58)),0,-1),No MOC)

 

PFA

 


Regards

 

Pankaj Sharma (PJ)

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Kal xcel
Sent: Wednesday, May 20, 2015 10:38 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Query on Extract word

 

Dear Experts,

Please help. Query is in the attached sheet.



-- 

Kalyan Chattopadhyay

 

Executive Corporate MIS

Joy Cosmetics

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Query on Extract word (Solved).xlsx
Description: MS-Excel 2007 spreadsheet

RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

[Pankaj Sharma]

Hi Nitin,, use this

 

 

Dim errormessagecode, copydata, msg As String

 

On Error Resume Next

Sheets(2).Activate

ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=19, Criteria1:=N/A

ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=10, 
Criteria1:=Array(4-Resolved, 5-Closed, 6-Cancelled), 
Operator:=xlFilterValues

 

If ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeVisible).Count - 1 = 
0 Then GoTo errormessagecode Else GoTo copydata

 

errormessagecode:

msg = MsgBox(No Data for Copy)

Exit Sub

 

copydata:

Range(A1).Select

Range(A1).CurrentRegion.SpecialCells(xlCellTypeVisible).Copy

 

Sheets(3).Activate

ActiveSheet.Paste

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Nitin Balodi
Sent: Monday, May 18, 2015 6:39 PM
To: excel-macros@googlegroups.com
Subject: RE: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

 

Sorry Mandeep, I cant share the file due to confidentiality issue, but I am 
looking for a generic solution for this issue.



Regards.

 

Yours Sincerely,

Nitin Balodi

 

  _  

Date: Mon, 18 May 2015 04:55:09 -0700
From: rockerna...@gmail.com
To: excel-macros@googlegroups.com
Subject: Re: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

send the attachment 



On Monday, May 18, 2015 at 5:19:18 PM UTC+5:30, Nitin Balodi wrote:

Hi Mandeep,

 

Thanks for the response, I have tried that and getting same result and I cannot 
give predefined rows range since these are filtered out during run time.




Regards.

 

Yours Sincerely,

Nitin Balodi

 

  _  

Date: Mon, 18 May 2015 04:10:25 -0700
From: rocke...@gmail.com
To: excel-...@googlegroups.com
Subject: $$Excel-Macros$$ Re: VBA Error in copying filtered rows

Assign sheet names while defining a range to be copied. means you should use 
Sheet(Name).range(A1:A100) instead of Only Range and send me the snapshot 
of error. 

 

Regards, 

Mandeep baluja 



On Monday, May 18, 2015 at 4:31:22 PM UTC+5:30, Nitin Balodi wrote:

Hi Champs,

 

I am getting error in copying filetered cells. Below is the code snippet. Point 
to note is this works well when I test this code by running step-by-step (i.e. 
by using F8 key) but when run as a complete code it gives me an error:

 

 

Sheets(2).Activate

ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=19, Criteria1:=N/A

ActiveSheet.Range($A$1:$S$1).AutoFilter Field:=10, 
Criteria1:=Array(4-Resolved, 5-Closed, 6-Cancelled), 
Operator:=xlFilterValues

If ActiveSheet.UsedRange.Columns(1).SpecialCells(xlCellTypeVisible).Count - 1 = 
0 Then GoTo ErrorMessageCode

 

Range(A1).Select

Range(A1).CurrentRegion.SpecialCells(xlCellTypeVisible).Copy

 

Sheets(3).Activate

ActiveSheet.Paste


Can you help me on this.

 

Thanks and Regards.

 

Yours Sincerely,

Nitin Balodi


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving 

RE: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Pankaj Sharma]

THANK YOU Once again !!!

 

After few changes I’m able to run this Macro. 

 

For learners info:

First, Make sure that “Adobe Reader File Preview Type Library” selected in 
References option in Tools menu. 

Second, in Adobe Reader = View = Page Display = select “Enable Scrolling”, 
so that this macro can copy all pages data.

 

 

 

Regards

 

Pankaj Sharma

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Michael Vinoth
Sent: Friday, May 15, 2015 6:45 PM
To: excel-macros@googlegroups.com
Cc: polkarnat...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

 

Hi Pankaj Sharma ,

 

Thank you for your Appreciation... :)

 

The macro is working fine for me.

 

I attached the Macro and Output Files.

 

I am using MS Excel 2007, Adobe Reader XI and windows 7 (64 bit) combination. 
Please mention your Excel, Adobe and Windows version to help you further.

 

Let me know if you have any queries.

 

Regards,

MV

On Friday, May 15, 2015 at 1:00:27 AM UTC+5:30, Pankaj Sharma wrote:

Hi MV,

 

Firstly, I want to say thanks for sharing this valuable Macro. People already 
had given up hope but you have done a great work here.

 

In this macro, getting runtime error in below line:- Invalid procedure call or 
argument.

 

AppActivate Adobe Reader

 

 

And also, if any PDF file have 2/3 pages, only 1st page is copying, need to 
copy  all 3 pages data.

 

 

Thanks again!!!

 

 

Regards

 

PJ

 

 

From: excel-...@googlegroups.com javascript:  
[mailto:excel-...@googlegroups.com javascript: ] On Behalf Of Michael Vinoth
Sent: Thursday, May 14, 2015 12:31 AM
To: excel-...@googlegroups.com javascript: 
Cc: polkar...@gmail.com javascript: 
Subject: Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

 

Hi Pankaj Sharma ,

 

Please find the attached macro file.

 

kindly let me know if you have any queries.

 

Regards,

MV

On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote:

i recd 20-30 Mobile Bills in PDF format every month, which i need to copy in 
Excel with different sheets.

That's what i want to make automate.



 

On Sat, May 9, 2015 at 11:21 AM, Pol Ktk polkar...@gmail.com wrote:

Are you working with cdr ?

if s

what exactly u need ?

 

On 8 May 2015 at 18:44, Pankaj Sharma pankaj...@gmail.com wrote:

Please find attached file.

 

On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote:

can you share PDF file, if it is text only then same can be imported..

On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:

Hi everyone,

 

Need your help for this easy. I have a folder with multi PDF files. I need a 
macro to copy all pdf data in a workbook.

 

Note: One pdf data should be copy in one sheet.

 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@googlegroups.com.
To post to this group, send email to excel-...@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails

RE: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Pankaj Sharma]

Hi MV,

 

Firstly, I want to say thanks for sharing this valuable Macro. People already 
had given up hope but you have done a great work here.

 

In this macro, getting runtime error in below line:- Invalid procedure call or 
argument.

 

AppActivate Adobe Reader

 

 

And also, if any PDF file have 2/3 pages, only 1st page is copying, need to 
copy  all 3 pages data.

 

 

Thanks again!!!

 

 

Regards

 

PJ

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On 
Behalf Of Michael Vinoth
Sent: Thursday, May 14, 2015 12:31 AM
To: excel-macros@googlegroups.com
Cc: polkarnat...@gmail.com
Subject: Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

 

Hi Pankaj Sharma ,

 

Please find the attached macro file.

 

kindly let me know if you have any queries.

 

Regards,

MV

On Saturday, May 9, 2015 at 3:01:04 PM UTC+5:30, Pankaj Sharma wrote:

i recd 20-30 Mobile Bills in PDF format every month, which i need to copy in 
Excel with different sheets.

That's what i want to make automate.




 

On Sat, May 9, 2015 at 11:21 AM, Pol Ktk polkar...@gmail.com javascript:  
wrote:

Are you working with cdr ?

if s

what exactly u need ?

 

On 8 May 2015 at 18:44, Pankaj Sharma pankaj...@gmail.com javascript:  
wrote:

Please find attached file.



 

On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in javascript:  wrote:

can you share PDF file, if it is text only then same can be imported..

On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:

Hi everyone,

 

Need your help for this easy. I have a folder with multi PDF files. I need a 
macro to copy all pdf data in a workbook.

 

Note: One pdf data should be copy in one sheet.

 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@googlegroups.com javascript: .
To post to this group, send email to excel-...@googlegroups.com javascript: .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros...@googlegroups.com javascript: .
To post to this group, send email to excel-...@googlegroups.com javascript: .
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

 

 

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners

Re: $$Excel-Macros$$ Text separated with formula

[Pankaj Sharma]

use this

Selection.TextToColumns Destination:=Range(B1),
DataType:=xlDelimited, TextQualifier:=xlDoubleQuote, Other:=True, _
otherchar:=_, fieldinfo:=Array(Array(1, 1), Array(2, 1), Array(3,
1)),TrailingMinusNumbers:=True

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Pankaj Sharma]

i recd 20-30 Mobile Bills in PDF format every month, which i need to copy
in Excel with different sheets.

That's what i want to make automate.




On Sat, May 9, 2015 at 11:21 AM, Pol Ktk polkarnat...@gmail.com wrote:

 Are you working with cdr ?
 if s
 what exactly u need ?

 On 8 May 2015 at 18:44, Pankaj Sharma pankaj123...@gmail.com wrote:

 Please find attached file.



 On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote:

 can you share PDF file, if it is text only then same can be imported..

 On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:

 Hi everyone,

 Need your help for this easy. I have a folder with multi PDF files. I
 need a macro to copy all pdf data in a workbook.

 Note: One pdf data should be copy in one sheet.

  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google
 Groups MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send
 an email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Pankaj Sharma]

Please find attached file.



On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote:

 can you share PDF file, if it is text only then same can be imported..

 On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:

 Hi everyone,

 Need your help for this easy. I have a folder with multi PDF files. I
 need a macro to copy all pdf data in a workbook.

 Note: One pdf data should be copy in one sheet.

  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Book6.pdf
Description: Adobe PDF document


Book7.pdf
Description: Adobe PDF document

Re: $$Excel-Macros$$ Re: Copy PDF data to Excel macro require

[Pankaj Sharma]

Never lose hope!!!..

The below code we can use for single file. I hope this will help you to
make subject easier.

-

Option Explicit

Sub copy_PDF2Excel()

Dim AdobeApp As String
Dim PDFFile As String
Dim StartAdobe

'Adobe Acrobat reader location
AdobeApp = C:\Program Files\Adobe\Acrobat Reader DC\Reader\AcroRd32.exe

'file location
PDFFile = C:\Users\PJ\Desktop\Data.pdf

StartAdobe = Shell(  AdobeApp PDFFile  , 1)

Application.OnTime Now + TimeValue(00:00:05), OpenPDF

End Sub


Private Sub OpenPDF()

SendKeys (^a)
SendKeys (^c)
SendKeys (%fx)

Application.OnTime Now + TimeValue(00:00:10), MyExcel

End Sub

Private Sub MyExcel()

AppActivate Microsoft Excel
ThisWorkbook.Activate
Sheets(1).Activate
Range(A1).Activate
SendKeys (^v)
End Sub

-


*Cheers!!!*

*Pankaj Sharma*
*9716375462*


On Fri, May 8, 2015 at 6:44 PM, Pankaj Sharma pankaj123...@gmail.com
wrote:

 Please find attached file.



 On Fri, May 8, 2015 at 5:27 PM, Vabz v...@vabs.in wrote:

 can you share PDF file, if it is text only then same can be imported..

 On Thursday, May 7, 2015 at 7:42:59 PM UTC+5:30, Pankaj Sharma wrote:

 Hi everyone,

 Need your help for this easy. I have a folder with multi PDF files. I
 need a macro to copy all pdf data in a workbook.

 Note: One pdf data should be copy in one sheet.

  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

$$Excel-Macros$$ Copy PDF data to Excel macro require

[Pankaj Sharma]

Hi everyone,

Need your help for this easy. I have a folder with multi PDF files. I need 
a macro to copy all pdf data in a workbook.

Note: One pdf data should be copy in one sheet.

-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.

Re: $$Excel-Macros$$ Re: Move coloum

[Pankaj Sharma]

r u looking for this ??

Sub Combine()
Dim J As Integer
Dim rey As Range

On Error Resume Next
Sheets(1).Select
Worksheets.Add
Sheets(1).Name = Combined
Sheets(1).Activate
For J = 2 To Sheets.Count
Sheets(J).Activate
Range(A:A).Copy
Sheets(Combined).Select
If Range(XFD1).End(xlToLeft) =  Then
Selection.PasteSpecial Paste:=xlPasteAll
Else
Selection.Offset(0, 1).PasteSpecial Paste:=xlPasteAll
End If

Next
End Sub


On Thu, May 7, 2015 at 6:33 PM, B.N.Chethan Kumar chetankumar1...@gmail.com
 wrote:

 Yes. it is single column A:A

 On Thu, May 7, 2015 at 12:20 PM, Mandeep Baluja rockerna...@gmail.com
 wrote:

 how is your sheet data.??? it contain a single column or multiple columns
 ??




 On Wednesday, May 6, 2015 at 11:11:10 PM UTC+5:30, Chethan wrote:

 Hi,

 I need some help in modify the Macro. Current it combine multiple sheet
 in one column. I  need to copy each sheet to one column,

 Like
 Sheet 1 to A
 Sheet 2 to B
 Sheet 3 to C
 Sheet 4 to D

 Etc..


 Sub Combine()
 Dim J As Integer
 Dim rey As Range
 On Error Resume Next
 Sheets(1).Select
 Worksheets.Add
 Sheets(1).Name = Combined
 Sheets(2).Activate
 Range(A1).EntireRow.Select
 Selection.Copy Destination:=Sheets(1).Range(A1)
 For J = 2 To Sheets.Count
 Sheets(J).Activate
 Range(A1).Select
 Selection.CurrentRegion.Select
 Selection.Offset(1, 0).Resize(Selection.Rows.Count - 1).Select
 Selection.Copy Destination:=Sheets(1).Range(A65536).End(xlUp)(2)
 Next
 End Sub

 --

 Chethan

  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.




 --

 Chethan

 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to 

Re: $$Excel-Macros$$ excel Macro

[Pankaj Sharma]

like this

On Sat, Apr 18, 2015 at 3:32 PM, B.N.Chethan Kumar 
chetankumar1...@gmail.com wrote:

 Hi

 Please help me with macro code. I am trying to send file to each
 individual.

 I need to filter and send the file to each individual. Current i have
 macro it work on person.



 --

 Chethan

 --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


Sample file.xlsb
Description: application/vnd.ms-excel.sheet.binary.macroenabled.12

Re: $$Excel-Macros$$ Copying existing Address from column B to column A Using IF statement ( I think).

[Pankaj Sharma]

Hi MIke,,,check this!!!

On Sat, May 2, 2015 at 1:12 AM, Mike B mikeb...@gmail.com wrote:

 I would like to copy this for each location and paste in front inventory
 numbers in Column A(some begin with letters) and also in front of the
 Establishment Totals: VC Count.

 Then I would like to Remove the Word Establishment in from of the
 Totals: VC Count.

 Then I would like to delete the entire row which contained the original
 Establishment address in the names to the left it would be rows 2  9, in
 the attached example workbook sheet 1.


 If any one can help me I would really appreciate it.

 Thank you

 MikeB

  --
 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 Please
 Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
 will not get quick attention or may not be answered.
 2) Don't post a question in the thread of another member.
 3) Don't post questions regarding breaking or bypassing any security
 measure.
 4) Acknowledge the responses you receive, good or bad.
 5) Jobs posting is not allowed.
 6) Sharing copyrighted material and their links is not allowed.

 NOTE : Don't ever post confidential data in a workbook. Forum owners and
 members are not responsible for any loss.
 ---
 You received this message because you are subscribed to the Google Groups
 MS EXCEL AND VBA MACROS group.
 To unsubscribe from this group and stop receiving emails from it, send an
 email to excel-macros+unsubscr...@googlegroups.com.
 To post to this group, send email to excel-macros@googlegroups.com.
 Visit this group at http://groups.google.com/group/excel-macros.
 For more options, visit https://groups.google.com/d/optout.


-- 
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 Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.

NOTE  : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups MS 
EXCEL AND VBA MACROS group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at http://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


PJ.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12