$$Excel-Macros$$ VBA Code need

2015-11-12 Thread Renukachari Kasee
*Dear All,*

*Pls help...*
*need vba code for specified format...*


*Thanks & RegardsRenukaChari. Kasee*

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

FORUM RULES

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

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


Query.xlsx
Description: MS-Excel 2007 spreadsheet


$$Excel-Macros$$ Serial Number macro problem

2014-10-14 Thread Renukachari Kasee
Dear Group,

Please provide the macro for serial Number as per attached sheet

Thankss

*♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*

*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

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

FORUM RULES

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

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


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


$$Excel-Macros$$ please provide the excel vba code for creating ms access table headers table

2014-09-25 Thread Renukachari Kasee
Dear experts,

please provide the excel vba code macro for creating ms access table
headers table









*(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!`•.¸.•´Thanks &
Regards´¨)  ¸ •´ ¸.•*´¨)   ¸.•*¨) (¸.•´  (¸.•*
♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*

*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

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

FORUM RULES

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

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


$$Excel-Macros$$ Problem for copy and paste range in one sheet to other sheet

2014-07-17 Thread Renukachari Kasee
Dear Experts please help me in this regard.

my macro was not working properly

please help me...its urgent







*(¨`•.•´¨) Always`•.¸(¨`•.•´¨) Keep(¨`•.•´¨)¸.•´ Smiling!!`•.¸.•´Thanks &
Regards´¨)  ¸ •´ ¸.•*´¨)   ¸.•*¨) (¸.•´  (¸.•*
♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*

*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

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

FORUM RULES

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

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


Copy and Past down by down.xlsm
Description: application/vnd.ms-excel.sheet.macroenabled.12


$$Excel-Macros$$ alphanumeric sheet names sort ascending or descending

2014-07-02 Thread Renukachari Kasee
*dear group,*

*please provide the vba macro for sheet names having alphanumerics  then it
wont sort asc or dsc*


*suppose for example one workbook having 23 worksheets *

*sheet1 **sheet2 **sheet3 **sheet4 **sheet5 **sheet6 **sheet7 **sheet8 *
*sheet9 **sheet10 **sheet111 **sheet12 **sheet13 **sheet14 **sheet15 *
*sheet16 **sheet17 **sheet18 **sheet19 **sheet20 **sheet21 **sheet22 *
*sheet23*

*in this criteria below macro wasnt work please provide the solution for
alphanumeric sheets sorting.*










*Sub sortworksheetsnew()Dim N  As Integer Dim M  As
IntegerDim FirstWSToSort As IntegerDim LastWSToSort As Integer
Dim SortDescending As Boolean SortDescending = FalseFirstWSToSort =
1LastWSToSort =
ActiveWorkbook.Worksheets.CountApplication.ScreenUpdating = False
InitialSheet = ActiveSheet.NameFor M = FirstWSToSort To LastWSToSort
For N = M To LastWSToSortIf SortDescending = True Then
If UCase(Worksheets(N).Name) > _
 UCase(Worksheets(M).Name) ThenWorksheets(N).Move
Before:=Worksheets(M) End IfElse
If UCase(Worksheets(N).Name) < _
 UCase(Worksheets(M).Name) Then
ActiveWorkbook.Worksheets(N).Move Before:=ActiveWorkbook.Worksheets(M)
End IfEnd IfNext NNext
MApplication.ScreenUpdating = True Sheets(InitialSheet).SelectEnd Sub*






*Thanks & Regards´¨)  ¸ •´ ¸.•*´¨)   ¸.•*¨) (¸.•´  (¸.•*
♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*

*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

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

FORUM RULES

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

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


$$Excel-Macros$$ ODS TO EXCEL CONVERSION PROBLEM

2014-05-14 Thread Renukachari Kasee
Dear experts please suggest

how to convert bunch of openoffice clac ods formats in a folder i want
to convert
ods to xlsx format

here i am sharing one the web resource, while execute the code it will
shows error message.

please solve this query...



Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable energy sources.

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

FORUM RULES

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

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

Dim StrFilename As String
Dim StrDocName As String
Dim StrPath As String
Dim oWorkbook As Workbook
Dim fDialog As FileDialog
Dim intPos As Integer
MsgBox "Please select the folder which contains the files for convert", , ""
Set fDialog = Application.FileGialog(msoFileDialogFolderPicker)
With fDialog
.Title = "Select folder and click OK"
.AllowMultiSelect = False
.InitialView = msoFileDialogViewList
If .Show <> -1 Then
MsgBox "Cancelled By User", , "List Folder Contents"
Exit Sub
End If
StrPath = fDialog.SelectedItems.Item(1)
If Right (StrPath, 1) <> "\" Then StrPath = StrPath + "\"
End With
If Left (StrPath, 1) = Chr(34) Then
StrPath = Mid (StrPath, 2, Len(StrPath) - 2)
End If
StrFilename = Dir$(StrPath & "*.ods")
While Len(StrFilename <> 0)
Set oWorkbook = Workbooks.Open(StrPath & StrFilename)
StrDocname = ActiveWorkbook.Fullname
intPos = InStrRev(StrDocName, ".")
StrFocName = Left(StrDocName, intPos - 1)
StrDocName = StrDocName & ".xlsx"
oWorkbook.SaveAs Filename:=StrDocName, FileFormat:=51
oWorkbook.Close savechanges:=wdDoNotSaveChanges
StrFilename = Dir$()
Wend
MsgBox "Conversion is completed", , "ODS to XLSX"
Exit Sub
End Sub

$$Excel-Macros$$ E book related..

2014-05-12 Thread Renukachari Kasee
Dear Group,


any one please provide the ebook for excel macros

i.e.  101 READY-TO-USE EXCEL MACROS by Michael Alexander , John Walkenbach


(Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable energy sources.

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

FORUM RULES

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

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


$$Excel-Macros$$ please help me on index match or offset function to calculate top 5 consolidated locations and amounts

2014-04-28 Thread Renukachari Kasee
Dear experts,

please help me


Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪

P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and
use renewable energy sources.

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

FORUM RULES

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

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


Problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ VBA Macro for data split as per the specified format

2014-03-21 Thread Renukachari Kasee
Dear experts,

please provide the vba macro for attached excel sheet format split
into separate sheets those formats are mentioned in the excel

kindly do the needful

thanks alot.

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

FORUM RULES

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

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


Example1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Listbox data adding problem

2013-12-29 Thread Renukachari Kasee
Dear Experts,

Please provide the solution for the attached worksheet.

problem was written in the excel please go through that.

thanks

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

FORUM RULES

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

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


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


$$Excel-Macros$$ Re: Need macro export data into workbooks with grand Totals and specified format

2013-10-08 Thread Renukachari Kasee
Hi ravinder negi,

Thanks for given this macro but it was not working in my end

i was entered multiple times range criteria but i was not work it shows
error debug message

please help me out.

thanking you.

*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*


On 7 October 2013 19:46, Renukachari Kasee  wrote:

> Hi ravinder negi,
> Thanks for giving this macro i am expecting exactly Like this only,
>
> but if change the range it would not work please check this once actually
> i was given only
> sample copy only but data range would be nearly 20k to 30k.
>
> what i want is exactly you are prepared format only but range would be
> different. this range
> would not same in every day.
>
> Please help me out in this regard...
>
> Thanks
>
>
> *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
> * *
> *P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and use
> renewable energy sources.*
>
>
> On 6 October 2013 18:50, Renukachari Kasee  wrote:
>
>> Dear Group,
>>
>> Please Give me the required format macro for data exporter.
>>
>> please find the attachments
>>
>> required format is Export data with Specified range and grand totals as
>> well
>>
>> Thanks
>>
>> *(¨`•.•´¨) Always
>> `•.¸(¨`•.•´¨) Keep
>> (¨`•.•´¨)¸.•´ Smiling!!
>> `•.¸.•´
>> Thanks & Regards´¨)
>>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
>> * *
>> *P Let us do our best to save nature, save water, plant trees, protect
>> greenery, keep our surroundings clean, reduce usage of plastics, and use
>> renewable energy sources.*
>>
>
>

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

FORUM RULES

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

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


$$Excel-Macros$$ Re: Multi sheets Grouping Problem

2013-10-08 Thread Renukachari Kasee
Hi De Premor,

Thanks alot for your help.

thank you so much.



*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*


On 6 October 2013 18:11, Renukachari Kasee  wrote:

> Dear Group
>
> Please help me this problem for multi sheets select with in the single
> click
> As per the requirement
>
> Thank
>
>  *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
> * *
> *P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and use
> renewable energy sources.*
>

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

FORUM RULES

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

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


Re: $$Excel-Macros$$ macro for required data please find the attachment once

2013-09-20 Thread Renukachari Kasee
Hi अनिल नारायण गवली,

can you please tell me how to use your file


thanks



*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*


On 17 September 2013 10:10, अनिल नारायण गवली wrote:

>  Dear Renukarchari,
>
> Pl see the attached sheet.
>
> Warm Regards,
> Gawli Anil
> Thanks & Regards,
> Gawli Anil Narayan
> Software Developer,
> Abacus Software Services Pvt Ltd
>
>
> On Tue, Sep 17, 2013 at 1:46 AM, Renukachari Kasee 
> wrote:
> > Dear experts.
> >
> >
> > please solve my query its very very urgent
> >
> > macro for required data please find the attachment once
> >
> >
> > thanks
> >
> > (¨`•.•´¨) Always
> > `•.¸(¨`•.•´¨) Keep
> > (¨`•.•´¨)¸.•´ Smiling!!
> > `•.¸.•´
> > Thanks & Regards´¨)
> >   ¸ •´ ¸.•*´¨)   ¸.•*¨)
> >  (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪
> >
> > P Let us do our best to save nature, save water, plant trees, protect
> > greenery, keep our surroundings clean, reduce usage of plastics, and use
> > renewable energy sources.
> >
> > --
> > Are you =EXP(E:RT) or =NOT(EXP(E:RT)) in Excel? And do you wanna be? It’s
> > =TIME(2,DO:IT,N:OW) ! Join official Facebook page of this forum @
> > https://www.facebook.com/discussexcel
> >
> > FORUM RULES
> >
> > 1) Use concise, accurate thread titles. Poor thread titles, like Please
> > Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice
> will
> > not get quick attention or may not be answered.
> > 2) Don't post a question in the thread of another member.
> > 3) Don't post questions regarding breaking or bypassing any security
> > measure.
> > 4) Acknowledge the responses you receive, good or bad.
> > 5) Jobs posting is not allowed.
> > 6) Sharing copyrighted material and their links is not allowed.
> >
> > NOTE : Don't ever post confidential data in a workbook. Forum owners and
> > members are not responsible for any loss.
> > ---
> > You received this message because you are subscribed to the Google Groups
> > "MS EXCEL AND VBA MACROS" group.
> > To unsubscribe from this group and stop receiving emails from it, send an
> > email to excel-macros+unsubscr...@googlegroups.com.
> > To post to this group, send email to excel-macros@googlegroups.com.
> > Visit this group at http://groups.google.com/group/excel-macros.
> > For more options, visit https://groups.google.com/groups/opt_out.
>

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

FORUM RULES

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

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


$$Excel-Macros$$ macro for required data please find the attachment once

2013-09-16 Thread Renukachari Kasee
Dear experts.


please solve my query its very very urgent

macro for required data please find the attachment once


thanks

*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

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

FORUM RULES

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

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


Sample.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Offset tutorial required

2012-11-25 Thread Renukachari Kasee
Offset tutorial required
*Dear Experts!!*
*can you share any one different criteria's used in offset function and
sumproduct function in excel... *
*
*
*thanks*
*
*

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




$$Excel-Macros$$ dear experts is there any solution for pick the step value in certain table

2012-11-19 Thread Renukachari Kasee
Dear experts,
is there any solution for pick the step value in certain table?

please see above attached workbook
here i need formula for pick the value

thanks

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




All1.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF & .htm

2012-05-17 Thread Renukachari Kasee
Dear experts

Excel macro for sendin outlook emails from Specific Templet With
Attachments formats  of .PDF & .htm

Thanks in Advance

-- 
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


$$Excel-Macros$$ Forgot my workbook encrypted password

2012-02-21 Thread Renukachari Kasee
Hi Experts


I forgot my workbook encrypted password can you help me how to remove or
view that data, In that i don't Put a read only check mark also


help me plzzz  as soon as possible

-- 
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


$$Excel-Macros$$ need help for hyperlink execution without using mouse PFA

2012-02-14 Thread Renukachari Kasee
Hi
All experts

good evening

here one sheet is having hyperlinks click on that link(with the help of
mouse) outlook new mail window will be open,


but i am expecting without using mouse.



*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

-- 
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


Example.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


$$Excel-Macros$$ Re: hi can you solve this

2011-12-09 Thread Renukachari Kasee
hi thanks for you valuble replay

but i need like this can you see this attachment



On 8 December 2011 18:56, Renukachari Kasee  wrote:

>
> *(¨`•.•´¨) Always
> `•.¸(¨`•.•´¨) Keep
> (¨`•.•´¨)¸.•´ Smiling!!
> `•.¸.•´
> Thanks & Regards´¨)
>   ¸ •´ ¸.•*´¨)   ¸.•*¨)
>  (¸.•´  (¸.•*      ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
> * *
> *P Let us do our best to save nature, save water, plant trees, protect
> greenery, keep our surroundings clean, reduce usage of plastics, and use
> renewable energy sources.*
>

-- 
FORUM RULES (934+ 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


Solved+By+Maries+08.12.2011(1).xls
Description: MS-Excel spreadsheet


$$Excel-Macros$$ hi can you solve this

2011-12-08 Thread Renukachari Kasee
*(¨`•.•´¨) Always
`•.¸(¨`•.•´¨) Keep
(¨`•.•´¨)¸.•´ Smiling!!
`•.¸.•´
Thanks & Regards´¨)
  ¸ •´ ¸.•*´¨)   ¸.•*¨)
 (¸.•´  (¸.•*  ♥♥♥...♪♪♪RenukaChari. Kasee...♥♥♥...♪♪♪*
* *
*P Let us do our best to save nature, save water, plant trees, protect
greenery, keep our surroundings clean, reduce usage of plastics, and use
renewable energy sources.*

-- 
FORUM RULES (934+ 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


Problem.xlsx
Description: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet