subject:"Re\: $$Excel\-Macros$$ need help in excel"

Re: $$Excel-Macros$$ Need help on Excel

2016-11-21 Thread Mohd Sadiq

Want to excel formula on this

Regards,

Mohd Sadiq

On Nov 21, 2016 6:54 PM, "Paul Schreiner"  wrote:

> OK, I'd need a bit more information.
> I can make LOTS of assumptions, but I'd rather not do this multiple times.
>
> So, for each row of data, you want to determine the FIRST column
> containing WO and the LAST column containing WO.
>
> Are you wanting to use VBA or Excel functions?
>
> A simple function would be:
> Public Function Vacation(iRange As Range, FirstFlag As Boolean)
> Debug.Assert True
> Dim Rng
> For Each Rng In iRange
> If (Rng.Value = "WO") Then
> Vacation = Cells(1, Rng.Column).Value
> If (FirstFlag) Then Exit For
> End If
> Next Rng
> End Function
>
> To use it, you could use:
> =vacation($B3:$H3,TRUE) for the first "WO" and
> =vacation($B3:$H3,FALSE) for the last
>
> *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, November 21, 2016 7:43 AM, Mohd Sadiq 
> wrote:
>
>
> Team ,
>
> Pls update on this
>
> On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq 
> wrote:
>
> Team , I have data where I want to first date of "WO" and last date of
> Week off in a week.
>
> attached is the excel sheet for your reference.
>
> Pls treat it on priority
>
>
>
> 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 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.
>
>
>
>
> --
>
>
>
> 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 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

Re: $$Excel-Macros$$ Need help on Excel

2016-11-21 Thread Paul Schreiner

OK, I'd need a bit more information.I can make LOTS of assumptions, but I'd 
rather not do this multiple times.
So, for each row of data, you want to determine the FIRST column containing WO 
and the LAST column containing WO.
Are you wanting to use VBA or Excel functions? 
A simple function would be:Public Function Vacation(iRange As Range, FirstFlag 
As Boolean)
    Debug.Assert True
    Dim Rng
    For Each Rng In iRange
    If (Rng.Value = "WO") Then
    Vacation = Cells(1, Rng.Column).Value
    If (FirstFlag) Then Exit For
    End If
    Next Rng
End Function
To use it, you could use:=vacation($B3:$H3,TRUE) for the first "WO" 
and=vacation($B3:$H3,FALSE) for the last
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, November 21, 2016 7:43 AM, Mohd Sadiq  
wrote:
 

 Team ,
Pls update on this 
On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq  wrote:

Team , I have data where I want to first date of "WO" and last date of Week off 
in a week.
attached is the excel sheet for your reference.

Pls treat it on priority



RegardsMohd Sadiq979223-- 
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.




-- 



RegardsMohd Sadiq979223-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel
 
FORUM RULES
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
2) Don't post a question in the thread of another member.
3) Don't post questions regarding breaking or bypassing any security measure.
4) Acknowledge the responses you receive, good or bad.
5) Jobs posting is not allowed.
6) Sharing copyrighted material and their links is not allowed.
 
NOTE : Don't ever post confidential data in a workbook. Forum owners and 
members are not responsible for any loss.
--- 
You received this message because you are subscribed to the Google Groups "MS 
EXCEL AND VBA MACROS" group.
To unsubscribe from this group and stop receiving emails from it, send an email 
to excel-macros+unsubscr...@googlegroups.com.
To post to this group, send email to excel-macros@googlegroups.com.
Visit this group at https://groups.google.com/group/excel-macros.
For more options, visit https://groups.google.com/d/optout.


   

-- 
Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s 
=TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @ 
https://www.facebook.com/discussexcel

FORUM RULES

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

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

Re: $$Excel-Macros$$ Need help on Excel

2016-11-21 Thread Mohd Sadiq

Team ,

Pls update on this

On Sat, Nov 19, 2016 at 2:00 AM, Mohd Sadiq  wrote:

> Team , I have data where I want to first date of "WO" and last date of
> Week off in a week.
>
> attached is the excel sheet for your reference.
>
> Pls treat it on priority
>
>
>
> 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 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.
>



-- 



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 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$$ Need help for Excel - sort expiry date in a seperate sheet

2012-10-27 Thread ashish koul

attach the sample file

On Sat, Oct 27, 2012 at 10:41 PM, Rupendra Phatak rup...@gmail.com wrote:

 Hi Friends,

 I am having data in a excel  which contains records of maturity
 deposits/securities in different. sheets the only common field is
 Maturity Date in all sheets.

 Now what i need is to sort the records in a separate sheet  which are
 due within next 7 days from today when i run macro.



 --
 regards
 Rupu

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

 FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

 6) Jobs posting is not allowed.

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

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





-- 
*Regards*
* *
*Ashish Koul*


*Visit*
*http://www.excelvbamacros.com/*
*http://www.accessvbamacros.com/*

P Before printing, think about the environment.

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

FORUM RULES (1120+ members already BANNED for violation)

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

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

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

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

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

6) Jobs posting is not allowed.

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

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

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

2012-01-30 Thread Rajan_Verma

You can use this for text also

 

Sub isExist()

On Error Resume Next

If WorksheetFunction.Match(Range(rngValues).Text,
Worksheets(Sheet2).Range(d4:d10), 0) Then

  If Err.Number = 1004 Then

Err.Clear

On Error GoTo 0: On Error GoTo -1

MsgBox Values not found

  Else

MsgBox Range(rngValues).Value

  End If

End If

End Sub

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Pascal Baro
Sent: Jan/Sun/2012 09:44
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help in Excel-VBA code to write function in
coding

 

Hi Ashish,

 

Please find another version. With this, I've worked out the fact your data
source is only numbers but either it is entered as text either it is
copy/paste and excel reads it as text. Some of the things I have tried woud
take an input such as 76 and look for everything in the data source that
matches 76 ex.: 7690 would match... So here I consider you only want to
compare number. Tough my code is quite basic if someone looks at it.

 

Applying Rajan_Verma

 

Sub isExist()

On Error Resume Next

If WorksheetFunction.Match(Worksheets(Sheet1).Range(b4).Value,
Worksheets(Sheet2).Range(d4:d10), 0) Then

  If Err.Number = 1004 Then

Err.Clear

On Error GoTo 0: On Error GoTo -1

MsgBox Values not found

  Else

MsgBox Range(rngValues).Value

  End If

End If

End Sub

 

The code above returns false if you compare 8902 to 8902, the first one is
a number, the second one is a text... and I can't make it work if I format
8902 as a number, nothing happens. Why?

 

While I'm learning, I'm helping so sorry for asking a question that might
not be of your concern Ashish...

 

HTH,

 

pascal baro

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

2012-01-29 Thread dguillett1

try

Option Explicit

Sub Look2()
Dim mf As Range
  Set mf = Sheet2.Columns(D).Find(What:=Range(b4), _
  LookIn:=xlValues, LookAt:=xlWhole, SearchOrder:=xlByRows, _
  searchDirection:=xlNext, SearchFormat:=False)
  If Not mf Is Nothing Then MsgBox mf.Row
End Sub

Don Guillett
SalesAid Software
dguille...@gmail.com

From: Pascal Baro 
Sent: Sunday, January 29, 2012 10:13 AM
To: excel-macros@googlegroups.com 
Subject: $$Excel-Macros$$ Need help in Excel-VBA code to write function in 
coding

Hi Ashish, 

Please find another version. With this, I've worked out the fact your data 
source is only numbers but either it is entered as text either it is copy/paste 
and excel reads it as text. Some of the things I have tried woud take an input 
such as 76 and look for everything in the data source that matches 76 ex.: 7690 
would match... So here I consider you only want to compare number. Tough my 
code is quite basic if someone looks at it.

Applying Rajan_Verma

Sub isExist()
On Error Resume Next
If WorksheetFunction.Match(Worksheets(Sheet1).Range(b4).Value, 
Worksheets(Sheet2).Range(d4:d10), 0) Then
  If Err.Number = 1004 Then
Err.Clear
On Error GoTo 0: On Error GoTo -1
MsgBox Values not found
  Else
MsgBox Range(rngValues).Value
  End If
End If
End Sub

The code above returns false if you compare 8902 to 8902, the first one is a 
number, the second one is a text... and I can't make it work if I format 8902 
as a number, nothing happens. Why?

While I'm learning, I'm helping so sorry for asking a question that might not 
be of your concern Ashish...

HTH,

pascal baro
-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please Help, 
Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will not get 
quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in 
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.
 
--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

2012-01-20 Thread Rajan_Verma

Try this one:

 

Sub isExist()

On Error Resume Next

If WorksheetFunction.Match(Range(rngValues).Value, Range(List), 0)
Then

If Err.Number = 1004 Then

Err.clear

On error goto 0:on Error Goto -1

MsgBox Values not found

Else

MsgBox Range(rngValues).Value

End If

End If

End Sub

 

 

 

From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Ashish Bhalara
Sent: Jan/Thu/2012 12:30
To: excel-macros@googlegroups.com
Subject: Fwd: $$Excel-Macros$$ Need help in Excel-VBA code to write function
in coding

 

 


Dear experts,

 

I have lower level knowledge in excel vba, so please check below coding
which not working. I need the Msgbox when entered value match from another
sheet. The example sheet attached herewith. Please also know the basic rules
of how to use excel function in Visual Basic.

 

 

 If match(Worksheets(Account Statement).Range(E6).Value,
Worksheets(Account Status).Range(K:K), 0)  0 Then

  MsgBox Bill is made of this Chassis

 End If

 

Kindly solve my query that I use macro in .xlsx format, so what is the
difference to use macro in macro-enable workbook format and simple .xlsx
format?

 

Thanks  Regards

 

Ashish Bhalara

9624111822

 

 

-- 
FORUM RULES (986+ members already BANNED for violation)
 
1) Use concise, accurate thread titles. Poor thread titles, like Please
Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will
not get quick attention or may not be answered.
 
2) Don't post a question in the thread of another member.
 
3) Don't post questions regarding breaking or bypassing any security
measure.
 
4) Acknowledge the responses you receive, good or bad.
 
5) Cross-promotion of, or links to, forums competitive to this forum in
signatures are prohibited. 
 
NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.
 

--
To post to this group, send email to excel-macros@googlegroups.com

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

2012-01-18 Thread NOORAIN ANSARI

Dear Ashish,

Please try below code...

Function check_value(rng As Range) As String
Dim cell, rng1 As Range
Set rng1 = Sheet2.Range(D4:D10)
For Each cell In rng1
If cell.Value = rng.Value Then
MsgBox Bill is made of this Chassis, vbInformation
End If
Exit Function
Next cell
End Function

see attached sheet..

On Thu, Jan 19, 2012 at 12:23 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:

 Dear experts,

 I have lower level knowledge in excel vba, so please check below coding
 which not working. I need the Msgbox when entered value match from another
 sheet. The example sheet attached herewith. Please also know the basic
 rules of how to use excel function in Visual Basic.

 Kindly solve my query that I use macro in .xlsx format, so what is the
 difference to use macro in macro-enable workbook format and simple .xlsx
 format?

 Thanks  Regards

 Ashish Bhalara
 9624111822

 --
 FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

 NOTE : Don't ever post personal or confidential data in a workbook. Forum
 owners and members are not responsible for any loss.


 --
 To post to this group, send email to excel-macros@googlegroups.com




-- 
Thanks  regards,
Noorain Ansari
 *http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

-- 
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE  : Don't ever post personal or confidential data in a workbook. Forum 
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com


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

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

2012-01-18 Thread NOORAIN ANSARI

Dear Ashish,
Excel 2007 File Type Extension

- xlsx - Excel http://en.wikipedia.org/wiki/Microsoft_Excel 2007 XML
Workbook
- xlsm - Excel 2007 XML Macro-Enabled Workbook
- xltx - Excel 2007 XML Template
- xltm - Excel 2007 XML Macro-Enabled Template
- xlsb - Excel 2007 binary workbook (BIFF12)
- xlam - Excel 2007 XML Macro-Enabled Add-In
- xll - Excel 2007 compiled
macros[1]http://en.wikipedia.org/wiki/Microsoft_Office_2007_filename_extensions#cite_note-0

--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

On Thu, Jan 19, 2012 at 12:23 PM, Ashish Bhalara
ashishbhalar...@gmail.comwrote:

Dear experts,

I have lower level knowledge in excel vba, so please check below coding
which not working. I need the Msgbox when entered value match from another
sheet. The example sheet attached herewith. Please also know the basic
rules of how to use excel function in Visual Basic.

Kindly solve my query that I use macro in .xlsx format, so what is the
difference to use macro in macro-enable workbook format and simple .xlsx
format?

Thanks Regards

Ashish Bhalara
9624111822

--
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

--
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

2012-01-18 Thread NOORAIN ANSARI

Dear Ashish,

Please ignore previous mail..use it

Function check_value(rng As Range) As String
Dim cell, rng1 As Range
Set rng1 = Sheet2.Range(D4:D10)
For Each cell In rng1
If cell.Value = rng.Value Then
MsgBox Bill is made of this Chassis, vbInformation
Exit Function
End If
Next cell
End Function

On Thu, Jan 19, 2012 at 12:38 PM, NOORAIN ANSARI
noorain.ans...@gmail.comwrote:

Dear Ashish,
Excel 2007 File Type Extension

--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/*http://noorain-ansari.blogspot.com/

On Thu, Jan 19, 2012 at 12:23 PM, Ashish Bhalara
ashishbhalar...@gmail.com wrote:

Dear experts,

Kindly solve my query that I use macro in .xlsx format, so what is the
difference to use macro in macro-enable workbook format and simple .xlsx
format?

Thanks Regards

Ashish Bhalara
9624111822

--
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

--
Thanks regards,
Noorain Ansari
*http://excelmacroworld.blogspot.com/*http://excelmacroworld.blogspot.com/
*http://noorain-ansari.blogspot.com/* http://noorain-ansari.blogspot.com/

--
FORUM RULES (986+ members already BANNED for violation)

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

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

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

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

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

NOTE : Don't ever post personal or confidential data in a workbook. Forum
owners and members are not responsible for any loss.

--
To post to this group, send email to excel-macros@googlegroups.com

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

2011-03-08 Thread Sanjoy Nath

use concatenate function or  operator like

=A1  B1  C1

   etc



On Tue, Mar 8, 2011 at 3:02 PM, sudhir kumar bluecore...@gmail.com wrote:

 Hi,

 Can u send Excel Sheet of this example.

 thanx


 On 7 March 2011 12:17, Krish kandy.kr...@gmail.com wrote:

 Hi ,

 I have data in row and column 1-3, and needs to club the data in
 single row and column since the data acorss three columns,

 Pls help me.

 Regards,
 Krish Kandy.

 --

 --
 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-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




 --
 
 Sudhir Verma
 Asstt. Mngr. A/c's
 9818479722
 *
 P think Before you print
 *
 *
 **
 Life is Very beautiful !!!
 *
 *
 ¨`•.•´¨) Always
 `•.¸(¨`•.•´¨) Keep
 (¨`•.•´¨)¸.•´ Smiling!
  `•.¸.•´.
 *
 *
 *
   *Happy **Valentine** Day  *
   \ ¦ /
 (ò ó)
 _ ___o0o___(_)___o0o__
 ___¦_¦_¦_¦_¦
 ¦_¦_¦_¦_¦__
 ___¦_¦_¦_¦_¦
  *Drink Bear Save Water*
 *
 *

   --

 --
 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-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/discussexcel




-- 
Your Sincerely
Sanjoy Nath
Engineer
EOL Gurgaon
EOL/M/NZ/Engg.Dept.(Haryana Division)



 We prepare custom tools (Softwares) to prepare Autocad Drawings
 Of the Engineering Components.Some Of Our Clients Provide the
 Design Calculation Steps And Sample Drawings (Templates for Eg the
 Nuts , Bolts , Screws , Stair Cases , Patterns , Geometries , LandScapes,
 Layouting, General Engineering Components , Mechanical Engineering
Components,
 Civil/Structural Engineering Components,Architectural Components) to follow
 and to meet their standards and specifications.The Tools we develop are
 entirely customised and specific for clients  own requirements and
 they are not re distributed to others.

  Let me be precise regarding our job profile and what we can do for you
 Suppose you have to develop any design component repeatedly for different
projects
Only Some of its parameters are changing and you need the drawing for that
component.
you cannot prepare the block for that.Since even in the custom Block in
Autocad you
cannot controll all the parameters automatically and very few users in
Autocad can follow
the technicalities to handle the customisable blocks in Autocad.
On the Other hand , customisable blocks cannot decide the dimensions   by
themselves nor can
compute the design calculations.But And it takes a long time to develop the
drawings.
Moreover if there is any revision in the General Arrangement drawings or
Facilities,
the entire things need to change and you have to start from the scratch
again and
draftsman forget to change some of the dimensions or the BOQ values in the
tables
attached to the drawings.These things are ridiculous to your clients.
We can understand these issues since we are in the design/Detailing and
drafting industry
for last 10 years and have worked for more than 6 companies(Directly as
employee or in parttime)
 in 3 domains
(Piping,Architecture and Structural)
And now we have attained the expertise to develop the dxf files from
Excel/EXE Applications.
We can develop and provide the tools (EXE tools or Excel Files as you need
and as much you ask for)
to develop these drawings automatically.

   Suppose you want to develop the drawings of doors/Panels with some given
features many/some of
which will change every time from task to task or from revision to revision
or from project to project.
You have to revise the drawings and your draftsman/detailer will take 30
minutes to 1 hour to revise each of
these several components.We can save this valuable time for you through the
tools.
Moreover many a time it happens that you have to prepare the scaled drawings
from the data in STAAD pro
and you have to type the utilisation ratios and reactions beside the members
including the sizes also.
Have you ever calculated how much time you spend on that and how much

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

2010-12-08 Thread Dilip Pandey

Hi Sharath,

Please check the attached file which has the resolution as per your
requirements. :)

Best Regards,
DILIPandey

On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani 
sharath.c.sambr...@gmail.com wrote:

 Hi,

 I have two columns A and B.

 column A contains list of tasks and column B contains sub-tasks
 against each primary task.

 i would like to have two drop down cells in column C and D.

 whenever i select an option in the dropdown in cell C1, the list in D1
 should show only the sub-tasks that belong to the respective primary
 task.

 eg: in the attached spreadsheet, if i select Admin / Reporting in
 the list, in the other cell only the following sub-tasks should
 reflect:

 follow-up and reminder mails for Onhold/Offline/PCR records
 Metrics reports (for SKAs and above)
 Workplan preparation (for SKAs and above)
 Logistics for training (for Training SKA)
 Updating time entry reports
 Updating project tracker (for SKAs and above)
 Monitoring Service Desk (for SKAs and above)
 query resolution time b/w QA and KA
 query resolution time b/w KA and SKA
 Monitoring quals mailbox
 Updating KL tracker (for docs KL team)

 i hope this request is clear.

 let me know if you have any questions.

 your help is much appreciated.

 sharath

 --

 --
 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-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




-- 
Thanks  Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
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-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts


Dynamic Validataion by DILIPandey.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

2010-12-08 Thread Dilip Pandey

You are welcome Sharat.

Best Regards,
DILIPandey

On 12/8/10, Sharath Sambrani sharath.c.sambr...@gmail.com wrote:
 Fantastic!!!

 Thanks a ton Dilip!

 Sharath

 -- Forwarded message --
 From: Dilip Pandey dilipan...@gmail.com
 Date: Wed, Dec 8, 2010 at 8:43 PM
 Subject: Re: $$Excel-Macros$$ Need help on Excel Dynamic List
 To: excel-macros@googlegroups.com
 Cc: sharath.c.sambr...@gmail.com


 Hi Sharath,

 Please check the attached file which has the resolution as per your
 requirements. :)

 Best Regards,
 DILIPandey

   On Wed, Dec 8, 2010 at 7:38 PM, Sharath Sambrani 
 sharath.c.sambr...@gmail.com wrote:

 Hi,

 I have two columns A and B.

 column A contains list of tasks and column B contains sub-tasks
 against each primary task.

 i would like to have two drop down cells in column C and D.

 whenever i select an option in the dropdown in cell C1, the list in D1
 should show only the sub-tasks that belong to the respective primary
 task.

 eg: in the attached spreadsheet, if i select Admin / Reporting in
 the list, in the other cell only the following sub-tasks should
 reflect:

 follow-up and reminder mails for Onhold/Offline/PCR records
 Metrics reports (for SKAs and above)
 Workplan preparation (for SKAs and above)
 Logistics for training (for Training SKA)
 Updating time entry reports
 Updating project tracker (for SKAs and above)
 Monitoring Service Desk (for SKAs and above)
 query resolution time b/w QA and KA
 query resolution time b/w KA and SKA
 Monitoring quals mailbox
 Updating KL tracker (for docs KL team)

 i hope this request is clear.

 let me know if you have any questions.

 your help is much appreciated.

 sharath

 --

 --
 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-macros@googlegroups.com

 
 Like our page on facebook , Just follow below link
 http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts




 --
 Thanks  Regards,

 DILIP KUMAR PANDEY
   MBA-HR,B.Com(Hons),BCA
 Mobile: +91 9810929744
 dilipan...@gmail.com
 dilipan...@yahoo.com
 New Delhi - 62, India


-- 
Sent from my mobile device

Thanks  Regards,

DILIP KUMAR PANDEY
  MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India

-- 
--
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-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Need help on excel sheet

2010-12-01 Thread Frank Linden

Hello Again,
   I would like to know more about the data on the 5 tabs.
Will the data always occupy the same address(es)?
Or, will the data location be changing?
Can you describe an example or send a sample? 
Thanks
--- On Wed, 12/1/10, Manjunath C cmanjunathchen...@gmail.com wrote:


From: Manjunath C cmanjunathchen...@gmail.com
Subject: Re: $$Excel-Macros$$ Need help on excel sheet
To: excel-macros@googlegroups.com
Date: Wednesday, December 1, 2010, 12:15 AM



No,
 I have different data (place wise) in 5 tabs, my expectation is that wile 
pasting the raw data in the first sheet , it should divide the data as per the 
region or place wise in the remaining sheet and that needs to be seperated in 
different individual sheet in my desktop or in a different file.
 
Thanks
Manjunath


On Tue, Nov 30, 2010 at 4:40 PM, Frank Linden frankjlin...@yahoo.com wrote:






Hello,
  Do you mean that you want to collect the data on all 5 sheets and add it to a 
6th sheet and then save the workbook with all 6 sheets?
Or do you need to take the data from the 5 sheets and put it on one sheet, then 
saving a new workbook with only one sheet?
 
 
 
--- On Tue, 11/30/10, Manjunath C cmanjunathchen...@gmail.com wrote:


From: Manjunath C cmanjunathchen...@gmail.com
Subject: $$Excel-Macros$$ Need help on excel sheet
To: excel-macros@googlegroups.com
Date: Tuesday, November 30, 2010, 4:12 AM 






Hi All,
 
Can anyone help me, I have data in 5 tabs, now i need to make it in seperate 
excel sheet and paste it local desktop.
 
Any macros available - appreciate your help in advance.
 
Thanks
Manjunath
-- 
--
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-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts





-- 
--
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-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts


-- 
--
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-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts



  

-- 
--
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-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ Need help on excel sheet

2010-11-30 Thread Frank Linden

Hello,
  Do you mean that you want to collect the data on all 5 sheets and add it to a 
6th sheet and then save the workbook with all 6 sheets?
Or do you need to take the data from the 5 sheets and put it on one sheet, then 
saving a new workbook with only one sheet?
 
 
 
--- On Tue, 11/30/10, Manjunath C cmanjunathchen...@gmail.com wrote:


From: Manjunath C cmanjunathchen...@gmail.com
Subject: $$Excel-Macros$$ Need help on excel sheet
To: excel-macros@googlegroups.com
Date: Tuesday, November 30, 2010, 4:12 AM



Hi All,
 
Can anyone help me, I have data in 5 tabs, now i need to make it in seperate 
excel sheet and paste it local desktop.
 
Any macros available - appreciate your help in advance.
 
Thanks
Manjunath
-- 
--
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-macros@googlegroups.com
 

Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts



  

-- 
--
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-macros@googlegroups.com


Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wallref=ts

Re: $$Excel-Macros$$ need help in excel

2009-12-14 Thread vinod rao

Thank you for all of my excel experts.

On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:

 Hi Friends,

 I have 2 excel file having 12 sheets in it, what I want is to merge two
 file into one. I tried using move or copy but it din't work. Is there any
 method. Please not that i have formula in both file

 --
 Regards,
 Shilpa

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ need help in excel

2009-12-14 Thread vinod rao

This info helped me too.

On Tue, Dec 15, 2009 at 1:24 PM, vinod rao vinod.ma...@gmail.com wrote:

 Thank you for all of my excel experts.

  On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:

 Hi Friends,

 I have 2 excel file having 12 sheets in it, what I want is to merge two
 file into one. I tried using move or copy but it din't work. Is there any
 method. Please not that i have formula in both file

 --
 Regards,
 Shilpa

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes
 about the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ need help in excel

2009-12-02 Thread amresh kumar

Hi Shilpa,
please send me file

Regards
Amresh

On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:

 Hi Friends,

 I have 2 excel file having 12 sheets in it, what I want is to merge two
 file into one. I tried using move or copy but it din't work. Is there any
 method. Please not that i have formula in both file

 --
 Regards,
 Shilpa

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ need help in excel

2009-12-02 Thread Mahesh

Hi Shilpa,

Open both the files(Ex:- A  B) and the select all the sheet u want move
from B to A.
Then right click on the tab and select move, w will see a new pop- up select
Sheet A and press ok.



On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:

 Hi Friends,

 I have 2 excel file having 12 sheets in it, what I want is to merge two
 file into one. I tried using move or copy but it din't work. Is there any
 method. Please not that i have formula in both file

 --
 Regards,
 Shilpa

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




-- 
With Love,
Mahesh Bisht

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

RE: $$Excel-Macros$$ need help in excel

2009-12-02 Thread Amitabh Bose



Hi Shilpa,

 

Just to add to Mahesh's email .. this will work if you open both Excel 
workbooks in the same Excel 'window'.

 

Thanks,

 

Amitabh
 


Date: Wed, 2 Dec 2009 17:00:52 +0530
Subject: Re: $$Excel-Macros$$ need help in excel
From: mahender.bi...@gmail.com
To: excel-macros@googlegroups.com


Hi Shilpa,
 
Open both the files(Ex:- A  B) and the select all the sheet u want move from B 
to A.
Then right click on the tab and select move, w will see a new pop- up select 
Sheet A and press ok.


 
On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:


Hi Friends,
 
I have 2 excel file having 12 sheets in it, what I want is to merge two file 
into one. I tried using move or copy but it din't work. Is there any method. 
Please not that i have formula in both file
-- 
Regards,
Shilpa


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!
 
We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

-- 
With Love,
Mahesh Bisht


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com

 
To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!
 
We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe   
   
_
View your other email accounts from your Hotmail inbox. Add them now.
http://clk.atdmt.com/UKM/go/186394592/direct/01/

-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email to:
Ayush Jain  @ jainayus...@gmail.com or
Ashish Jain @ 26may.1...@gmail.com

HELP US GROW !!

We reach over 6,500 subscribers worldwide and receive many nice notes about the 
learning and support from the group. Our goal is to have 10,000 subscribers by 
the end of 2009. Let friends and co-workers know they can subscribe to group at 
http://groups.google.com/group/excel-macros/subscribe

Re: $$Excel-Macros$$ need help in excel

2009-12-02 Thread Hemant Hegde

Hi Shilpa

If you tried to copy/move all the sheets to another workbook and it didn't
work, it might be because either of the workbook is protected.

Go to ToolsProtectionUnprotect Workbook and try to copy again.

Another reason I can think of could be that either of the workbooks is
opened in a separate instance of Excel! In this case when you try to copy
sheets, you wont see the name of the destination workbook in the menu!

In that case use CTRL+O rather that doubleclicking on the file icon to open
those workbooks..

:)

Good luck
Hemant Hegde


2009/12/2 Amitabh Bose amitabhbo...@hotmail.com


 Hi Shilpa,

 Just to add to Mahesh's email .. this will work if you open both Excel
 workbooks in the same Excel 'window'.

 Thanks,

 Amitabh

 --
 Date: Wed, 2 Dec 2009 17:00:52 +0530
 Subject: Re: $$Excel-Macros$$ need help in excel
 From: mahender.bi...@gmail.com
 To: excel-macros@googlegroups.com


 Hi Shilpa,

 Open both the files(Ex:- A  B) and the select all the sheet u want move
 from B to A.
 Then right click on the tab and select move, w will see a new pop- up
 select Sheet A and press ok.



 On Wed, Dec 2, 2009 at 1:50 PM, Shilpa Rao shilpa...@gmail.com wrote:

 Hi Friends,

 I have 2 excel file having 12 sheets in it, what I want is to merge two
 file into one. I tried using move or copy but it din't work. Is there any
 method. Please not that i have formula in both file

 --
 Regards,
 Shilpa

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe




 --
 With Love,
 Mahesh Bisht

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe
 --
 View your other email accounts from your Hotmail inbox. Add them 
 now.http://clk.atdmt.com/UKM/go/186394592/direct/01/

 --

 --
 Some important links for excel users:
 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at
 http://www.excelitems.com
 2. Excel tutorials at http://www.excel-macros.blogspot.com
 3. Learn VBA Macros at http://www.vbamacros.blogspot.com
 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com


 To post to this group, send email to excel-macros@googlegroups.com
 If you find any spam message in the group, please send an email to:
 Ayush Jain @ jainayus...@gmail.com or
 Ashish Jain @ 26may.1...@gmail.com
 
 HELP US GROW !!

 We reach over 6,500 subscribers worldwide and receive many nice notes about
 the learning and support from the group. Our goal is to have 10,000
 subscribers by the end of 2009. Let friends and co-workers know they can
 subscribe to group at
 http://groups.google.com/group/excel-macros/subscribe


-- 
--
Some important links for excel users:
1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at 
http://www.excelitems.com
2. Excel tutorials at http://www.excel-macros.blogspot.com
3. Learn VBA Macros at http://www.vbamacros.blogspot.com
4. Excel Tips and Tricks at http://exceldailytip.blogspot.com
 

To post to this group, send email to excel-macros@googlegroups.com
If you find any spam message in the group, please send an email

Re: $$Excel-Macros$$ Need help on Excel

Re: $$Excel-Macros$$ Need help on Excel

Re: $$Excel-Macros$$ Need help on Excel

Re: $$Excel-Macros$$ Need help for Excel - sort expiry date in a seperate sheet

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

RE: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Re: $$Excel-Macros$$ Need help in Excel-VBA code to write function in coding

Re: $$Excel-Macros$$ need help in excel - data merge acorrs columns

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Re: $$Excel-Macros$$ Need help on Excel Dynamic List

Re: $$Excel-Macros$$ Need help on excel sheet

Re: $$Excel-Macros$$ Need help on excel sheet

Re: $$Excel-Macros$$ need help in excel

Re: $$Excel-Macros$$ need help in excel

Re: $$Excel-Macros$$ need help in excel

Re: $$Excel-Macros$$ need help in excel

RE: $$Excel-Macros$$ need help in excel

Re: $$Excel-Macros$$ need help in excel

21 matches

Site Navigation

Mail list logo

Footer information