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 Pas

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 work

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

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

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

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

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

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

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

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

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

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