date:20110901

Re: $$Excel-Macros$$ VBA code to copy and save as new book

2011-09-01 Thread Prabhu

Hi Mahesh,

Grete It is working.But i am getting runtime error"53" (File not found 
message) and debug report is highlighting the below code.

Kill sPath & sFname & ".xls"

Note: It is creating file also on the given path.

Regards,

Prabhu

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

Re: $$Excel-Macros$$ VBA code to copy and save as new book

2011-09-01 Thread Mahesh parab

Hi Prabhu

Try

Sub Mtest()
Dim sPath As String, sFname As String, fname As String
Dim OutApp As Object, OutMail As Object
fname = ThisWorkbook.Name
sPath = ThisWorkbook.Path & "\"
sFname = "Statement as on " & Format(Date, "mm-dd-") & ".xls"
With ThisWorkbook
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Select
Sheets(Array(ActiveSheet.Name, ActiveSheet.Previous.Name)).Copy
End With
ActiveWorkbook.SaveAs (sPath & sFname)
Application.DisplayAlerts = False
With ActiveWorkbook
Set OutApp = CreateObject("Outlook.Application")
OutApp.Session.Logon
Set OutMail = OutApp.CreateItem(0)
On Error Resume Next
With OutMail
.TO = "a...@gmail.com"
.CC = ""
.BCC = ""
.Subject = fname
.Body = "Test Email"
.Attachments.Add ActiveWorkbook.FullName
.Display
'.send
End With
On Error GoTo 0
Set OutMail = Nothing
Set OutApp = Nothing
ActiveWorkbook.Close True
End With
kill sPath & sFname & ".xls"
End Sub

Thanks
Mahesh

On Thu, Sep 1, 2011 at 11:40 PM, NOORAIN ANSARI wrote:

> Dear Prabhu,
>
> See attached sheet if it help..
>
> On Thu, Sep 1, 2011 at 10:26 PM, Prabhu  wrote:
>
>> Hi Mahesh,
>>
>> Thanks it is working now.. Can you help me , if the same file needs to be
>> an attachment in a new outlook mail with the subject name has to be the
>>  file name, instead of saving in particular location.
>>
>> Regards,
>>
>> Prabhu.
>>
>>
>>
>>
>>
>>
>> --
>>
>> --
>> 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
>>
>
>
>
> --
> Thanks & regards,
> Noorain Ansari
> *http://noorain-ansari.blogspot.com/*
>
>  --
>
> --
> 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
>

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

Re: $$Excel-Macros$$ xls to Pdf in VBA error

2011-09-01 Thread Prabhu

Hi Noor,

It is working.. If i needs to create PDF only for  active sheet then  how to 
change the above VBA code.

Plz help

regards,

Prabhu

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

Re: $$Excel-Macros$$ VBA code to copy and save as new book

2011-09-01 Thread Prabhu

Hi Mahesh,

Thanks it is working now.. Can you help me , if the same file needs to be an 
attachment in a new outlook mail with the subject name has to be the  file 
name, instead of saving in particular location.

Regards,

Prabhu.



 


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

Re: $$Excel-Macros$$ Pivot Table Doubt

2011-09-01 Thread Prabhu

Hi Friends,

I think topic got changed. Actually i have attached a pivot file, when is 
double click the numbers a new sheet is appearing.
But in that sheet all numbers are shows in date format!!!. Plz help to know 
the reason and how i can get Numbers in numbers format and date in date 
format??

Plz help..

Regards,

Prabhu

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


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

$$Excel-Macros$$ Re: Freeze panes in an Excelsheet Control on a userform

2011-09-01 Thread GoldenLance

Try this

http://www.excelfox.com/forum/showthread.php?125-FreezePane-In-A-Userform-SpreadSheet-Control-11.0

Regards,
Sam Mathai Chacko

On Sep 1, 2:29 pm, John Holland  wrote:
> Would there be possibility to  freeze panes in an Excelsheet Control
> on a userform? I can find certain VBA-code to manipulate properties of
> this Control, but  not the Freeze  Panes method.
> Thanks for any suggestions,
> JH

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

Re: $$Excel-Macros$$ extracting data from a datasheet

2011-09-01 Thread Venkat CV

Hi

Please attach sample data

*Best Regards,*
*Venkat *
*Chennai*
*My Linked in profile *
*
*

On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar wrote:

> I made an userform with Empno, Name, Design, DOB textboxes with the
> save command. I am able to save the data. Now, I need code for
> updating the already contained data in a datasheet.
>
> How to retrieve data from datasheet basing the Empno and update
> (command button).  Pls provide code.
>
> --
>
> --
> 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
>



-- 
*
*
*
*

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

Re: $$Excel-Macros$$ extracting data from a datasheet

2011-09-01 Thread ashish koul

Can you attach the sample file

On Thu, Sep 1, 2011 at 4:16 PM, Bheema Shankar wrote:

> I made an userform with Empno, Name, Design, DOB textboxes with the
> save command. I am able to save the data. Now, I need code for
> updating the already contained data in a datasheet.
>
> How to retrieve data from datasheet basing the Empno and update
> (command button).  Pls provide code.
>
> --
>
> --
> 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
>



-- 
*Regards*
* *
*Ashish Koul*
*akoul*.*blogspot*.com 
http://akoul.posterous.com/
*akoul*.wordpress.com 
My Linkedin Profile 


P Before printing, think about the environment.

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

Re: $$Excel-Macros$$ Pivot Table Doubt

2011-09-01 Thread Shaik Waheed

Hi,
Write the correct problem in subject section, like "pivot, conditional
formatting, lookup function,". and then elaborate the problem as
clearly as u can, and also if possible attach the sample sheet.

Regards,
Waheed.

On Thu, Sep 1, 2011 at 7:26 PM, Shankar Bheema  wrote:
> Sir,
> I totally confused to put my query in group ID. pls tell me the procedure
>
> On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed  wrote:
>>
>> Plz put all ur queries n replies to the group id. So that everyone
>> will try n learn, that is wht our objective.
>>
>> Thnx
>> Waheed.
>>
>> On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales
>>  wrote:
>> > Thank you very much!
>> >
>> > Hope we could get in touch soon for future problems on Excel. Thank you!
>> >
>> > On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed 
>> > wrote:
>> >>
>> >> Hi John,
>> >>
>> >> PFA, i have deleted some rows bcoz the file size was getting huge.
>> >>
>> >> What u need to do is take this as example and do it in ur original
>> >> file, in sheet 2 u need to drag down the formulas till the end.
>> >>
>> >> Hope it hels u
>> >>
>> >> Regards,
>> >> Waheed
>> >>
>> >> On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales
>> >>  wrote:
>> >> > I attach my raw file.
>> >> >
>> >> > GEOCODE contains the geographic code
>> >> > Other sheets contain the geographical areas without the codes
>> >> >
>> >> > On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed 
>> >> > wrote:
>> >> >>
>> >> >> Can u plz mail a sample file.
>> >> >>
>> >> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
>> >> >>  wrote:
>> >> >> > If two geographical data match in two sheets, then
>> >> >> > add/copy/replicate
>> >> >> > unique
>> >> >> > id/code
>> >> >> >
>> >> >> > Hi guys, this is my problem.
>> >> >> >
>> >> >> > I have a geographical data (divided into four colums per REGION,
>> >> >> > PROVINCE,
>> >> >> > MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet
>> >> >> > contains a
>> >> >> > UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE.
>> >> >> >
>> >> >> > Now, I have also another sheet which lists the same geographical
>> >> >> > data
>> >> >> > (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN,
>> >> >> > and
>> >> >> > BARANGAY/STREET). The geographic areas included in this sheet are
>> >> >> > recipients
>> >> >> > of one government program. But this sheet does not contain the
>> >> >> > UNIQUE
>> >> >> > GEOGRAPHICAL CODE.
>> >> >> >
>> >> >> > What I would like to do is to match the geographical data found in
>> >> >> > two
>> >> >> > sheets, and if they match, copy/replicate/add the UNIQUE
>> >> >> > GEOGRAPHICAL
>> >> >> > CODE
>> >> >> > found in sheet to the other sheet that does not contain the code.
>> >> >> >
>> >> >> > I would like to include the geographical code, so that it would
>> >> >> > become
>> >> >> > the
>> >> >> > primary key when I create a database in MS Access.
>> >> >> >
>> >> >> > This is the example
>> >> >> >
>> >> >> > SHEET 1
>> >> >> > A B C D E
>> >> >> > 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
>> >> >> >
>> >> >> > *Column A contains the UNIQUE GEOGRAPHICAL CODE
>> >> >> >
>> >> >> > SHEET 2
>> >> >> > A B C D
>> >> >> > REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
>> >> >> >
>> >> >> > *Sheet 2 contains only 20k entries of geographical areas while
>> >> >> > Sheet
>> >> >> > 1
>> >> >> > contains about 40k entries. Only half of the geographical areas
>> >> >> > are
>> >> >> > included
>> >> >> > in the government program
>> >> >> >
>> >> >> > Can you help me?
>> >> >> >
>> >> >> >
>> >> >> > On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed
>> >> >> > 
>> >> >> > wrote:
>> >> >> >>
>> >> >> >> Hi,
>> >> >> >>
>> >> >> >> Right Click on the pivot table, select Pivot Tabel Options, move
>> >> >> >> to
>> >> >> >> 'Data' tab and then Uncheck- "Enable Show Details".
>> >> >> >> For the date format i think its working fine in both rows n
>> >> >> >> columns.
>> >> >> >>
>> >> >> >> Regards,
>> >> >> >> Waheed.
>> >> >> >>
>> >> >> >> On Thu, Sep 1, 2011 at 7:55 AM, Prabhu 
>> >> >> >> wrote:
>> >> >> >> > HI All,
>> >> >> >> > Plz find the pivot table sheet.
>> >> >> >> > kindly help.
>> >> >> >> > Regards,
>> >> >> >> > Prabhu
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> > --
>> >> >> >> > 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-m

Re: $$Excel-Macros$$ Pivot Table Doubt

2011-09-01 Thread Shankar Bheema

Sir,

I totally confused to put my query in group ID. pls tell me the procedure

On Thu, Sep 1, 2011 at 5:58 PM, Shaik Waheed  wrote:

> Plz put all ur queries n replies to the group id. So that everyone
> will try n learn, that is wht our objective.
>
> Thnx
> Waheed.
>
> On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales
>  wrote:
> > Thank you very much!
> >
> > Hope we could get in touch soon for future problems on Excel. Thank you!
> >
> > On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed 
> wrote:
> >>
> >> Hi John,
> >>
> >> PFA, i have deleted some rows bcoz the file size was getting huge.
> >>
> >> What u need to do is take this as example and do it in ur original
> >> file, in sheet 2 u need to drag down the formulas till the end.
> >>
> >> Hope it hels u
> >>
> >> Regards,
> >> Waheed
> >>
> >> On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales
> >>  wrote:
> >> > I attach my raw file.
> >> >
> >> > GEOCODE contains the geographic code
> >> > Other sheets contain the geographical areas without the codes
> >> >
> >> > On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed 
> >> > wrote:
> >> >>
> >> >> Can u plz mail a sample file.
> >> >>
> >> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
> >> >>  wrote:
> >> >> > If two geographical data match in two sheets, then
> add/copy/replicate
> >> >> > unique
> >> >> > id/code
> >> >> >
> >> >> > Hi guys, this is my problem.
> >> >> >
> >> >> > I have a geographical data (divided into four colums per REGION,
> >> >> > PROVINCE,
> >> >> > MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet
> >> >> > contains a
> >> >> > UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE.
> >> >> >
> >> >> > Now, I have also another sheet which lists the same geographical
> data
> >> >> > (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN,
> >> >> > and
> >> >> > BARANGAY/STREET). The geographic areas included in this sheet are
> >> >> > recipients
> >> >> > of one government program. But this sheet does not contain the
> UNIQUE
> >> >> > GEOGRAPHICAL CODE.
> >> >> >
> >> >> > What I would like to do is to match the geographical data found in
> >> >> > two
> >> >> > sheets, and if they match, copy/replicate/add the UNIQUE
> GEOGRAPHICAL
> >> >> > CODE
> >> >> > found in sheet to the other sheet that does not contain the code.
> >> >> >
> >> >> > I would like to include the geographical code, so that it would
> >> >> > become
> >> >> > the
> >> >> > primary key when I create a database in MS Access.
> >> >> >
> >> >> > This is the example
> >> >> >
> >> >> > SHEET 1
> >> >> > A B C D E
> >> >> > 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
> >> >> >
> >> >> > *Column A contains the UNIQUE GEOGRAPHICAL CODE
> >> >> >
> >> >> > SHEET 2
> >> >> > A B C D
> >> >> > REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
> >> >> >
> >> >> > *Sheet 2 contains only 20k entries of geographical areas while
> Sheet
> >> >> > 1
> >> >> > contains about 40k entries. Only half of the geographical areas are
> >> >> > included
> >> >> > in the government program
> >> >> >
> >> >> > Can you help me?
> >> >> >
> >> >> >
> >> >> > On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed  >
> >> >> > wrote:
> >> >> >>
> >> >> >> Hi,
> >> >> >>
> >> >> >> Right Click on the pivot table, select Pivot Tabel Options, move
> to
> >> >> >> 'Data' tab and then Uncheck- "Enable Show Details".
> >> >> >> For the date format i think its working fine in both rows n
> columns.
> >> >> >>
> >> >> >> Regards,
> >> >> >> Waheed.
> >> >> >>
> >> >> >> On Thu, Sep 1, 2011 at 7:55 AM, Prabhu 
> >> >> >> wrote:
> >> >> >> > HI All,
> >> >> >> > Plz find the pivot table sheet.
> >> >> >> > kindly help.
> >> >> >> > Regards,
> >> >> >> > Prabhu
> >> >> >> >
> >> >> >> > --
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> --
> >> >> >> > 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
> >> >> >> >
> >> >> >>
> >> >> >> --
> >> >> >>
> >> >> >>
> >> >> >>
> >> >> >>
> --
> >> >> >> Some important links for excel users:
> >> >> >> 1. Follow us on TWITTER for tips tricks and links :
> >> >> >> http://twitter.com/exceldai

Re: $$Excel-Macros$$ Pivot Table Doubt

2011-09-01 Thread John Alliage Tinio Morales

*If two geographical data match in two sheets, then add/copy/replicate
unique id/code*

Hi guys, this is my problem.

I have a geographical data (divided into four colums per REGION, PROVINCE,
MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet contains a
UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE.

Now, I have also another sheet which lists the same geographical data
(divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN, and
BARANGAY/STREET). The geographic areas included in this sheet are recipients
of one government program. But this sheet does not contain the UNIQUE
GEOGRAPHICAL CODE.

What I would like to do is to match the geographical data found in two
sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL CODE
found in sheet to the other sheet that does not contain the code.

I would like to include the geographical code, so that it would become the
primary key when I create a database in MS Access.

This is the example

SHEET 1
A B C D E
0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET

*Column A contains the UNIQUE GEOGRAPHICAL CODE

SHEET 2
A B C D
REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET

*Sheet 2 contains only 20k entries of geographical areas while Sheet 1
contains about 40k entries. Only half of the geographical areas are included
in the government program

Can you help me?

On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed  wrote:

> Hi,
>
> Right Click on the pivot table, select Pivot Tabel Options, move to
> 'Data' tab and then Uncheck- "Enable Show Details".
> For the date format i think its working fine in both rows n columns.
>
> Regards,
> Waheed.
>
> On Thu, Sep 1, 2011 at 7:55 AM, Prabhu  wrote:
> > HI All,
> > Plz find the pivot table sheet.
> > kindly help.
> > Regards,
> > Prabhu
> >
> > --
> >
> --
> > 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
> >
>
> --
>
> --
> 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
>

-- 
*John Alliage Tinio Morales*
*Researcher**
GMA News and Public Affairs*
Mobile: 0915.846.8473
Tel: (02) 982. loc 1338
Fax: (02) 982. loc 1340

DISCLAIMER:
This Message may contain confidential information intended only for the use
of the addressee named above. If you are not the intended recipient of this
message you are hereby notified that any use, dissemination, distribution or
reproduction of this message is prohibited. If you received this message in
error please notify your Mail Administrator and delete this message
immediately. Any views expressed in this message are those of the individual
sender and may not necessarily reflect the views of GMA Network, Inc.

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

RE: $$Excel-Macros$$ Re: Need macro to split the files

2011-09-01 Thread Sudhir Kumar

Hi Dear 

How to reach your website.

Pls give addres..

thanx

-Original Message-
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Frederic LE GUEN - MVP Excel
Sent: Wednesday, August 31, 2011 1:58 AM
To: MS EXCEL AND VBA MACROS
Subject: Re: $$Excel-Macros$$ Re: Need macro to split the files



> I have also created thousands of functions, and PivotTables
Good :)
> you're asking or you're selling web site?
I'm am sharing ;)
As Excel MVP, I have to share my knowledge for free on the web.
So when a question is in relation with one of the page of my website,
I post the related page.

-- 

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

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

$$Excel-Macros$$ Freeze panes in an Excelsheet Control on a userform

2011-09-01 Thread John Holland

Would there be possibility to  freeze panes in an Excelsheet Control
on a userform? I can find certain VBA-code to manipulate properties of
this Control, but  not the Freeze  Panes method.
Thanks for any suggestions,
JH

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

$$Excel-Macros$$ extracting data from a datasheet

2011-09-01 Thread Bheema Shankar

I made an userform with Empno, Name, Design, DOB textboxes with the
save command. I am able to save the data. Now, I need code for
updating the already contained data in a datasheet.

How to retrieve data from datasheet basing the Empno and update
(command button).  Pls provide code.

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

Re: $$Excel-Macros$$ Pivot Table Doubt

2011-09-01 Thread Shaik Waheed

Plz put all ur queries n replies to the group id. So that everyone
will try n learn, that is wht our objective.

Thnx
Waheed.

On Thu, Sep 1, 2011 at 4:47 PM, John Alliage Tinio Morales
 wrote:
> Thank you very much!
>
> Hope we could get in touch soon for future problems on Excel. Thank you!
>
> On Thu, Sep 1, 2011 at 5:44 PM, Shaik Waheed  wrote:
>>
>> Hi John,
>>
>> PFA, i have deleted some rows bcoz the file size was getting huge.
>>
>> What u need to do is take this as example and do it in ur original
>> file, in sheet 2 u need to drag down the formulas till the end.
>>
>> Hope it hels u
>>
>> Regards,
>> Waheed
>>
>> On Thu, Sep 1, 2011 at 1:59 PM, John Alliage Tinio Morales
>>  wrote:
>> > I attach my raw file.
>> >
>> > GEOCODE contains the geographic code
>> > Other sheets contain the geographical areas without the codes
>> >
>> > On Thu, Sep 1, 2011 at 4:17 PM, Shaik Waheed 
>> > wrote:
>> >>
>> >> Can u plz mail a sample file.
>> >>
>> >> On Thu, Sep 1, 2011 at 1:08 PM, John Alliage Tinio Morales
>> >>  wrote:
>> >> > If two geographical data match in two sheets, then add/copy/replicate
>> >> > unique
>> >> > id/code
>> >> >
>> >> > Hi guys, this is my problem.
>> >> >
>> >> > I have a geographical data (divided into four colums per REGION,
>> >> > PROVINCE,
>> >> > MUNICIPALITY/TOWN, and BARANGAY/STREET) in one sheet. This sheet
>> >> > contains a
>> >> > UNIQUE GEOGRAPHICAL CODE that IS NUMERICAL IN NATURE.
>> >> >
>> >> > Now, I have also another sheet which lists the same geographical data
>> >> > (divided into four colums per REGION, PROVINCE, MUNICIPALITY/TOWN,
>> >> > and
>> >> > BARANGAY/STREET). The geographic areas included in this sheet are
>> >> > recipients
>> >> > of one government program. But this sheet does not contain the UNIQUE
>> >> > GEOGRAPHICAL CODE.
>> >> >
>> >> > What I would like to do is to match the geographical data found in
>> >> > two
>> >> > sheets, and if they match, copy/replicate/add the UNIQUE GEOGRAPHICAL
>> >> > CODE
>> >> > found in sheet to the other sheet that does not contain the code.
>> >> >
>> >> > I would like to include the geographical code, so that it would
>> >> > become
>> >> > the
>> >> > primary key when I create a database in MS Access.
>> >> >
>> >> > This is the example
>> >> >
>> >> > SHEET 1
>> >> > A B C D E
>> >> > 0019 REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
>> >> >
>> >> > *Column A contains the UNIQUE GEOGRAPHICAL CODE
>> >> >
>> >> > SHEET 2
>> >> > A B C D
>> >> > REGION I BASILAN PROVINCE TIPO MUNICIPALITY BORAS STREET
>> >> >
>> >> > *Sheet 2 contains only 20k entries of geographical areas while Sheet
>> >> > 1
>> >> > contains about 40k entries. Only half of the geographical areas are
>> >> > included
>> >> > in the government program
>> >> >
>> >> > Can you help me?
>> >> >
>> >> >
>> >> > On Thu, Sep 1, 2011 at 3:11 PM, Shaik Waheed 
>> >> > wrote:
>> >> >>
>> >> >> Hi,
>> >> >>
>> >> >> Right Click on the pivot table, select Pivot Tabel Options, move to
>> >> >> 'Data' tab and then Uncheck- "Enable Show Details".
>> >> >> For the date format i think its working fine in both rows n columns.
>> >> >>
>> >> >> Regards,
>> >> >> Waheed.
>> >> >>
>> >> >> On Thu, Sep 1, 2011 at 7:55 AM, Prabhu 
>> >> >> wrote:
>> >> >> > HI All,
>> >> >> > Plz find the pivot table sheet.
>> >> >> > kindly help.
>> >> >> > Regards,
>> >> >> > Prabhu
>> >> >> >
>> >> >> > --
>> >> >> >
>> >> >> >
>> >> >> >
>> >> >> > --
>> >> >> > 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
>> >> >> >
>> >> >>
>> >> >> --
>> >> >>
>> >> >>
>> >> >>
>> >> >> --
>> >> >> 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
>> >> >>
>> >> >> <><><><><><><><><><><><><><><><><><>

$$Excel-Macros$$ Re: Query

2011-09-01 Thread shashi

Dear Venkat

I have second condtion that i want payout amount datewise. I want an
urgent help on condition function. In this data i have the requirement
of *Payout amount* for each branch in datewise without using

On Aug 31, 10:15 pm, shashi  wrote:
> Dear Excel Guru's
>
> I want an urgent help on condition function. In this data i have the
> requirement of *Payout amount* for each branch in datewise without using
> pivot. Please help me in this query.
>
> Thanks
> Regards
> Shashi Ranjan
>
>  Consolidation RI payout Data.xls
> 1512KViewDownload

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

$$Excel-Macros$$ Fwd: Dynamic Ledger

2011-09-01 Thread Ananta Sapkota

-- Forwarded message --
From: Ananta Sapkota 
Date: Mon, Aug 29, 2011 at 3:24 PM
Subject: Dynamic Ledger
To: excel-macros@googlegroups.com


Hi Everyone

I want to make dynamic ledger in excel with control button. Moreover I want
to add new party from by clicking new button.  In this projects accounting
ledger are worksheets and they must be dynamic.

ananta

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

Re: $$Excel-Macros$$ Pivot Table Doubt

2011-09-01 Thread Shaik Waheed

Hi,

Right Click on the pivot table, select Pivot Tabel Options, move to
'Data' tab and then Uncheck- "Enable Show Details".
For the date format i think its working fine in both rows n columns.

Regards,
Waheed.

On Thu, Sep 1, 2011 at 7:55 AM, Prabhu  wrote:
> HI All,
> Plz find the pivot table sheet.
> kindly help.
> Regards,
> Prabhu
>
> --
> --
> 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
>

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

Re: $$Excel-Macros$$ VBA code to copy and save as new book

Re: $$Excel-Macros$$ VBA code to copy and save as new book

Re: $$Excel-Macros$$ xls to Pdf in VBA error

Re: $$Excel-Macros$$ VBA code to copy and save as new book

Re: $$Excel-Macros$$ Pivot Table Doubt

$$Excel-Macros$$ Re: Freeze panes in an Excelsheet Control on a userform

Re: $$Excel-Macros$$ extracting data from a datasheet

Re: $$Excel-Macros$$ extracting data from a datasheet

Re: $$Excel-Macros$$ Pivot Table Doubt

Re: $$Excel-Macros$$ Pivot Table Doubt

Re: $$Excel-Macros$$ Pivot Table Doubt

RE: $$Excel-Macros$$ Re: Need macro to split the files

$$Excel-Macros$$ Freeze panes in an Excelsheet Control on a userform

$$Excel-Macros$$ extracting data from a datasheet

Re: $$Excel-Macros$$ Pivot Table Doubt

$$Excel-Macros$$ Re: Query

$$Excel-Macros$$ Fwd: Dynamic Ledger

Re: $$Excel-Macros$$ Pivot Table Doubt

18 matches

Site Navigation

Mail list logo

Footer information