date:20110910

Re: $$Excel-Macros$$ Moving Sheets

2011-09-10 Thread rajan verma

Hi
Try This

Sub GetALlSheet()
Dim sh As Worksheet
Dim wb As Workbook
Set wb = ActiveWorkbook
Application.Workbooks.Add
For Each sh In wb.Sheets
sh.Copy ActiveWorkbook.Sheets(1)
ActiveSheet.Cells.Copy
Selection.PasteSpecial Paste:=xlPasteValues,
Operation:=xlNone, SkipBlanks _
:=False, Transpose:=False
Application.CutCopyMode = False
Next
ActiveWorkbook.SaveAs "D:\MyWorkbook"
ActiveWorkbook.Close
End Sub




http://excelpoweruser.blogspot.com/2011/08/making-different-workbook-without.html

On 9/10/11, bom  wrote:
> I would like to know whether its possible to move sheets from one
> workbook to another without the formulas on the sheets moved being
> changed?
> For example I want to move two sheets from one workbook to another.
> One of those sheets populates info from the other sheet that is being
> moved with it. when I moved them to the other workbook, I don't wanna
> have any info of the previous workbook in the formula bar.
> Hope you understand what I am trying to say.
> Regards.
>
> --
> --
> 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
Rajan verma
+91 9158998701

-- 
--
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$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-10 Thread R Swarup

Dear dguille...@gmail.com,please be informed that spreadsheet is other name
for work sheet.

On Sat, Sep 10, 2011 at 8:24 PM, dguillett1  wrote:

> Please give clear before/after examples and how you get from before to
> after.
> Be advised that
> a file is called a workbook
> a sheet within a workbook is called a sheet or worksheet.
> There is NO such term as SPREADSHEET
>
> -Original Message- From: Jose Costa
> Sent: Thursday, September 08, 2011 3:34 PM
> To: MS EXCEL AND VBA MACROS
> Subject: $$Excel-Macros$$Read column(s) and calculate currency on multiple
> target spreadsheets/worksheets
>
>
> Hi all,
>
> I'm trying to build an Excel solution that would do the following:
>
> - User select a given spreadsheet/worksheet/column(**sample below),
> where file location may vary and exchange rate column will vary (based
> on Month)
>
> - Allows target selection:
>  User selects target spreadsheet(s) and worksheet(s) within
> spreadsheet(s)
>  User selects currency and amount columns for each worksheet/
> spreadsheet
>  User defines target rates (CAD and USD) into target columns
> (e.g. CAD @ G, USD @ I)
>
> Logic converts values and writes to target columns
>
>
> Currency Name Currency Code Base Rate Nov10 Dec10 Jan11
> UNITED STATES DOLLARS USD CAD 1.026115 0.997437 1.001006
> ALGERIA DINARS DZD CAD 0.013764 0.013383 0.013726
> ALGERIA DINARS DZD USD 0.013414 0.013417 0.013712
> ARGENTINA PESOS ARS CAD 0.257947 0.251244 0.249783
> ARGENTINA PESOS ARS USD 0.251383 0.251889 0.249532
> ARUBA GUILDERS AWG CAD 0.573249 0.557227 0.559221
> ARUBA GUILDERS AWG USD 0.558659 0.558659 0.558659
> AUSTRALIA DOLLARS AUD CAD 0.984433 1.019336 0.997949
> AUSTRALIA DOLLARS AUD USD 0.959379 1.021956 0.996946
> BAHAMAS DOLLARS BSD CAD 1.026115 0.997437 1.001006
> BAHAMAS DOLLARS BSD USD 1.00 1.00 1.00
> BAHRAIN DINARS BHD CAD 2.721465 2.645160 2.655154
> BAHRAIN DINARS BHD USD 2.652203 2.651957 2.652485
> BANGLADESH TAKA BDT CAD 0.014586 0.014118 0.014139
>
>
> Can you help?
>
> Thanks in advance!
>
> JC
>
> --
> --**--**
> --
> 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
>



-- 
Regards
Ram
9990484446/011-46087206

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

2011-09-10 Thread R Swarup

Dear All,my query may be a bit of a challenge.I want to protect my sheet
while allowing user to play with grouping that forms on the left most part
of the worksheet when you use sub total.Hope it is clear and understandable
to all.

-- 
Regards
Ram
9990484446/011-46087206

-- 
--
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$$ Moving Sheets

2011-09-10 Thread bom

I would like to thank y'all for your help

On Sep 10, 11:41 am, NOORAIN ANSARI  wrote:
> Dear Bom,
>
> Use simple way...
> Please open both workbook..
> and right click on particular sheet and move it to another opened
> workbook.where you want to move...
>
>
>
>
>
>
>
>
>
> On Sat, Sep 10, 2011 at 12:54 AM, bom  wrote:
> > I would like to know whether its possible to move sheets from one
> > workbook to another without the formulas on the sheets moved being
> > changed?
> > For example I want to move two sheets from one workbook to another.
> > One of those sheets populates info from the other sheet that is being
> > moved with it. when I moved them to the other workbook, I don't wanna
> > have any info of the previous workbook in the formula bar.
> > Hope you understand what I am trying to say.
> > Regards.
>
> > --
>
> > --- 
> > ---
> > 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 athttp://www.excel-macros.blogspot.com
> > 4. Learn VBA Macros athttp://www.quickvba.blogspot.com
> > 5. Excel Tips and Tricks athttp://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://excelmacroworld.blogspot.com/*
> *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

Re: $$Excel-Macros$$ Need help with advance filter

2011-09-10 Thread Steve Weaver


Thank you dguillett!!

I'm not real sure how this works or what to do with it. Could you please 
explain to me each step in "baby talk" ?


Thank you!

Steve




On 9/10/2011 10:31 AM, dguillett1 wrote:
From what I can see, it appears that Very easy to just use a simple 

Autofilter on ONE sheet with the proper SELF ADJUSTING subtotal formulas.
=SUBTOTAL(109,(H3:OFFSET(H3,MATCH(999,H:H),0)))

See attached

-Original Message- From: Steve Weaver
Sent: Saturday, September 10, 2011 6:40 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Need help with advance filter

Hi,

Every month I download a single commission file which contains between 3
- 4 representatives. Currently I copy and paste the data for each rep
into a unique work sheet so that the appropriate reports can be produced.

I tried using advanced filtering but could not get the desired results.
To write a MACRO to do this is beyond my technical ability.

I'd like to find a way using either a macro OR advance filtering to do
this work for me.

Please send suggestions.

Thank you!

Steve



--
--
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$$ Need help with advance filter

2011-09-10 Thread dguillett1

Did you get what I sent?


From: Steve Weaver 
Sent: Saturday, September 10, 2011 1:56 PM
To: excel-macros@googlegroups.com 
Subject: Re: $$Excel-Macros$$ Need help with advance filter

Thank you very much  Ashish!!!

How would you modify the code below to place the appropriate data from the 
Input Data tab into the corresponding rep tab without affecting the existing 
formats or column headings being used in the Rep tabs? Also the new data being 
copied/moved to the Rep tab should overwrite any existing data. 

Thank you again for your help.

Steve Weaver




On 9/10/2011 10:04 AM, ashish koul wrote: 
  try this

  select any rep name in col a and run the macro

  Sub filter()
  Application.ScreenUpdating = False

  If ActiveCell.Column = 1 Then
  Z = Sheets("Input Data").Range("a1").End(xlDown).Row
  On Error Resume Next
  Sheets("Input Data").AutoFilterMode = False

  Sheets("Input Data").Range("$A$1:$I" & Z).AutoFilter Field:=1, 
Criteria1:=ActiveCell.Value
  Sheets("Input Data").Range("$A$1:$I" & Z).SpecialCells(xlCellTypeVisible).Copy
  Sheets.Add After:=Sheets(Sheets.Count)

  Cells(1, 1).Select

  ActiveSheet.Paste
  On Error Resume Next

  ActiveSheet.Name = Cells(2, 1).Value
  On Error Resume Next
  Sheets("Input Data").AutoFilterMode = False

  End If

  Application.ScreenUpdating = True
  End Sub


  On Sat, Sep 10, 2011 at 5:10 PM, Steve Weaver  
wrote:

Hi,

Every month I download a single commission file which contains between 3 - 
4 representatives. Currently I copy and paste the data for each rep into a 
unique work sheet so that the appropriate reports can be produced.

I tried using advanced filtering but could not get the desired results.  To 
write a MACRO to do this is beyond my technical ability.

I'd like to find a way using either a macro OR advance filtering to do this 
work for me.

Please send suggestions.

Thank you!

Steve

-- 

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


-- 
--
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$$ Re: Urgent Help

2011-09-10 Thread NOORAIN ANSARI

> Dear santosh,
>
> Please follow below link
>
> http://www.techbookreport.com/tutorials/fso1.html
>
> Thanks & regards,
> Noorain Ansari
> http://excelmacroworld.blogspot.com/
> http://noorain-ansari.blogspot.com/
>
> - Show quoted text -
>
> On Sat, Sep 10, 2011 at 10:01 AM, Santosh V 
> wrote:
>  Dim fso As New FileSystemObject
>
>   or I can do this:Dim fso As Object
>
> Set fso = CreateObject("Scripting.FileSystemObject")
> How do I know what string to use for CreateObject? For example, how would I
> know to use the "Scripting." part of "Scripting.FileSystemObject"? Where do
> you go to look that up?
>
>
>
> --
>
>
>
>  On Sat, Sep 10, 2011 at 10:01 AM, Santosh V wrote:
>
>> Dim fso As New FileSystemObject
>>
>>  or I can do this:
>>
>> Dim fso As Object
>>
>> Set fso = CreateObject("Scripting.FileSystemObject")
>>
>> How do I know what string to use for CreateObject? For example, how would
>> I know to use the "Scripting." part of "Scripting.FileSystemObject"? Where
>> do you go to look that up?
>>
>
>
>
> --
>

-- 
--
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$$ Moving Sheets

2011-09-10 Thread NOORAIN ANSARI

Dear Bom,

Use simple way...
Please open both workbook..
and right click on particular sheet and move it to another opened
workbook.where you want to move...



On Sat, Sep 10, 2011 at 12:54 AM, bom  wrote:

> I would like to know whether its possible to move sheets from one
> workbook to another without the formulas on the sheets moved being
> changed?
> For example I want to move two sheets from one workbook to another.
> One of those sheets populates info from the other sheet that is being
> moved with it. when I moved them to the other workbook, I don't wanna
> have any info of the previous workbook in the formula bar.
> Hope you understand what I am trying to say.
> Regards.
>
> --
>
> --
> 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://excelmacroworld.blogspot.com/*
*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

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

2011-09-10 Thread dguillett1

Please give clear before/after examples and how you get from before to 
after.

Be advised that
a file is called a workbook
a sheet within a workbook is called a sheet or worksheet.
There is NO such term as SPREADSHEET

-Original Message- 
From: Jose Costa

Sent: Thursday, September 08, 2011 3:34 PM
To: MS EXCEL AND VBA MACROS
Subject: $$Excel-Macros$$Read column(s) and calculate currency on multiple 
target spreadsheets/worksheets


Hi all,

I'm trying to build an Excel solution that would do the following:

- User select a given spreadsheet/worksheet/column(sample below),
where file location may vary and exchange rate column will vary (based
on Month)

- Allows target selection:
  User selects target spreadsheet(s) and worksheet(s) within
spreadsheet(s)
  User selects currency and amount columns for each worksheet/
spreadsheet
  User defines target rates (CAD and USD) into target columns
(e.g. CAD @ G, USD @ I)

Logic converts values and writes to target columns


Currency Name Currency Code Base Rate Nov10 Dec10 Jan11
UNITED STATES DOLLARS USD CAD 1.026115 0.997437 1.001006
ALGERIA DINARS DZD CAD 0.013764 0.013383 0.013726
ALGERIA DINARS DZD USD 0.013414 0.013417 0.013712
ARGENTINA PESOS ARS CAD 0.257947 0.251244 0.249783
ARGENTINA PESOS ARS USD 0.251383 0.251889 0.249532
ARUBA GUILDERS AWG CAD 0.573249 0.557227 0.559221
ARUBA GUILDERS AWG USD 0.558659 0.558659 0.558659
AUSTRALIA DOLLARS AUD CAD 0.984433 1.019336 0.997949
AUSTRALIA DOLLARS AUD USD 0.959379 1.021956 0.996946
BAHAMAS DOLLARS BSD CAD 1.026115 0.997437 1.001006
BAHAMAS DOLLARS BSD USD 1.00 1.00 1.00
BAHRAIN DINARS BHD CAD 2.721465 2.645160 2.655154
BAHRAIN DINARS BHD USD 2.652203 2.651957 2.652485
BANGLADESH TAKA BDT CAD 0.014586 0.014118 0.014139


Can you help?

Thanks in advance!

JC

--
--
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$$ Need help with advance filter

2011-09-10 Thread ashish koul

try this

select any rep name in col a and run the macro

Sub filter()
Application.ScreenUpdating = False

If ActiveCell.Column = 1 Then
Z = Sheets("Input Data").Range("a1").End(xlDown).Row
On Error Resume Next
Sheets("Input Data").AutoFilterMode = False

Sheets("Input Data").Range("$A$1:$I" & Z).AutoFilter Field:=1,
Criteria1:=ActiveCell.Value
Sheets("Input Data").Range("$A$1:$I" &
Z).SpecialCells(xlCellTypeVisible).Copy
Sheets.Add After:=Sheets(Sheets.Count)

Cells(1, 1).Select

ActiveSheet.Paste
On Error Resume Next

ActiveSheet.Name = Cells(2, 1).Value
On Error Resume Next
Sheets("Input Data").AutoFilterMode = False

End If

Application.ScreenUpdating = True
End Sub


On Sat, Sep 10, 2011 at 5:10 PM, Steve Weaver wrote:

> Hi,
>
> Every month I download a single commission file which contains between 3 -
> 4 representatives. Currently I copy and paste the data for each rep into a
> unique work sheet so that the appropriate reports can be produced.
>
> I tried using advanced filtering but could not get the desired results.  To
> write a MACRO to do this is beyond my technical ability.
>
> I'd like to find a way using either a macro OR advance filtering to do this
> work for me.
>
> Please send suggestions.
>
> Thank you!
>
> Steve
>
> --
> --**--**
> --
> 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

$$Excel-Macros$$ Fwd: Job MIS Executive at Chennai

2011-09-10 Thread Venkat CV

- Original message 
From:"Source One Management Services Pvt.Ltd"< vik...@msourceone.com >
Date: 10 Sep 11 12:29:14
Subject: Hi, Urgent Opening for MIS Executive at Chennai :Contract to Hire
To:

The sender of this email is registered with Naukri.com as Source One
Management Services Pvt.Ltd Dear Candidate,Hi !

Hope you are doing well !!

This is Vikram from SourceOne. Source One (www.msourceone.com) one of the
fastest growing company from India needs MIS Executives for Chennai location
for One of the leading MNC 2 years of experience

JD â€“

Good in MS Office(Excel and MS word)

Good Communication skills

Only those candidates who can join us in 10days notice period after offer,
should apply.

Your employment with Source One would be permanent after selection and would
be

deputed at multi b$ MNC for a long term project. Salary and long term career
opportunity

with Source One would be excellent.

Kindly send your updated CV with below input if you would be interested for
this opportunity.

Your Contact Number:

Present Company Name location:

Total Exp :

Date of Birth:

Are you working at present (Y/N):

If not please specify reason for not working:

Present Employment (Permanent or Contract):

Current Salary:

Expected minimum salary:

What is your current Notice Period:

Willing to join Source One in 7-10 Days or Immediate, please specify:

Please specify your reason for change:

Willing to work in Chennai

Thanks & Regards,

_

Vikram Anand Sharma

Source One Management Services Pvt Ltd,

E-Mail:vik...@msourceone.com;

URL : www.msourceone.com, www.sourceone.co.inIs this job relevant to you?
Yes No Your feedback would help us in sending you the most relevant job
opportunities Disclaimer: The sender of this email is registered with
naukri.com as Source One Management Services Pvt.Ltd (c...@msourceone.com, *,
BANGALORE, Karnataka - 560001) using Naukri.com services. The responsibility
of checking the authenticity of offers/correspondence lies with you.

If you consider the content of this email inappropriate or spam, you
may:Report abuse by forwarding this email to: compliance@naukri.comYou can
also Block this Company from searching your resume in the database.
Advisory: Please do not pay any money to anyone who promises to find you a
job. This could be in the form of a registration fee, or document processing
fee or visa charges or any other pretext. The money could be asked for
upfront or it could be asked after trust has been built after some
correspondence has been exchanged. Also please note that in case you get a
job offer or a letter of intent without having been through an interview
process it is probably a scam and you should contact
compliance@naukri.comfor advise. To be on the top of Employer's Resume
Search
Update Your Resume Now Your Resume has only 30 seconds to impress a
Recruiter. Get your resume written by Experts.
Call 1800-102-5557 now! (Toll-Free)

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

-- 
--
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$$ Getpivot formua help

2011-09-10 Thread Daniel

Hi,

 

In B8 formula, there is no field element « Full Year FY11» for field « Half
Yearly ». Which cell address do you intend to place in cell B8 ?

 

Regards.

 

Daniel

 

De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De
la part de Shiek Peer Mohd
Envoyé : samedi 10 septembre 2011 12:22
À : excel-macros@googlegroups.com
Objet : $$Excel-Macros$$ Getpivot formua help

 

Hi All,
 
I have put the Getpivotdata formula in the summary sheet. But Full year
revenue is not working. 
 
Please help me to correct the formula
 
Please refer the any alternate formula directly comes from the data sheet.

-- 
Regards,

Shiek

-- 

--
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$$ Moving Sheets

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

$$Excel-Macros$$ Hi

Re: $$Excel-Macros$$ Moving Sheets

Re: $$Excel-Macros$$ Need help with advance filter

Re: $$Excel-Macros$$ Need help with advance filter

$$Excel-Macros$$ Re: Urgent Help

Re: $$Excel-Macros$$ Moving Sheets

Re: $$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Re: $$Excel-Macros$$ Need help with advance filter

$$Excel-Macros$$ Fwd: Job MIS Executive at Chennai

RE: $$Excel-Macros$$ Getpivot formua help

12 matches

Site Navigation

Mail list logo

Footer information