Re: $$Excel-Macros$$ book for excel
On Mon, 3/20/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Monday, March 20, 2017, 3:36 AM On Mon, 3/20/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Monday, March 20, 2017, 2:16 AM On Mon, 3/20/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Monday, March 20, 2017, 1:43 AM On Sun, 3/19/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Sunday, March 19, 2017, 10:27 PM On Sun, 3/19/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: excel-macros@googlegroups.com Date: Sunday, March 19, 2017, 7:54 PM On Sun, 3/19/17, 'Izhar Ul Haq' via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ book for excel To: "excel-macros@googlegroups.com" Date: Sunday, March 19, 2017, 4:12 PM There are so many books from which you may learn excel, and so many example from the internet from which you may learn excel, there is no comprehensive book from which you may learn a lot. From: Cori To: MS EXCEL AND VBA MACROS Sent: Friday, March 17, 2017 3:42 PM Subject: $$Excel-Macros$$ book for excel Can you suggest a book for excel -- 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" grou
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Wed, 3/15/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 2:34 AM On Wed, 3/15/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 2:24 AM On Wed, 3/15/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Wednesday, March 15, 2017, 1:56 AM On Tue, 3/14/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 11:45 PM On Tue, 3/14/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:58 PM On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 8:43 PM On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 8:08 PM On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 7:25 PM On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:42 PM On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:32 PM On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:11 PM On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:49 PM On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:38 PM On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Tue, 3/14/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 7:25 PM On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:42 PM On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:32 PM On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 6:11 PM On Tue, 3/14/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:49 PM On Tue, 3/14/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:38 PM On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 5:26 PM On Tue, 3/14/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 12:10 PM On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 11:04 AM On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:54 AM On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 10:49 AM On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:48 AM On Tue, 3/14/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers To: excel-macros@googlegroups.com Date: Tuesday, March 14, 2017, 9:22 AM Thank you so much it's working perfectly:) On Mar 13, 2017 6:34 PM, "Paul Schreiner" wrote: What I would do is first load your "Roll No." values into a Dictionary object.Then, loop through your
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial
numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 10:49 AM
On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 9:48 AM
On Tue, 3/14/17, Sunil Kumar Yadav
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 9:22 AM
Thank you so much
it's working perfectly:)
On Mar 13, 2017 6:34 PM,
"Paul Schreiner"
wrote:
What
I would do is first load your "Roll No." values
into a Dictionary object.Then, loop through your
"S.No." values and look to see if they are in the
Dictionary.Report the missing
values.Like:
Sub
Find_Missing()
Dim Dict_SN, SN
Dim nRows, nRow, drow
Set Dict_SN = CreateObject("Scripting.
Dictionary")
Dict_SN.RemoveAll
nRows = Range("A1").SpecialCells(
xlLastCell).Row
'
Load Dictionary
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
nRow
End If
Next nRow
ActiveSheet.Range("C2:C65000") .ClearContents
drow = 1
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then
drow = drow + 1
ActiveSheet.Cells(drow, "C").Value = SN
End If
End If
Next nRow
End
SubPaul--
---
“Do all the good you can,
By all the means you can,
In
all the ways you can,
In all the places you
can,
At all the times you can,
To all the people you can,
As
long as ever you can.” - John Wesley
--
---
On Sunday, March 12, 2017 1:23 AM,
Sunil Kumar Yadav
wrote:
Dear Paul,
I have need your help for this
query. Please guide me.
--
Sky
"Good, Better,
Best!Always listen to your
heart, because there lives your
parents.
--
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+unsubscribe@
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 re
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Tue, 3/14/17, hopkinsruben865 via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial
numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 9:48 AM
On Tue, 3/14/17, Sunil Kumar Yadav
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 9:22 AM
Thank you so much
it's working perfectly:)
On Mar 13, 2017 6:34 PM,
"Paul Schreiner"
wrote:
What
I would do is first load your "Roll No." values
into a Dictionary object.Then, loop through your
"S.No." values and look to see if they are in the
Dictionary.Report the missing
values.Like:
Sub
Find_Missing()
Dim Dict_SN, SN
Dim nRows, nRow, drow
Set Dict_SN = CreateObject("Scripting.
Dictionary")
Dict_SN.RemoveAll
nRows = Range("A1").SpecialCells(
xlLastCell).Row
'
Load Dictionary
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN, nRow
End If
Next nRow
ActiveSheet.Range("C2:C65000") .ClearContents
drow = 1
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then
drow = drow + 1
ActiveSheet.Cells(drow, "C").Value = SN
End If
End If
Next nRow
End
SubPaul--
---
“Do all the good you can,
By all the means you can,
In
all the ways you can,
In all the places you
can,
At all the times you can,
To all the people you can,
As
long as ever you can.” - John Wesley
--
---
On Sunday, March 12, 2017 1:23 AM,
Sunil Kumar Yadav
wrote:
Dear Paul,
I have need your help for this
query. Please guide me.
--
Sky
"Good, Better,
Best!Always listen to your
heart, because there lives your
parents.
--
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+unsubscribe@
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+unsubscribe@
googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Tue, 3/14/17, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial
numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 5:19 AM
On Tue, 3/14/17, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 4:20 AM
On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 3:53 AM
On Tue, 3/14/17, julienneschindler via MS EXCEL AND
VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 3:35 AM
On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 2:54 AM
On Mon, 3/13/17, Paul Schreiner
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: "excel-macros@googlegroups.com"
Date: Monday, March 13, 2017, 3:04 PM
What
I would do is first load your "Roll No." values
into a Dictionary object.Then, loop through your
"S.No." values and look to see if they are in the
Dictionary.Report the missing
values.Like:
Sub
Find_Missing()
Dim Dict_SN, SN
Dim nRows, nRow, drow
Set Dict_SN =
CreateObject("Scripting.Dictionary")
Dict_SN.RemoveAll
nRows =
Range("A1").SpecialCells(xlLastCell).Row
'
Load Dictionary
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
nRow
End If
Next nRow
ActiveSheet.Range("C2:C65000").ClearContents
drow = 1
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then
drow = drow + 1
ActiveSheet.Cells(drow, "C").Value = SN
End If
End If
Next nRow
End
SubPaul-
“Do all the
good you can,
By all the means you can,
In all the ways you can,
In all
the places you can,
At all the times you
can,
To all the people you can,
As long as ever you can.” - John Wesley
-
On Sunday, March 12,
2017 1:23 AM, Sunil Kumar Yadav
wrote:
Dear
Paul,
I have
need your help for this query. Please guide
me.
--
Sky
"Good, Better,
Best!Always listen to your
heart, because there lives your
parents.
--
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 an
Re: $$Excel-Macros$$ How to pick numbers which are missing in serial numbers
On Tue, 3/14/17, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are missing in serial
numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 4:20 AM
On Tue, 3/14/17, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 3:53 AM
On Tue, 3/14/17, julienneschindler via MS EXCEL AND VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 3:35 AM
On Tue, 3/14/17, mintaspriggs via MS EXCEL AND VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: excel-macros@googlegroups.com
Date: Tuesday, March 14, 2017, 2:54 AM
On Mon, 3/13/17, Paul Schreiner
wrote:
Subject: Re: $$Excel-Macros$$ How to pick numbers
which are
missing in serial numbers
To: "excel-macros@googlegroups.com"
Date: Monday, March 13, 2017, 3:04 PM
What
I would do is first load your "Roll No." values
into a Dictionary object.Then, loop through your
"S.No." values and look to see if they are in the
Dictionary.Report the missing
values.Like:
Sub
Find_Missing()
Dim Dict_SN, SN
Dim nRows, nRow, drow
Set Dict_SN =
CreateObject("Scripting.Dictionary")
Dict_SN.RemoveAll
nRows =
Range("A1").SpecialCells(xlLastCell).Row
'
Load Dictionary
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "B").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then Dict_SN.Add SN,
nRow
End If
Next nRow
ActiveSheet.Range("C2:C65000").ClearContents
drow = 1
For nRow = 2 To nRows
SN = Trim(ActiveSheet.Cells(nRow, "A").Value)
If (SN & "X" <> "X") Then
If (Not Dict_SN.exists(SN)) Then
drow = drow + 1
ActiveSheet.Cells(drow, "C").Value = SN
End If
End If
Next nRow
End
SubPaul-
“Do all the
good you can,
By all the means you can,
In all the ways you can,
In all
the places you can,
At all the times you
can,
To all the people you can,
As long as ever you can.” - John Wesley
-
On Sunday, March 12,
2017 1:23 AM, Sunil Kumar Yadav
wrote:
Dear
Paul,
I have
need your help for this query. Please guide
me.
--
Sky
"Good, Better,
Best!Always listen to your
heart, because there lives your
parents.
--
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.
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Fri, 3/10/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 9:29 AM On Fri, 3/10/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 9:21 AM On Fri, 3/10/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 8:27 AM On Fri, 3/10/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 4:10 AM On Fri, 3/10/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 3:32 AM On Fri, 3/10/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 3:04 AM On Fri, 3/10/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 1:34 AM On Fri, 3/10/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Friday, March 10, 2017, 12:17 AM On Thu, 3/9/17, Mohd Sadiq wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: "Pankaj Sharma" Cc: excel-macros@googlegroups.com Date: Thursday, March 9, 2017, 4:54 PM Hello Pankaj , Pls response as I need to closed it asap. Regards,Sadiq979223 On Wed, Mar 8, 2017 at 6:50 PM, Mohd Sadiq wrote: Pls response ? On Tue, Mar 7, 2017 at 7:00 PM, Mohd Sadiq wrote: Dear Pankaj , Sorry for delayed response as I was on leave. Here is attached one more resolution for the same but when I am trying to put same formula in another sheet then it does not working Specially when I'm putting in Night Shift. Pls look into this and let me know what should I do now. PN- Column highlighted in Yellow/Orange color. Thanks On Thu, Mar 2, 2017 at 7:46 AM, Pankaj Sharma wrote: resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica1 43pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: Didn't get your query, what you want to do in this sheet, pls mention example with result.
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
On Sat, 3/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 8:02 AM On Sat, 3/4/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 7:10 AM Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It should be start from my provided date...pls recheck that time my file i am sure you will be got my query. On Mar 4, 2017 1:58 AM, "Paul Schreiner" wrote: First of all, your IF() statement:A nested if statement will evaluate each section until it finds a true() option.So, in the first case:IF(TODAY()<=42750evaluates false, that means today is > 42750So the second part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it!Your IF statement could be simplified to:IF(TODAY()<=42750,0, IF(TODAY()<=42781,1.5, IF(TODAY()<=42809,3, IF(TODAY()<=42840,4.5, IF(TODAY()<=42870,6, IF(TODAY()<=42901,7.5, IF(TODAY()<=42931,9, IF(TODAY()<=42962,10.5, IF(TODAY()<=42993,12, IF(TODAY()<=43023,13.5, IF(TODAY()<=43054,15, IF(TODAY()<=43084,16.5, IF(TODAY()>=43085,18,0 ) But, you can simplify it even more.You're using the 15th of the month as the "break point".So, if you were to subtract 15 days, you'd be in the "same" month if the day is > 15, and the PREVIOUS month if it is before the 15th.Basically, by subtracting 15, you're setting the "break point" as the first of the month.So, if you determine the month number: (MONTH(A5-15)) you could say you want 1.5 for each month, or:MONTH(A6-15) * 15Now, the issue is with the first half of January.subtracting 15 makes it December of the PREVIOUS year, and therefore should be 0 instead of 18. so, you need to check to see if the offset year is the same as the current year:=IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)* 1.5) This seems match the same as your sample values for rows 5-9,but I'm not sure what you were doing with rows 12-16Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed to be 1.5 ???I'm not sure what the rules you're using here. as for your second query: You're basically wanting to round off your number to the nearest 1/2.You can accomplish this by first doubling the number and removing the decimal portion(extract just the integer portion)then divide it by 2:=INT(A23*2)/2 this works for your samples. hope this helps. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav wrote: Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula:IF(TODAY()<=42750,0,IF(AND( TODAY()>=42751,TODAY()<=42781) ,1.5,IF(AND(TODAY()>=42782, TODAY()<=42809),3,IF(AND( TODAY()>=42810,TODAY()<=42840) ,4.5,IF(AND(TODAY()>=42841, TODAY()<=42870),6,IF(AND( TODAY()>=42871,TODAY()<=42901) ,7.5,IF(AND(TODAY()>=42902, TODAY()<=42931),9,IF(AND( TODAY()>=42932,TODAY()<=42962) ,10.5,IF(AND(TODAY()>=42963, TODAY()<=42993),12,IF(AND( TODAY()>=42994,TODAY()<=43023) ,13.5,IF(AND(TODAY()>=43024, TODAY()<=43054),15,IF(AND( TODAY()>=43055,TODAY()<=43084) ,16.5,IF(AND(TODAY()>=43085, TODAY()>=43085),18,0)) ))) Please check excel sheet...Thanks in advance for help! -- Sky "Good, Better, Best!Always listen to your heart, because there lives your parents. -- 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
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
On Sat, 3/4/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 8:02 AM On Sat, 3/4/17, Sunil Kumar Yadav wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 7:10 AM Dear Paul, Thank you so much for your support but I don't have need formula calculation start from today. It should be start from my provided date...pls recheck that time my file i am sure you will be got my query. On Mar 4, 2017 1:58 AM, "Paul Schreiner" wrote: First of all, your IF() statement:A nested if statement will evaluate each section until it finds a true() option.So, in the first case:IF(TODAY()<=42750evaluates false, that means today is > 42750So the second part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it!Your IF statement could be simplified to:IF(TODAY()<=42750,0, IF(TODAY()<=42781,1.5, IF(TODAY()<=42809,3, IF(TODAY()<=42840,4.5, IF(TODAY()<=42870,6, IF(TODAY()<=42901,7.5, IF(TODAY()<=42931,9, IF(TODAY()<=42962,10.5, IF(TODAY()<=42993,12, IF(TODAY()<=43023,13.5, IF(TODAY()<=43054,15, IF(TODAY()<=43084,16.5, IF(TODAY()>=43085,18,0 ) But, you can simplify it even more.You're using the 15th of the month as the "break point".So, if you were to subtract 15 days, you'd be in the "same" month if the day is > 15, and the PREVIOUS month if it is before the 15th.Basically, by subtracting 15, you're setting the "break point" as the first of the month.So, if you determine the month number: (MONTH(A5-15)) you could say you want 1.5 for each month, or:MONTH(A6-15) * 15Now, the issue is with the first half of January.subtracting 15 makes it December of the PREVIOUS year, and therefore should be 0 instead of 18. so, you need to check to see if the offset year is the same as the current year:=IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)* 1.5) This seems match the same as your sample values for rows 5-9,but I'm not sure what you were doing with rows 12-16Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed to be 1.5 ???I'm not sure what the rules you're using here. as for your second query: You're basically wanting to round off your number to the nearest 1/2.You can accomplish this by first doubling the number and removing the decimal portion(extract just the integer portion)then divide it by 2:=INT(A23*2)/2 this works for your samples. hope this helps. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav wrote: Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula:IF(TODAY()<=42750,0,IF(AND( TODAY()>=42751,TODAY()<=42781) ,1.5,IF(AND(TODAY()>=42782, TODAY()<=42809),3,IF(AND( TODAY()>=42810,TODAY()<=42840) ,4.5,IF(AND(TODAY()>=42841, TODAY()<=42870),6,IF(AND( TODAY()>=42871,TODAY()<=42901) ,7.5,IF(AND(TODAY()>=42902, TODAY()<=42931),9,IF(AND( TODAY()>=42932,TODAY()<=42962) ,10.5,IF(AND(TODAY()>=42963, TODAY()<=42993),12,IF(AND( TODAY()>=42994,TODAY()<=43023) ,13.5,IF(AND(TODAY()>=43024, TODAY()<=43054),15,IF(AND( TODAY()>=43055,TODAY()<=43084) ,16.5,IF(AND(TODAY()>=43085, TODAY()>=43085),18,0)) ))) Please check excel sheet...Thanks in advance for help! -- Sky "Good, Better, Best!Always listen to your heart, because there lives your parents. -- 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
Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month
On Sat, 3/4/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Saturday, March 4, 2017, 4:03 AM On Fri, 3/3/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 11:35 PM On Fri, 3/3/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ How to make dynamic formula for value change on fix date every month To: "excel-macros@googlegroups.com" Date: Friday, March 3, 2017, 10:27 PM First of all, your IF() statement:A nested if statement will evaluate each section until it finds a true() option.So, in the first case:IF(TODAY()<=42750evaluates false, that means today is > 42750So the second part: IF(AND(TODAY()>=42751 HAS to be true, so there's no reason to test it!Your IF statement could be simplified to:IF(TODAY()<=42750,0, IF(TODAY()<=42781,1.5, IF(TODAY()<=42809,3, IF(TODAY()<=42840,4.5, IF(TODAY()<=42870,6, IF(TODAY()<=42901,7.5, IF(TODAY()<=42931,9, IF(TODAY()<=42962,10.5, IF(TODAY()<=42993,12, IF(TODAY()<=43023,13.5, IF(TODAY()<=43054,15, IF(TODAY()<=43084,16.5, IF(TODAY()>=43085,18,0) But, you can simplify it even more.You're using the 15th of the month as the "break point".So, if you were to subtract 15 days, you'd be in the "same" month if the day is > 15, and the PREVIOUS month if it is before the 15th.Basically, by subtracting 15, you're setting the "break point" as the first of the month.So, if you determine the month number: (MONTH(A5-15)) you could say you want 1.5 for each month, or:MONTH(A6-15) * 15Now, the issue is with the first half of January.subtracting 15 makes it December of the PREVIOUS year, and therefore should be 0 instead of 18. so, you need to check to see if the offset year is the same as the current year:=IF(YEAR(A5-15) <> YEAR(TODAY()),0, MONTH(A5-15)*1.5) This seems match the same as your sample values for rows 5-9,but I'm not sure what you were doing with rows 12-16Why does 16-Mar in row 8 result in 4.5, but 16-Mar in row 13 is supposed to be 1.5 ???I'm not sure what the rules you're using here. as for your second query: You're basically wanting to round off your number to the nearest 1/2.You can accomplish this by first doubling the number and removing the decimal portion(extract just the integer portion)then divide it by 2:=INT(A23*2)/2 this works for your samples. hope this helps. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Friday, March 3, 2017 12:08 PM, Sunil Kumar Yadav wrote: Dear All, I have two query for automatically update value on one fixed date, have created formula but need dynamic formula. Formula:IF(TODAY()<=42750,0,IF(AND(TODAY()>=42751,TODAY()<=42781),1.5,IF(AND(TODAY()>=42782,TODAY()<=42809),3,IF(AND(TODAY()>=42810,TODAY()<=42840),4.5,IF(AND(TODAY()>=42841,TODAY()<=42870),6,IF(AND(TODAY()>=42871,TODAY()<=42901),7.5,IF(AND(TODAY()>=42902,TODAY()<=42931),9,IF(AND(TODAY()>=42932,TODAY()<=42962),10.5,IF(AND(TODAY()>=42963,TODAY()<=42993),12,IF(AND(TODAY()>=42994,TODAY()<=43023),13.5,IF(AND(TODAY()>=43024,TODAY()<=43054),15,IF(AND(TODAY()>=43055,TODAY()<=43084),16.5,IF(AND(TODAY()>=43085,TODAY()>=43085),18,0) Please check excel sheet...Thanks in advance for help! -- Sky "Good, Better, Best!Always listen to your heart, because there lives your parents. -- 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.
Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA
On Fri, 3/3/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 3:43 PM On Fri, 3/3/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 1:58 PM On Fri, 3/3/17, Maatangi M. Karthik wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Friday, March 3, 2017, 7:16 AM Hi there are a few more things I want from the excel. 1. There are some formulae in my excel sheet, I would like to convert them to the backend so that the users cannot change them at any cost 2. There are some fields that affect these formulae in succession, that is, two or three cell values together will make up the formula for another cell. I want to be able to capture the input event and the formula creation based on this input. For example, there is a field where a due date gets calculated. And this column is dependent on 2 other columns' values. so I want to capture those 2 columns' input events and invoke the formula once they are filled. 3. In the excel there are 3 fields, Tax,sales price with tax and sales price without tax. At present I have given the option of entering / choosing the Tax % and entering the without tax price. However, there may be cases where the user will know only the with tax price and the tax %. this creates double work for them as they have to compute the without tax price and then paste it in this excel. I want to avoid this double work and give the option for the users to enter price in either of the columns and then be able to compute based on which one is input. 4. Last query for now, I tried Locking / hiding the formulae for certain fields; however, they don't take effect unless the excel sheet is protected and if I protect the sheet, then users are unable to edit / input their values where necessary. Is there a VBA workaround for this? Most of the date fields have to be locked as well and should not be allowed to be changed by users. On Friday, 3 March 2017 01:02:22 UTC+5:30, Paul Schreiner wrote:I deleted a row and received the "Type Mismatch" error.If you select "Debug", you'll see that the offending line of code is: If Target.Value = "OrderStatus" ThenPutting a "watch" on the Target variable, you'll see that it isn't a single cell, but an array of cells! When you change multiple cells (even by deleting, or inserting, or copying), then the Change event is passed an range ARRAY rather than a single range. In your case, you have a choice.You can add an if() statement like:if (Target.count > 1) then exit sub Or, you can process each cell in the target array like: dim Targ as rangefor each Targ in Target... (replace each occurrence of "Target" with "Targ") ...Next Targ Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Thursday, March 2, 2017 12:33 PM, Maatangi M. Karthik wrote: I am absolutely new to excel VBA. I have a requirement to create an excel to maintain status of orders (there are about 6 / 7 order statuses (2 of which are OrderStatus(no status), Enquiry and taken as samples here ) and based on each status, a specific set of actions have to be performed. I have created the excel in which there are multiple columns & rows, some of the columns have data validations either from a reference sheet or entered as list in the Data validation part and some have formula references. What little coding I could understand, I have done that based on my teeny weeny bit of knowledge + the ideas that I got from checking on various websites. As a result, I am not sure if I have a robust code, although, I have some piece of coding to perform certain actions based on values change in certain columns. Following are the issues that I want help with:
Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA
On Fri, 3/3/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 4:40 AM On Fri, 3/3/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 4:02 AM On Fri, 3/3/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Friday, March 3, 2017, 3:54 AM On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 11:48 PM On Thu, 3/2/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ VBA Run time error 13 type mismatch in Excel 2010 with Datavalidation & VBA To: "excel-macros@googlegroups.com" Date: Thursday, March 2, 2017, 9:32 PM I deleted a row and received the "Type Mismatch" error.If you select "Debug", you'll see that the offending line of code is: If Target.Value = "OrderStatus" ThenPutting a "watch" on the Target variable, you'll see that it isn't a single cell, but an array of cells! When you change multiple cells (even by deleting, or inserting, or copying), then the Change event is passed an range ARRAY rather than a single range. In your case, you have a choice.You can add an if() statement like:if (Target.count > 1) then exit sub Or, you can process each cell in the target array like: dim Targ as rangefor each Targ in Target... (replace each occurrence of "Target" with "Targ") ...Next Targ Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Thursday, March 2, 2017 12:33 PM, Maatangi M. Karthik wrote: I am absolutely new to excel VBA. I have a requirement to create an excel to maintain status of orders (there are about 6 / 7 order statuses (2 of which are OrderStatus(no status), Enquiry and taken as samples here ) and based on each status, a specific set of actions have to be performed. I have created the excel in which there are multiple columns & rows, some of the columns have data validations either from a reference sheet or entered as list in the Data validation part and some have formula references. What little coding I could understand, I have done that based on my teeny weeny bit of knowledge + the ideas that I got from checking on various websites. As a result, I am not sure if I have a robust code, although, I have some piece of coding to perform certain actions based on values change in certain columns. Following are the issues that I want help with: When inserting / deleting row / rows, get error "Type Mismatch error 13" The same error appears while certain columns are extended down to the cells. Same error while cut copy pasting a row Although the run time error occurs, the action is partially completed Earliest response would be much appreciated. My sample excel is attached -- 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 attentio
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 5:41 PM On Thu, 3/2/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 2:05 PM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 11:58 AM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 8:34 AM On Thu, 3/2/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 7:20 AM On Thu, 3/2/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:12 AM On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:08 AM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 5:17 AM On Thu, 3/2/17, Pankaj Sharma wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 4:16 AM resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica143pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: 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
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Thu, 3/2/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 2:05 PM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 11:58 AM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 8:34 AM On Thu, 3/2/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 7:20 AM On Thu, 3/2/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:12 AM On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:08 AM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 5:17 AM On Thu, 3/2/17, Pankaj Sharma wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 4:16 AM resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica143pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: 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/discu ssexcel
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 8:34 AM On Thu, 3/2/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 7:20 AM On Thu, 3/2/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:12 AM On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:08 AM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 5:17 AM On Thu, 3/2/17, Pankaj Sharma wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 4:16 AM resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica143pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: 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/discu ssexcel 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 subscr
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Thu, 3/2/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 7:20 AM On Thu, 3/2/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:12 AM On Thu, 3/2/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 6:08 AM On Thu, 3/2/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 5:17 AM On Thu, 3/2/17, Pankaj Sharma wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 4:16 AM resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica143pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more optio
Re: $$Excel-Macros$$ Fwd: Need your Help on Priority
On Thu, 3/2/17, Pankaj Sharma wrote: Subject: Re: $$Excel-Macros$$ Fwd: Need your Help on Priority To: excel-macros@googlegroups.com Date: Thursday, March 2, 2017, 4:16 AM resolved PJ MIS Analyst Greater Kailash-1, New Delhi. Instagram pj_sharma_Tweeter dude_sharma_pj Facebook www.facebook.com/pankajesica143pankajesica143 We meet for a reason, either you're a blessing or a lesson... On Tue, Feb 28, 2017 at 11:43 PM, Mohd Sadiq wrote: Here is the attached Sample Sheet, Hope u can understand when u will see it :) On Tue, Feb 28, 2017 at 11:37 PM, Mohd Sadiq wrote: Firstly Unhide the sheet , and I need Shift wise Staffing / Present basis of business shift which is mentioned in "A" column I had made Normal some / Split shift details in shared shift however I m getting error in Night Shift when I m trying to used same formula . Regards,Sadiq979223 On Tue, Feb 28, 2017 at 9:52 PM, Pankaj Sharma wrote: 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- 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/discu ssexcel 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+unsubscribe@googl egroups.com. To post to this group, send email to excel-macros@googlegroups.com. Visit this group at https://groups.google.com/grou p/excel-macros. For more options, visit https://groups.google.com/d/op tout. -- Regards Mohd Sadiq 979223 -- Regards Mohd Sadiq 979223 -- 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$$ Re: Once IF is met it is not looping
On Fri, 2/24/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:16 PM On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 6:07 PM On Fri, 2/24/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 1:02 PM On Fri, 2/24/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:57 AM On Fri, 2/24/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:44 AM On Fri, 2/24/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 9:21 AM On Fri, 2/24/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 3:56 AM On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 12:59 AM On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 8:50 PM On Thu, 2/23/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 2:56 PM On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 7:11 AM On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 6:21 PM On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 11:52 AM On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date
Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
On Fri, 2/24/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 1:02 PM On Fri, 2/24/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:57 AM On Fri, 2/24/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 11:44 AM On Fri, 2/24/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 9:21 AM On Fri, 2/24/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 3:56 AM On Fri, 2/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Friday, February 24, 2017, 12:59 AM On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 8:50 PM On Thu, 2/23/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 2:56 PM On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 7:11 AM On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 6:21 PM On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 11:52 AM On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 10:38 AM On Wed, 2/22/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 9:46 AM On Wed, 2/22/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22
Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
On Thu, 2/23/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 8:50 PM On Thu, 2/23/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 2:56 PM On Thu, 2/23/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Thursday, February 23, 2017, 7:11 AM On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 6:21 PM On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 11:52 AM On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 10:38 AM On Wed, 2/22/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 9:46 AM On Wed, 2/22/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 7:40 AM On Wed, 2/22/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 12:07 AM On Tue, 2/21/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Tuesday, February 21, 2017, 4:01 PM On Tue, 2/21/17, Emamuddin Shah wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Tuesday, February 21, 2017, 3:11 PM Dear Paul, hope you have got change to go through the attached files. ---Emam On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote:Hi Paul, Hope you have received my email. Regards Emam On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah wrote:Dear Paul, i will share my both excel sheets, so that you can check where iam wrong and correct it, since the document is confidential i cant share here, plz provide your email id. regards Emam On Thursday, October 20, 2016 at 7:04:17 PM UTC+5:30, Paul Schreiner wrote:Mr. Emamuddin, I'm looking through your code and have encountered some issues. First, your sample file is only one sheet,with a Header in row 1 and 2 rows of data in 24 columns (A:X) In your code, you use: sc = Sheets.CountW
Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
On Wed, 2/22/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 6:21 PM On Wed, 2/22/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 11:52 AM On Wed, 2/22/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 10:38 AM On Wed, 2/22/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 9:46 AM On Wed, 2/22/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 7:40 AM On Wed, 2/22/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 12:07 AM On Tue, 2/21/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Tuesday, February 21, 2017, 4:01 PM On Tue, 2/21/17, Emamuddin Shah wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Tuesday, February 21, 2017, 3:11 PM Dear Paul, hope you have got change to go through the attached files. ---Emam On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote:Hi Paul, Hope you have received my email. Regards Emam On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah wrote:Dear Paul, i will share my both excel sheets, so that you can check where iam wrong and correct it, since the document is confidential i cant share here, plz provide your email id. regards Emam On Thursday, October 20, 2016 at 7:04:17 PM UTC+5:30, Paul Schreiner wrote:Mr. Emamuddin, I'm looking through your code and have encountered some issues. First, your sample file is only one sheet,with a Header in row 1 and 2 rows of data in 24 columns (A:X) In your code, you use: sc = Sheets.CountWhich, of course sets the variable "sc" equal to the total number of sheets. but, when you use: For c = 1 To 27 cold(c) = Sheets(sc).Cells(c, 3).Value Next c You're loading data from the LAST sheet of the workbook.Using your sample file, having only 1 sheet, this will use this sheet.However, your variables "c" and "cold" IMPLY "column" and "Column-Old" but your in your loop: the Cells() function syntax is "Cells(row,column)which means that your loop is loading ROWS 1 to 27, column 3 (C) into the cold() array. Your next loop:For b = lr - (size - 1) To lr will fail with your sample file, since:lr = 4size = 100 so your loop is:For b = -95 to 4 In the first iteration, it will fail for row -95 of the cells() function. Of course, I cannot test the code: Workbooks.Open Filename:=Sheets(sc).Cells(1, 8), Password:=Sheets(sc).Cells(10, 8).Value because the sample file does not have a filename in row 1, column "H" I suggest you utilize the "bre
Re: $$Excel-Macros$$ Re: Once IF is met it is not looping
On Wed, 2/22/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Wednesday, February 22, 2017, 12:07 AM On Tue, 2/21/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: excel-macros@googlegroups.com Date: Tuesday, February 21, 2017, 4:01 PM On Tue, 2/21/17, Emamuddin Shah wrote: Subject: Re: $$Excel-Macros$$ Re: Once IF is met it is not looping To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Tuesday, February 21, 2017, 3:11 PM Dear Paul, hope you have got change to go through the attached files. ---Emam On Monday, February 6, 2017 at 10:01:43 AM UTC+5:30, Emamuddin Shah wrote:Hi Paul, Hope you have received my email. Regards Emam On Wednesday, February 1, 2017 at 12:52:28 PM UTC+5:30, Emamuddin Shah wrote:Dear Paul, i will share my both excel sheets, so that you can check where iam wrong and correct it, since the document is confidential i cant share here, plz provide your email id. regards Emam On Thursday, October 20, 2016 at 7:04:17 PM UTC+5:30, Paul Schreiner wrote:Mr. Emamuddin, I'm looking through your code and have encountered some issues. First, your sample file is only one sheet,with a Header in row 1 and 2 rows of data in 24 columns (A:X) In your code, you use: sc = Sheets.CountWhich, of course sets the variable "sc" equal to the total number of sheets. but, when you use: For c = 1 To 27 cold(c) = Sheets(sc).Cells(c, 3).Value Next c You're loading data from the LAST sheet of the workbook.Using your sample file, having only 1 sheet, this will use this sheet.However, your variables "c" and "cold" IMPLY "column" and "Column-Old" but your in your loop: the Cells() function syntax is "Cells(row,column)which means that your loop is loading ROWS 1 to 27, column 3 (C) into the cold() array. Your next loop:For b = lr - (size - 1) To lr will fail with your sample file, since:lr = 4size = 100 so your loop is:For b = -95 to 4 In the first iteration, it will fail for row -95 of the cells() function. Of course, I cannot test the code: Workbooks.Open Filename:=Sheets(sc).Cells(1, 8), Password:=Sheets(sc).Cells(10, 8).Value because the sample file does not have a filename in row 1, column "H" I suggest you utilize the "breakpoint" functionality of the VBEditor and step through your program one line at a time and monitor the variables. also, to help you with reading the code, try using the column LETTER in the cells() function when you can. That is: Cells(1,"C") for row 1, column C instead of cells(1,3)You're less likely to confuse the row/column. Of course, this doesn't apply when you're referring to the array index. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Wednesday, October 19, 2016 7:39 AM, Emamuddin Shah wrote: there are x rows more than 100 in that i want to update 50 rows or 20 rows whatever. iam able to get row details in array, but those details are not getting updated on next workbook i have attached exscel sheet format which iam using, there is 1 more similar file with coloumns shuffeled please find attached On Tuesday, October 18, 2016 at 7:11:00 PM UTC+5:30, Paul Schreiner wrote:I'm trying to follow.There are easier ways to load the array from the cell values, but I'll get to that later. But:You said that you have 50 rows. that means that with:lr = Activecell.Cells(.Rows.count, "A").End(xlUp).Row + 1 lr (last row) = 51you set:size = 100So, for your loop:For b = lr - (size - 1) To lr b = 51 -(100-1) to 51orb = -48 to 51 so this should produce an error when you execute: cmail(ab) = Cells(b, cold(7)).Value What are the values in column "C" rows 1-27?from your use of cold(), they must be integers. Can you send me a sample file?we can step through it and figure out what happens in the second iteration. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the t
Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)
On Thu, 2/16/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 3:08 AM On Thu, 2/16/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:48 AM On Thu, 2/16/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:39 AM On Thu, 2/16/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:36 AM On Thu, 2/16/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 12:59 AM On Wed, 2/15/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Wednesday, February 15, 2017, 9:04 PM On Wed, 2/15/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Wednesday, February 15, 2017, 5:11 PM On Wed, 2/15/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: "excel-macros@googlegroups.com" Date: Wednesday, February 15, 2017, 4:51 PM There are several ways to approach this.Here's the logic I used:first: Excel date is stored as a number. (the number of days since 1/1/1900)Excel TIME is stored as the decimal part of a day.so, the date/time: 19/11/2016 12:10 PM is actually 42693.50694Excel allows you to DISPLAY this value in a variety of ways, but it doesn't change the value. That means that to determine the time of day without regard to the date, you must subtract the "integer" portion of the value. Now, if you worked from Monday, 2-Feb to Friday, 10-Feb, you expect the result to show you worked 5 days.However, simply subtracting day #42772 from day #42776 gives you a DIFFERENCE of 4 instead of 5!So, you have to be careful with date arithmetic... Excel provides two functions:NetworkdaysNetworkdays.intl Networkdays.intl provides a means to define which days are your "weekend".(some people may work Thu-Fri-Sat-Sun-Mon and have Tuesday and Wednesday off for their "weekend")This also provides a means to say ALL days are workdays! (thereby, "including weekends"). In the file attached, I created a sheet with Named Ranges for Start_Time, End_Time and HolidayListYou can add/remove dates to this HolidayList as appropriate to your needs. The logic is to first calculate the number of workdays between the Start date and End data.=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)Now, the End_Time - Start_Time gives you the fractional part of a day that represents a "full" workday.Multiplying this times the number of workdays results in the number of hours if full days are worked.
Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM)
On Thu, 2/16/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:48 AM On Thu, 2/16/17, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:39 AM On Thu, 2/16/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 1:36 AM On Thu, 2/16/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Thursday, February 16, 2017, 12:59 AM On Wed, 2/15/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Wednesday, February 15, 2017, 9:04 PM On Wed, 2/15/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: excel-macros@googlegroups.com Date: Wednesday, February 15, 2017, 5:11 PM On Wed, 2/15/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Difference between times(Including and excluding weekends with Business hours 9 AM to 8 PM) To: "excel-macros@googlegroups.com" Date: Wednesday, February 15, 2017, 4:51 PM There are several ways to approach this.Here's the logic I used:first: Excel date is stored as a number. (the number of days since 1/1/1900)Excel TIME is stored as the decimal part of a day.so, the date/time: 19/11/2016 12:10 PM is actually 42693.50694Excel allows you to DISPLAY this value in a variety of ways, but it doesn't change the value. That means that to determine the time of day without regard to the date, you must subtract the "integer" portion of the value. Now, if you worked from Monday, 2-Feb to Friday, 10-Feb, you expect the result to show you worked 5 days.However, simply subtracting day #42772 from day #42776 gives you a DIFFERENCE of 4 instead of 5!So, you have to be careful with date arithmetic... Excel provides two functions:NetworkdaysNetworkdays.intl Networkdays.intl provides a means to define which days are your "weekend".(some people may work Thu-Fri-Sat-Sun-Mon and have Tuesday and Wednesday off for their "weekend")This also provides a means to say ALL days are workdays! (thereby, "including weekends"). In the file attached, I created a sheet with Named Ranges for Start_Time, End_Time and HolidayListYou can add/remove dates to this HolidayList as appropriate to your needs. The logic is to first calculate the number of workdays between the Start date and End data.=NETWORKDAYS.INTL($A2,$B2,"011",HolidayList)Now, the End_Time - Start_Time gives you the fractional part of a day that represents a "full" workday.Multiplying this times the number of workdays results in the number of hours if full days are worked. This number needs to be adjusted based on the actual start/end time.If the start or end day is on a weekend, then the actual start/end time is disregarded.IF(WEEKDAY($A2,2)>5,0 Otherwise, for the start time, subtract the actual start time (A2 - int(A2)) from the scheduled "Start_Time".Now, if the person started BEFORE the scheduled start time, this value will be negative and should be disregarded. (unless you wish to calculate "overtime", or allow for a person to come in
Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE
On Sat, 1/28/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Saturday, January 28, 2017, 12:28 PM On Sat, 1/28/17, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Saturday, January 28, 2017, 10:24 AM On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Saturday, January 28, 2017, 9:50 AM On Sat, 1/28/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Saturday, January 28, 2017, 5:22 AM On Fri, 1/27/17, Greg Della-Croce wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Friday, January 27, 2017, 4:00 PM You all caught the problem with this solution (which I still like). I need to find a String within a String, not an exact String match. But I think I found where I went wrong. The InStr command is very picky about what parms you use. Thus when I changed this to InStr(1, Cell.Value, ChkFor, vbTextCompare) the function worked. Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572greg_della-cr...@sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast On Fri, Jan 27, 2017 at 4:43 AM, martinez.david533 via MS EXCEL AND VBA MACROS wrote: -- -- On Fri, 1/27/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Friday, January 27, 2017, 9:50 AM -- -- On Thu, 1/26/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 10:47 PM -- -- On Thu, 1/26/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 9:29 PM -- -- On Thu, 1/26/17, Vicky wrote: Subject: Re: $$Excel-Macros$$ Re: Simple function but it returns #VALUE To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 6:53 PM Hi Greg, The given code only works when you are comparing the contents of the entire cell from one in the range. It won't work if your chkFor cell is matching partially with one of the cells from range. Regards,Vicky On 26-Jan-2017 9:47 PM, "Greg Della-Croce" wrote: Vicky, thanks for the idea. I will see how it works for me. I appreciate the time/effort you put in to help me! Greg Greg Della-CroceSkype: gdellacroce55Cell: 407-408-2572Greg_Della-Croce@ sil.org"If you assume you know the answer, you will miss having a breakthrough. It’s okay to do what you did yesterday, but it will never be amazing again.". - Rod Favarod, CEO of Spredfast
Re: $$Excel-Macros$$ changing required in the attach macro
On Thu, 1/26/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ changing required in the attach macro To: excel-macros@googlegroups.com Date: Thursday, January 26, 2017, 12:48 AM On Wed, 1/25/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ changing required in the attach macro To: excel-macros@googlegroups.com Date: Wednesday, January 25, 2017, 7:15 PM On Wed, 1/25/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ changing required in the attach macro To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Wednesday, January 25, 2017, 4:38 PM First Thank you very much for your suggestion, I'll try my best to describe the title as accurate as possible, since I'm new in macro so there are chances to not define the title as accurate as possible but I'll try my best Second Thank you for your help in the question -- 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. Palatul Sturdza din Bucuresti sediu al Ministerului de Externe in perioada interbelica -- 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.cuparea Ruhrului 11 ian. 1923-31 iulie 1925 parea a da castig de cauza Frantei in dificila chestiune a reparatiilor germane iar P anul Dawes adoptat la 16 august 1924 sublinia puternicul cerc de interese anglo-american in refacerea economica a principalei puteri invinse in primul razboi mondial. Pactul de garantii renan semnat la Locarno la 1 decembrie 1925 si ansambW acordurilor economice si politice sovieto-germane din primavara anului 1926 puneau in evidenta prapastia dintre blocul Marilor Puteri europene invingatoare sau invinse dispuse sa-si faca reciproc concesii dar si completa indiferenta fata de soarta natiunilor din estul Europei curand devenite obiect de negociere in impartirea sferelor de influenta si putere. Replica diplomatilor acestor state din ce in ce mai constiente de minima implicare a Frantei in apararea independentei si suveranitatii lor sau de slabiciunea Societatii Natiunilor a fost participarea acestora la un sistem de tratate si acorduri regionale de securitat
Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES
On Tue, 1/24/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 6:22 AM On Tue, 1/24/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 1:27 AM On Mon, 1/23/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Monday, January 23, 2017, 10:58 PM On Mon, 1/23/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Monday, January 23, 2017, 5:13 PM That's great, Thank you very much for your help -- 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. n anii '50 relatiile romano-sovietice au evoluat de la o stransa cooperare la o distantare ajungandu-se chiar la o autonomie a Partidului Comunist din Romania si la o relativa independenta a statului roman. Elementele noi in relatiile dintre cele doua state au fost determinate de neincrederea personala dintre Gheorghiu-Dej si Hrusciov. O astfel de orientare politica era menita in conceptia liderilor comunisti de la Bucuresti sa afirme cu si mai multa putere rolul partidului comunist in ochii maselor populare. -- 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.xersat in tara in lungi si complicate procese isi gaseste aici o noua confirmare -- 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, a
Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES
On Tue, 1/24/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Tuesday, January 24, 2017, 1:27 AM On Mon, 1/23/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: excel-macros@googlegroups.com Date: Monday, January 23, 2017, 10:58 PM On Mon, 1/23/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ MACRO FOR COPYING A RANGE FOR MULTIPLE TIMES To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Monday, January 23, 2017, 5:13 PM That's great, Thank you very much for your help -- 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. n anii '50 relatiile romano-sovietice au evoluat de la o stransa cooperare la o distantare ajungandu-se chiar la o autonomie a Partidului Comunist din Romania si la o relativa independenta a statului roman. Elementele noi in relatiile dintre cele doua state au fost determinate de neincrederea personala dintre Gheorghiu-Dej si Hrusciov. O astfel de orientare politica era menita in conceptia liderilor comunisti de la Bucuresti sa afirme cu si mai multa putere rolul partidului comunist in ochii maselor populare. -- 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.xersat in tara in lungi si complicate procese isi gaseste aici o noua confirmare -- 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 dat
Re: $$Excel-Macros$$ something wrong with the attach macro
On Fri, 1/20/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ something wrong with the attach macro To: excel-macros@googlegroups.com Date: Friday, January 20, 2017, 3:57 PM On Fri, 1/20/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ something wrong with the attach macro To: excel-macros@googlegroups.com Date: Friday, January 20, 2017, 10:15 AM On Thu, 1/19/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ something wrong with the attach macro To: excel-macros@googlegroups.com Date: Thursday, January 19, 2017, 3:56 PM On Thu, 1/19/17, GENIUS wrote: Subject: Re: $$Excel-Macros$$ something wrong with the attach macro To: "MS EXCEL AND VBA MACROS" Cc: schreiner_p...@att.net Date: Thursday, January 19, 2017, 9:06 AM That's working for me as well, thank you -- 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. erspectiva celor aproape 140 de ani care au trecut de la evenimentele din 1859 confirma in egala masura patriotismul dar si remarcabila abilitate a oamenilor politici ai timpului care au stiut printr-o actiune indrazneata sa puna Marile Puteri in fata faptului implinit si sa depaseasca obstacolele pe care interesele contradictorii ale acestora le asezau in cale i Unirii. De asemenea ca in atatea randuri in istoria ulterioara a tarii deci?ia finala s-a datorat exceptionalei abnegatii pe care natiunea romana a aratat-o acestei cauze. Presiunea populara de la Bucuresti din istoricele zile de 22-24 ianuarie 1859 legitima o mare aspiratie si-i dadea trainicia eternitatii. -- 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.egulament clar s-a lucrat prin circulare redactate de regula de primul -- 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/
Re: $$Excel-Macros$$ converting sheet to macro
On Wed, 1/18/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 9:04 PM On Wed, 1/18/17, hopkinsruben865 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 8:47 PM On Wed, 1/18/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 8:17 PM On Wed, 1/18/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: excel-macros@googlegroups.com Date: Wednesday, January 18, 2017, 6:13 PM On Wed, 1/18/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ converting sheet to macro To: "excel-macros@googlegroups.com" Date: Wednesday, January 18, 2017, 4:37 PM So, you're saying that you're trying to learn how to write macros and you'd like us to write a macro that would take the list in columns A:F and create the list in columns I:L? The problem with that is that you're asking us to take the "input" (columns A:F) and compare it to the output (columns I:L) and "guess" what criteria was used to get the result. On top of that, you have the fields being randomly generated! so, I cannot tell what the original input data was to even BEGIN to guess what criteria is used to determine output. I'm sorry, but I'm not sure where to begin. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 17, 2017 10:57 PM, GENIUS wrote: sometime when you have to learn a new function or formula, for this purpose one must have a file on which the same function or formula must be applied so I need a data set for my learning about a new function or new formula, I have created it thru function but the same I want to create thru macro, so would you please make the same file thru macro. -- 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
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Sun, 1/15/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 1:03 PM On Sun, 1/15/17, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 10:49 AM On Sun, 1/15/17, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 10:03 AM On Sun, 1/15/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 6:21 AM On Sun, 1/15/17, martinez.david533 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 4:39 AM On Sun, 1/15/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Sunday, January 15, 2017, 4:25 AM On Sat, 1/14/17, Devendra Sahay wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Saturday, January 14, 2017, 7:37 AM Hi Paul, Yes both columns have only one column, I just wanted to check howmany values ar availble in the dump using vlookup. I just changed the column referrence in the code but its not running properly. Thanks,Devendra On Fri, Jan 13, 2017 at 5:57 PM, Paul Schreiner wrote: I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner wrote: Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different heading/column combinations.then write to these column numbers.That way, I can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 4:07 AM, Devendra Sahay wrote: Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Sat, 1/14/17, Devendra Sahay wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Saturday, January 14, 2017, 7:37 AM Hi Paul, Yes both columns have only one column, I just wanted to check howmany values ar availble in the dump using vlookup. I just changed the column referrence in the code but its not running properly. Thanks,Devendra On Fri, Jan 13, 2017 at 5:57 PM, Paul Schreiner wrote: I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner wrote: Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different heading/column combinations.then write to these column numbers.That way, I can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 4:07 AM, Devendra Sahay wrote: Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column as Order ID. Column header of "A" can be anything. If you can do so, would be really good because then we can use the same file for multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: First occurrence of... what?First occurrence of the Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: Paul, Thanks for your reply. Can we extract the details of first occurrence. there might be some issues with the sample data, always the data will be unique and clean. On Jan 9, 2017 8:36 PM, "Paul Schreiner" wrote: I'm not sure what RESULT you're expecting. For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping) So, what do you wish to record in the Workbook2.xlsx file? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, January 7, 2017 10:42 PM, Devendra Sahay wrote: Hi Team, Sorry for posting such a long query on the forum, but am working on few reports in which I have to write the Index match formula multiple times on daily basis
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Fri, 1/13/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Friday, January 13, 2017, 2:49 PM On Fri, 1/13/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: "excel-macros@googlegroups.com" Date: Friday, January 13, 2017, 2:27 PM I'm sorry.I'm not sure what you're trying to do! Your two attachments have a single column of data.They have (7) values in common, but I'm not sure what you want to do with them.What macro did you modify? Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Friday, January 13, 2017 2:29 AM, Devendra Sahay wrote: Hi Paul I tried to modify the code according to attached data set, but its not going through. Would you, please look into this. Both details are extracted from ERP, So need to convert them as number before running the macro. On Tue, Jan 10, 2017 at 6:56 PM, Paul Schreiner wrote: Yes, Excel/VBA has nearly unlimited flexibility.But I have no way of knowing what YOU think the possibilities are and what the columns potentially can be. I have applications in which I define variables for the different heading/column combinations.then write to these column numbers.That way, I can rearrange the output columns in any order and the report automatically writes to the appropriate column. but I have no way of determining what you want unless you can describe it in a way I can understand. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Tuesday, January 10, 2017 4:07 AM, Devendra Sahay wrote: Hi Paul, Code is working fine, but can we make this code more flexible like It can identify the header name itself because right now its configured to first column as Order ID. Column header of "A" can be anything. If you can do so, would be really good because then we can use the same file for multiple data sets. Thanks,Devendra On Mon, Jan 9, 2017 at 11:18 PM, Paul Schreiner wrote: Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: First occurrence of... what?First occurrence of the Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: Paul, Thanks for your reply. Can we extract the details of first occurrence. there might be some issues with the sample data, always the data will be unique and clean. On Jan 9, 2017 8:36 PM, "Paul Schreiner" wrote: I'm not sure what RESULT you're expecting. For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping) So, what do you wish to record in the Workbook2.xlsx file? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, January 7, 2017 10:42 PM, Devendra Sah
Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula
On Wed, 1/11/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Wednesday, January 11, 2017, 1:13 AM On Tue, 1/10/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: excel-macros@googlegroups.com Date: Tuesday, January 10, 2017, 7:12 PM On Tue, 1/10/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Index+Match+Indirect+Address formula To: "excel-macros@googlegroups.com" Date: Tuesday, January 10, 2017, 3:59 PM OK, I think I've worked through your requirements...You have a folder with more than 100 workBOOKS.Each workbook is for a specific company (AAB, Infy, TATA, etc.)Each workbook has three workSHEETS (often called "Sheets" and are displayed as "tabs" across the bottom of the Excel window) for:Profit & loss A/CBalance SheetCash Flow Your goal is to have a workbook with a Summary sheet thatshows specific data like:Net salesNet ProfitShare CapitalCashfrom each of the 100+ workbooksYour use of the =INDIRECT() function is nicely done.Many users have difficulty with the concept of using cell values to "indirectly" refer to other worksheets. However, in this case, I wouldn't recommend it. As you no doubt are aware, you cannot use this to refer to a worksheet that doesn't exist.in the same way, you CAN use this to refer to a worksheet in another workbook, but the workbook must be OPEN.That means that if your summary sheet refers to sheets in 100 workbooks, all of the workbooks would need to be open at the same time!Which would require quite a bit in system resources. this kind of thing can be easily done with VBA. I can help with this if you'd like.I've done it before with nearly 300 workbooks. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Tuesday, January 10, 2017 2:34 AM, amar takale wrote: Dear Friends There are more than 100 Excel Sheets (Company Name like AAB, Infy, TATA) in folder. Each Sheet there are 3 tab (Profit & loss A/C, Balalnce Sheet, Cash Flow from 10 years).I Required Separate one Output Excel sheet where I extract specific data (like Net sales, Net Profit, Share Capital, Cash) from Each sheet (like ABB,TATA) from each tab. I require excel formula like extract data from all sheets from each tab and then show in output sheet. From that way I would not required to open each sheet & link it. only open output sheet & see & update data automatically when that sheet update anyone. I think index match +indirect +address formula work for that. I create one output sheet (attached) through this formula but it work for only internal tab & I want formula extract data form external sheet from different tab in folder. Here I attached index match+indirect using formula sheet but it for only internal tab.in this formula required add address command for external sheet name source from that folder. Pls send any solution which is valuable (formula OR VBA) OR any good idea for that. Regards Amar -- 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
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Mon, 1/9/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: excel-macros@googlegroups.com Date: Monday, January 9, 2017, 11:01 PM On Mon, 1/9/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: "excel-macros@googlegroups.com" Date: Monday, January 9, 2017, 7:48 PM Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: First occurrence of... what?First occurrence of the Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: Paul, Thanks for your reply. Can we extract the details of first occurrence. there might be some issues with the sample data, always the data will be unique and clean. On Jan 9, 2017 8:36 PM, "Paul Schreiner" wrote: I'm not sure what RESULT you're expecting. For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping) So, what do you wish to record in the Workbook2.xlsx file? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, January 7, 2017 10:42 PM, Devendra Sahay wrote: Hi Team, Sorry for posting such a long query on the forum, but am working on few reports in which I have to write the Index match formula multiple times on daily basis. So am thinking to write a macro for this but as I am new to VBA, am not able to do so. If you guys can help me out here, would be really appreciated. Scenario- I have a dump file with the record in the columns & rows with headers. I have a another file in which I want to extract the details from the dump file in the respect of header & the value. The value (It could be number or the text), of which details I want to pull from dump file, always be in the first column in the workbook. and also the headers will be also the same in both workbook for easily map the data. Required Solution- Code needs to be written in the workbook 2,where i want to map the values from dump. When I hit the run macro button, macro will open a dialogue box to select the file & after selecting the file, It starts the mapping of values. Sharing both sample files, Dump & the Workbook2. -- With Regards !!!Devendra -- 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.
Re: $$Excel-Macros$$ How to use Index Match for two different files
On Mon, 1/9/17, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ How to use Index Match for two different files To: "excel-macros@googlegroups.com" Date: Monday, January 9, 2017, 7:48 PM Take a look at the macros attached.See if it looks like what you envisioned, or at least gives you a starting point. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, January 9, 2017 11:23 AM, Devendra Sahay wrote: Paul, I mean to say first occurrence of the order id. On Jan 9, 2017 9:51 PM, "Paul Schreiner" wrote: First occurrence of... what?First occurrence of the Order ID?customer ID? Is the data already sorted in the order by which you want to determine "first occurrence"? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, January 9, 2017 11:06 AM, Devendra Sahay wrote: Paul, Thanks for your reply. Can we extract the details of first occurrence. there might be some issues with the sample data, always the data will be unique and clean. On Jan 9, 2017 8:36 PM, "Paul Schreiner" wrote: I'm not sure what RESULT you're expecting. For instance, Order ID #CA-2014-AB10015140-41954 has two entries in the "Dump.xlsx" file.Row 40098 is identical to row 40099 except for the Product related data (ID, Category, Sub-Cat, Name, Sales, Profit, Shipping) So, what do you wish to record in the Workbook2.xlsx file? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Saturday, January 7, 2017 10:42 PM, Devendra Sahay wrote: Hi Team, Sorry for posting such a long query on the forum, but am working on few reports in which I have to write the Index match formula multiple times on daily basis. So am thinking to write a macro for this but as I am new to VBA, am not able to do so. If you guys can help me out here, would be really appreciated. Scenario- I have a dump file with the record in the columns & rows with headers. I have a another file in which I want to extract the details from the dump file in the respect of header & the value. The value (It could be number or the text), of which details I want to pull from dump file, always be in the first column in the workbook. and also the headers will be also the same in both workbook for easily map the data. Required Solution- Code needs to be written in the workbook 2,where i want to map the values from dump. When I hit the run macro button, macro will open a dialogue box to select the file & after selecting the file, It starts the mapping of values. Sharing both sample files, Dump & the Workbook2. -- With Regards !!!Devendra -- 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+unsubscribe@ 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
Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste
On Fri, 1/6/17, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 6:30 AM On Fri, 1/6/17, mahergeorge503 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 5:36 AM On Fri, 1/6/17, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 4:10 AM On Fri, 1/6/17, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 3:01 AM On Fri, 1/6/17, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 2:27 AM On Fri, 1/6/17, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Friday, January 6, 2017, 12:49 AM On Thu, 1/5/17, georgemartin812 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 10:25 PM On Thu, 1/5/17, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 6:55 PM On Thu, 1/5/17, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 2:13 PM On Thu, 1/5/17, ileanakeating via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12:53 PM On Thu, 1/5/17, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 12:02 PM On Thu, 1/5/17, Shrinivas Shevde wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 11:32 AM Dear Paul Thanks for replyPlease find detila you asked forThere will be seperate summary sheet which contain folowingPlease find attached sheetThanks once again for great Help RegardsShrinivas On Wed, Jan 4, 2017 at 7:52 PM, Paul Schreiner wrote: This can be easily done.I recently created a "Combined Summary" report that opened over 500 files in subfolders and copied 160 columns of data from a variable number of rows on the "Summary" sheet of each workbook to the "combined" workbook.Resulting in over 2700 rows of data.Since the files weren't large, it took slightly over 5 minutes to run. It should be simple to do what you want, but how do you want the final report to look?The values in cells E3,F5,E8,E9 from the f
Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste
On Thu, 1/5/17, Shrinivas Shevde wrote: Subject: Re: Fwd: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Date: Thursday, January 5, 2017, 11:32 AM Dear Paul Thanks for replyPlease find detila you asked forThere will be seperate summary sheet which contain folowingPlease find attached sheetThanks once again for great Help RegardsShrinivas On Wed, Jan 4, 2017 at 7:52 PM, Paul Schreiner wrote: This can be easily done.I recently created a "Combined Summary" report that opened over 500 files in subfolders and copied 160 columns of data from a variable number of rows on the "Summary" sheet of each workbook to the "combined" workbook.Resulting in over 2700 rows of data.Since the files weren't large, it took slightly over 5 minutes to run. It should be simple to do what you want, but how do you want the final report to look?The values in cells E3,F5,E8,E9 from the file in folder AA should appear... where?The values in cells E3,F5,E8,E9 from the file in folder BB should appear... where? on the same sheet? Can you send me a couple of samples of what the files look like and what you want the summary sheet to look like? Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Wednesday, January 4, 2017 1:16 AM, Shrinivas Shevde wrote: Dear FriendsWaiting for reply -- Forwarded message -- From: Shrinivas Shevde Date: Tue, Jan 3, 2017 at 4:55 PM Subject: $$Excel-Macros$$ Macro for Copy Paste To: excel-macros@googlegroups.com Dear AllI want a macro for following can Anyone help me. I have a folder ,which contain many folder,In each folder there are excel file(File having single sheet) .I want to copy E3,F5,E8,E9 from each file and paste in one excel sheet.For egSuppose main folder name is "complete"In this folder there are folder,AA,BB,CC and so onIn each folder there areExcel file may be 1,2,3I want to copy the data from each file from cell( E3,F5,E8,E9 ) and want to paste in one excel sheet. -- Shrini -- 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+unsubscribe@ 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. -- Shrini -- 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+unsubscribe@ 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/
Re: $$Excel-Macros$$ Some changes required
On Fri, 12/30/16, storeythomas725 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Some changes required To: excel-macros@googlegroups.com Date: Friday, December 30, 2016, 9:39 PM On Fri, 12/30/16, GENIUS wrote: Subject: Re: $$Excel-Macros$$ Some changes required To: "MS EXCEL AND VBA MACROS" Date: Friday, December 30, 2016, 7:23 AM Hi sourav devrani That's really very great, thank you very much for your help. -- 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. au in anumite zone ale acestuia in scopuri diferite -- 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.-\es Romania s-a numarat printre statele europene care au inregistrat ritmuri -- 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 in IF Function
On Thu, 12/29/16, Mack Mans wrote: Subject: Re: $$Excel-Macros$$ Help in IF Function To: "MS EXCEL AND VBA MACROS" Cc: lupins...@yahoo.com Date: Thursday, December 29, 2016, 11:55 AM On Wednesday, September 7, 2011 at 12:11:20 AM UTC+5, lupinskip wrote:result by IF function regards,Pawel From: anu gomathi To: excel-...@googlegroups.com Sent: Tuesday, September 6, 2011 9:00 PM Subject: $$Excel-Macros$$ Help in IF Function Hi All, Please help me to put the IF function for the below table. If the table value is 0 the product should not be there Attached the file for u r reference Tech OFM Apps Systems Result should be 1 2 0 1 Tech;OFM;Systems 1 2 0 1 Tech;OFM;Systems 1 2 1 0 Tech;OFM;Apps 1 0 0 1 Tech Systems 1 0 0 0 Tech 0 1 0 0 OFM 0 0 1 0 Apps 0 0 0 1 Systems Regards Anu -- -- -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/ exceldailytip 2. Join our LinkedIN group @ http://www.linkedin.com/ groups?gid=1871310 3. Excel tutorials at http://www.excel-macros. blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot. com 5. Excel Tips and Tricks at http://exceldailytip.blogspot. com To post to this group, send email to excel-...@googlegroups.com <><><><><><><><><><><><><><><> <><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/ discussexcel -- 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. INSTITUtIILE DE CULTURa. SOCIETatI SI ASOCIAtII CULTURALE. -- 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$$ sap fico Training in Hyderabad
On Tue, 12/27/16, Sanjay Kumar Maurya wrote: Subject: Re: $$Excel-Macros$$ sap fico Training in Hyderabad To: excel-macros@googlegroups.com Date: Tuesday, December 27, 2016, 1:53 PM What's basic qualification required to participate in SAP fico training. My younger brother is BSC student. Is he eligible? On 27-Dec-2016 12:36 PM, "kumar pmpTraining" wrote: SAP FICO Training in Hyderabad with working IT Consultants. sap fico Training in Hyderabad We are the Best SAP Training Institute in Hyderabad,Ameerpet with advanced course syllabus, Corporate Trainings with 12+ Years MNC Real time Faculty Live Projects, Placements, Free DEMO in Hyderabad, -- 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+unsubscribe@ 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. omania in relatiile internationale in perioada aniior 1930-1936. icolae Titulescu si politica securitatii colective. Anii de la inceputul sceniului patru au adus importante si semnificative mutatii in planul vietii xinomice si politice pe continentul european. S-a dezvoltat cu toate teribilele ale consecinte cea mai puternica criza economica din cate cunoscuse pana unei istoria si in contextul ei a sporit numarul regimurilor politice dictatoriale si rtremiste. Preluarea puterii in Germania de catre partidul nazist condus de Adolf itier a fost imediat insotita de afirmarea revizionismului ca politica oficiala de stat >ea ce a determinat o puternica neliniste in tarile Europei centrale si sud-estice. -- 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
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Sat, 12/17/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 9:16 AM On Sat, 12/17/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 8:14 AM On Sat, 12/17/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 7:17 AM On Sat, 12/17/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 6:32 AM On Sat, 12/17/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 5:18 AM On Sat, 12/17/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Saturday, December 17, 2016, 1:04 AM On Fri, 12/16/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 6:08 PM On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 5:34 PM On Fri, 12/16/16, libertystringer via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 4:56 PM On Fri, 12/16/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 2:42 PM On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 2:14 PM On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 12:26 PM On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 6:03 AM On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Friday, December 16, 2016, 3:28 AM On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Fri, 12/16/16, cronincarmelita via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 6:03 AM
On Fri, 12/16/16, silvers.r via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 3:28 AM
On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 1:40 AM
On Thu, 12/15/16, Vijayendra Rao
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
Unhide
To: excel-macros@googlegroups.com
Date: Thursday, December 15, 2016, 5:12 PM
Hi
Paul,
Thank you very much
for your time, I tried both the option and both are
working
very fine. You have fulfilled my all requirement.
Thank
you
once again for your timely help.🙏
Regards,Vijayendra
2016-12-15 20:17 GMT+05:30
Paul Schreiner :
Look
at the "Thisworkbook" module in the VB
Editor.
Notice
that in the Hide...xlsm workbook, this module has
the
Workbook_Open event macro?
Your
testing.xlsm workbook doesn't have this.
I noticed that you've added an
Auto_Open macro.this is also an
option.You
could simply add a call to HideAllSheets to this
macro
before the Msgbox
line. Paul--
---
“Do all the good you can,
By all the means you can,
In
all the ways you can,
In all the places you
can,
At all the times you can,
To all the people you can,
As
long as ever you can.” - John Wesley
--
---
On Thursday, December 15, 2016 7:43 AM,
Vijayendra
Rao
wrote:
Dear Paul,
I am facing one issue here, I try to
use the macros to my other file by using you have
provided
macros. It is not hide when I open second time. I am
not
sure where I made a mistake or do I need to change
any
settings. Can you please help on the same.
Attached are the both the files.
"Hide & unhilde - 2nd page" is the macro
provided by you and "TESTING - 001" is my
file.
Regards,Vijayendra
2016-12-13 18:24 GMT+05:30
Vijayendra Rao :
Thanks Paul for your
help, it is working fine. You saved my lot of time.
Thank you again.
Regards,Vijayendra
2016-12-13 17:41 GMT+05:30 Paul
Schreiner :
I'd
suggest changing the HideAllSheets macro to first
display
the "read" sheet (what you
called "guidelines"?)then
hide everything EXCEPT the "read" sheet.
Like:
Sub
HideAllSheets()
Dim wsSheet As Worksheet
Sheets("read").Visible = True
For Each wsSheet In ActiveWorkbook.Worksheets
If wsSheet.Name <> "read" Then
wsSheet.Visible = xlSheetHidden
End If
Next wsSheet
End
Sub
Paul--
---
“Do
all the good you can,
By all the means
you can,
In all the ways you can,
In all the places you can,
At
all the times you can,
To all the people you
can,
As long as ever you can.” - John
Wesley
--
---
On Tuesday, December 13, 2016 1:45 AM,
karleenbiggs via MS EXCEL AND VBA MACROS wrote:
--
--
On Tue, 12/13/16,
ileanakeating via MS EXCEL AND VBA MACROS wrote:
Subject: Re:
$$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 8:27 AM
-- --
On Tue, 12/13/16, Vijayendra Rao
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:50 AM
Thanks Paul for quick
help, it fulfilled my most of the
requirement. One last
favor, Now while
opening last saved sheet only visible and
guidelines sheet is hide , is it possible to view
only
first
sheet (sheet name
read) of the file.
Regards,Vijayendra
2016-12-12 18:52
GMT+05:30 Paul Schreiner :
There's
nothing that
is "automatic".
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Fri, 12/16/16, mintaspriggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Friday, December 16, 2016, 1:40 AM
On Thu, 12/15/16, Vijayendra Rao
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Thursday, December 15, 2016, 5:12 PM
Hi
Paul,
Thank you very much
for your time, I tried both the option and both are
working
very fine. You have fulfilled my all requirement. Thank
you
once again for your timely help.🙏
Regards,Vijayendra
2016-12-15 20:17 GMT+05:30
Paul Schreiner :
Look
at the "Thisworkbook" module in the VB
Editor.
Notice
that in the Hide...xlsm workbook, this module has the
Workbook_Open event macro?
Your
testing.xlsm workbook doesn't have this.
I noticed that you've added an
Auto_Open macro.this is also an
option.You
could simply add a call to HideAllSheets to this macro
before the Msgbox
line. Paul--
---
“Do all the good you can,
By all the means you can,
In
all the ways you can,
In all the places you
can,
At all the times you can,
To all the people you can,
As
long as ever you can.” - John Wesley
--
---
On Thursday, December 15, 2016 7:43 AM,
Vijayendra
Rao
wrote:
Dear Paul,
I am facing one issue here, I try to
use the macros to my other file by using you have provided
macros. It is not hide when I open second time. I am not
sure where I made a mistake or do I need to change any
settings. Can you please help on the same.
Attached are the both the files.
"Hide & unhilde - 2nd page" is the macro
provided by you and "TESTING - 001" is my
file.
Regards,Vijayendra
2016-12-13 18:24 GMT+05:30
Vijayendra Rao :
Thanks Paul for your
help, it is working fine. You saved my lot of time.
Thank you again.
Regards,Vijayendra
2016-12-13 17:41 GMT+05:30 Paul
Schreiner :
I'd
suggest changing the HideAllSheets macro to first display
the "read" sheet (what you
called "guidelines"?)then
hide everything EXCEPT the "read" sheet.
Like:
Sub
HideAllSheets()
Dim wsSheet As Worksheet
Sheets("read").Visible = True
For Each wsSheet In ActiveWorkbook.Worksheets
If wsSheet.Name <> "read" Then
wsSheet.Visible = xlSheetHidden
End If
Next wsSheet
End
Sub
Paul--
---
“Do
all the good you can,
By all the means
you can,
In all the ways you can,
In all the places you can,
At
all the times you can,
To all the people you
can,
As long as ever you can.” - John
Wesley
--
---
On Tuesday, December 13, 2016 1:45 AM,
karleenbiggs via MS EXCEL AND VBA MACROS wrote:
--
--
On Tue, 12/13/16,
ileanakeating via MS EXCEL AND VBA MACROS wrote:
Subject: Re:
$$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 8:27 AM
-- --
On Tue, 12/13/16, Vijayendra Rao
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:50 AM
Thanks Paul for quick
help, it fulfilled my most of the
requirement. One last
favor, Now while
opening last saved sheet only visible and
guidelines sheet is hide , is it possible to view only
first
sheet (sheet name
read) of the file.
Regards,Vijayendra
2016-12-12 18:52
GMT+05:30 Paul Schreiner :
There's
nothing that
is "automatic".
Attached
uses a Workbook_open event macro to hide
the sheets when
you OPEN the document.
That way, it doesn't matter whether
the
sheets are visible or not when the
file is saved, but
it will hide the
sheets when it's opened.
Paul--
---
“Do
all the good you can,
By all the means you can,
In all the ways you can,
In all the
places you can,
At all the times you
can,
To all the people you can,
As long as ever you can.” - John Wesley
--
---
On Monday, December 12, 2016 7:50 AM,
karleenbiggs via MS EXCEL AND VBA MACROS
wrote:
-- --
On Mon, 12/12/16, Vijayendra Rao
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
Unhide
To: excel-macros@googlegroups.com
Date: Monday, December 12, 2016, 2:43 PM
Re: $$Excel-Macros$$ Combine two macros in to one
On Wed, 12/14/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Combine two macros in to one To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 11:22 PM On Wed, 12/14/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Combine two macros in to one To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 8:15 PM On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Combine two macros in to one To: excel-macros@googlegroups.com Date: Wednesday, December 14, 2016, 8:09 PM On Wed, 12/14/16, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Combine two macros in to one To: "excel-macros@googlegroups.com" Date: Wednesday, December 14, 2016, 3:57 PM Your buttons call two separate macros.Print_OptionandSUPPRESS_ROWS to combine the two, simply have the Print_Option macro "call" the SUPPRESS_ROWS macro, like: Sub Print_option() SUPRESS_ROWS Application.Dialogs(xlDialogPrint).Show End Sub Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Wednesday, December 14, 2016 2:40 AM, Vijayendra Rao wrote: Dear Experts, I have created two macros, one is for suppress zero rows and another print option. Currently I need to run first suppress zero rows and later print macros. Is it possible to combine both the macros. By running print option, rows should be suppress and later need to show print dialogue option. Attached is the file which is I have created the macros. Request you to help on the same. Regards, Vijayendra 94491 67631 -- 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 grou
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Wed, 12/14/16, kenyattafreed via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:13 AM
On Wed, 12/14/16, keisha.fry via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 10:05 AM
On Wed, 12/14/16, karleenbiggs via MS EXCEL AND VBA MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 3:37 AM
On Wed, 12/14/16, cronincarmelita via MS EXCEL AND
VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and
Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 3:14 AM
On Wed, 12/14/16, julienneschindler via MS EXCEL AND
VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
and
Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 2:51 AM
On Wed, 12/14/16, ileanakeating via MS EXCEL AND
VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
and
Unhide
To: excel-macros@googlegroups.com
Date: Wednesday, December 14, 2016, 12:37 AM
On Tue, 12/13/16, Paul Schreiner
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
and
Unhide
To: "excel-macros@googlegroups.com"
Date: Tuesday, December 13, 2016, 2:11 PM
I'd
suggest changing the HideAllSheets macro to
first
display the "read" sheet (what you
called "guidelines"?)then hide everything
EXCEPT
the
"read"
sheet.
Like:
Sub HideAllSheets()
Dim wsSheet As Worksheet
Sheets("read").Visible = True
For Each wsSheet In ActiveWorkbook.Worksheets
If wsSheet.Name <> "read" Then
wsSheet.Visible = xlSheetHidden
End If
Next wsSheet
End
Sub
Paul-
“Do
all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
-
On Tuesday, December 13, 2016 1:45
AM, karleenbiggs via MS EXCEL AND VBA MACROS
wrote:
On Tue, 12/13/16, ileanakeating via MS EXCEL
AND
VBA
MACROS
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet Hide
and
Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 8:27 AM
On Tue, 12/13/16, Vijayendra Rao
wrote:
Subject: Re: $$Excel-Macros$$ Excel Sheet
Hide
and
Unhide
To: excel-macros@googlegroups.com
Date: Tuesday, December 13, 2016, 3:50 AM
Thanks Paul for quick
help, it fulfilled my most of the
requirement.
One
last
favor, Now while opening last saved sheet
only
visible and
guidelines sheet is hide , is it possible
to
view
only
first
sheet (sheet name read) of the file.
Regards,Vijayendra
2016-12-12 18:52
GMT+05:30 Paul Schreiner :
There's
nothing that is "automatic".
Attached
uses a Workbook_open event macro to hide
the sheets when
you OPEN the document.
That way, it doesn't matter whether the
sheets are visible or not when the file is
saved,
but
it will hide the sheets when it's opened.
Paul--
---
“Do
all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can.” - John Wesley
--
---
On Monday, D
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Tue, 12/13/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 7:50 AM On Tue, 12/13/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 4:07 AM On Tue, 12/13/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:56 AM On Tue, 12/13/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 3:50 AM Thanks Paul for quick help, it fulfilled my most of the requirement. One last favor, Now while opening last saved sheet only visible and guidelines sheet is hide , is it possible to view only first sheet (sheet name read) of the file. Regards,Vijayendra 2016-12-12 18:52 GMT+05:30 Paul Schreiner : There's nothing that is "automatic". Attached uses a Workbook_open event macro to hide the sheets when you OPEN the document. That way, it doesn't matter whether the sheets are visible or not when the file is saved, but it will hide the sheets when it's opened. Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: -- -- On Mon, 12/12/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 2:43 PM Thanks Paul for quick guidance. This file is used by many people and they are working without reading few guidelines from first sheet. There may be chances of not using the sheet_hide macro option by other user. Is there any macros which automatically hide those sheets when close the file. Attached is the my workbook. Regards,Vijayendra 2016-12-12 17:46 GMT+05:30 Paul Schreiner : Just as you created a macro to "unhide" the sheets, you need to create a macro to hide them. Additionally, you can create a BeforeSave event to check to see if the sheets are displayed.Then execute your "Sheets_Hide" macro to hide the sheets before saving (that way the sheets are always hidden before saving the file) Note: Using a macro, you can use .Visible = xlVeryHiddenwhich will hide the sheets and they will not show up when trying to manually unhide the sheets! Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, December 12, 2016 7:04 AM, Vijayendra Rao wrote: Hi Experts, I have created one excel file and except one sheet all sheets are hided. I have added shape button in first sheet to unhide all the sheets with the help of macro. When i worked and saved all sheets will be visible when I opened again. Is it possible to remain hide those sheets after saving the file. Request you to help on the same.-- Regards, Vijayendra 94491 67631 -- 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 an
Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide
On Tue, 12/13/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Tuesday, December 13, 2016, 1:18 AM On Mon, 12/12/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 11:44 PM On Mon, 12/12/16, derrickandrew994 via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 11:05 PM On Mon, 12/12/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 8:53 PM On Mon, 12/12/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 4:53 PM On Mon, 12/12/16, Paul Schreiner wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: "excel-macros@googlegroups.com" Date: Monday, December 12, 2016, 3:22 PM There's nothing that is "automatic". Attached uses a Workbook_open event macro to hide the sheets when you OPEN the document. That way, it doesn't matter whether the sheets are visible or not when the file is saved, but it will hide the sheets when it's opened. Paul- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley - On Monday, December 12, 2016 7:50 AM, karleenbiggs via MS EXCEL AND VBA MACROS wrote: On Mon, 12/12/16, Vijayendra Rao wrote: Subject: Re: $$Excel-Macros$$ Excel Sheet Hide and Unhide To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 2:43 PM Thanks Paul for quick guidance. This file is used by many people and they are working without reading few guidelines from first sheet. There may be chances of not using the sheet_hide macro option by other user. Is there any macros which automatically hide those sheets when close the file. Attached is the my workbook. Regards,Vijayendra 2016-12-12 17:46 GMT+05:30 Paul Schreiner : Just as you created a macro to "unhide" the sheets, you need to create a macro to hide them. Additionally, you can create a BeforeSave event to check to see if the sheets are displayed.Then execute your "Sheets_Hide" macro to hide the sheets before saving (that way the sheets are always hidden before saving the file) Note: Using a macro, you can use .Visible = xlVeryHiddenwhich will hide the sheets and they will not show up when trying to manually unhide the sheets! Paul-- --- “Do all the good you can, By all the means you can, In all the ways you can, In all the places you can, At all the times you can, To all the people you can, As long as ever you can.” - John Wesley -- --- On Monday, December 12, 2016 7:04 AM, Vijayendra Rao wrote: Hi Experts, I have created one excel file and except one sheet all sheets are hided. I have added shape button in first sheet to unhide all the sheets with the help of macro. When i worked and saved all sheets will be visible when I opened again. Is it possible to remain hide those sheets after saving the file. Request you to help on the same.-- Regards, Vijayendra
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Mon, 12/12/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Monday, December 12, 2016, 12:18 AM On Sun, 12/11/16, keisha.fry via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Sunday, December 11, 2016, 10:55 PM On Sun, 12/11/16, taher bootwala wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: "MS EXCEL AND VBA MACROS" Cc: julienneschind...@yahoo.com Date: Sunday, December 11, 2016, 8:12 PM PLEASE ADD 8819978652 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> 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+unsubscribe@ googlegroups.com. >> To post to this group, send email to excel-...@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.
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sat, 12/10/16, margaretatolliver via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:49 PM On Sat, 12/10/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:45 PM On Sat, 12/10/16, karleenbiggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 4:06 PM On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:03 PM On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:37 AM On Sat, 12/10/16, LEARNING EXCEL wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:35 AM Please add my Number 9600160150 On 10 December 2016 at 13:01, sugat misra wrote: Please adde me as well 8880740879 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> 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.
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sat, 12/10/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 1:39 PM On Sat, 12/10/16, cronincarmelita via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 1:15 PM On Sat, 12/10/16, mintaspriggs via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:26 PM On Sat, 12/10/16, ashleypartridge via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:03 PM On Sat, 12/10/16, spainy via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:37 AM On Sat, 12/10/16, LEARNING EXCEL wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 11:35 AM Please add my Number 9600160150 On 10 December 2016 at 13:01, sugat misra wrote: Please adde me as well 8880740879 On Saturday, 10 December 2016 03:55:25 UTC+5:30, julienne...@yahoo.com wrote: -- -- On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-...@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> 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.
Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group
On Sat, 12/10/16, kenyattafreed via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 1:22 AM On Sat, 12/10/16, julienneschindler via MS EXCEL AND VBA MACROS wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Saturday, December 10, 2016, 12:20 AM On Fri, 12/9/16, XLS time wrote: Subject: Re: $$Excel-Macros$$ Re: VBA Macro - Whatsapp Group To: excel-macros@googlegroups.com Date: Friday, December 9, 2016, 8:38 AM 8860067995 -- On Fri, Dec 9, 2016 at 9:36 AM, N.MADHAN wrote: Could you please add my number +91 9442944095 On 12/9/16, Amit Kumar wrote: > Please add my number 9618644088 > > > On Mon, Sep 12, 2016 at 1:21 PM, V. Kiran Kumar > wrote: > >> Pls add my number +265999336673 >> >> On Sunday, 11 September 2016 08:01:31 UTC+2, Prabhu Pinky wrote: >>> >>> Hi Friends, >>> >>> Since i have created Whatsapp group for VBA Macro learners/experts. >>> >>> And i have added many peoples in this group. Please Msg me to 9500087194 >>> in whatsapp to get added in this group. if anyone missed or not yet >>> added >>> even you requested earlier. >>> >>> Thanks & Regards, >>> Prabhu R >>> >> -- >> 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+unsubscribe@ 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+unsubscribe@ 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. > -- Thanks N.MADHAN -- 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 Fa
