RE: $$Excel-Macros$$ Addition of Formula in Pivot

FYI, please find attached sample sheet... Best Regards, Amit From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aindril De Sent: 18 May 2012 10:28 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Addition of Formula in Pivot Hi Amit, Can you

Re: $$Excel-Macros$$ Addition of Formula in Pivot

Hi Amit, Can you send a sample dataset? Regards, Andy On Fri, May 18, 2012 at 10:22 AM, Amit Desai (MERU) wrote: > Please help... > > ** ** > > I have tried adding formula in Pivot but getting an error “#DIV/0! . > > ** ** > > I want Avg cost per Visit. There is a column for cost(colu

$$Excel-Macros$$ Addition of Formula in Pivot

Please help... I have tried adding formula in Pivot but getting an error "#DIV/0! . I want Avg cost per Visit. There is a column for cost(column head "A")in of each cab getting repaired & also cab registration number (column head "B")is maintained. Best Regards, Amit ___

RE: $$Excel-Macros$$ Row to repeat at the bottom of each page

Hi Asa Rossoff Thank You for your advice, actually the problem is it is an small box with border are there which I want to repeat at bottom and in page footer this border option is not there, marries on this group provided me the macro to repeat particular rows at the bottom but the borders are

Fwd: $$Excel-Macros$$ Form tracker and new base

*Dear Expert, Please anyone help me on my query, the query is in the attached file. i have been looking on this and trying for past couple of days back. thank you experts. * Thanks & Regards, Deba Ranjan P -- Forwarded message -- From: Deba Ranjan Date: Wed, May 1

Re: $$Excel-Macros$$ Ask for improvement for procedure for date filling

Dear all, Thanks for your help! 2012/5/17 dguillett1 > Sub dates() > days = Day(DateSerial(Year(Date), myMonth + 1, 1) - 1) > MsgBox days > Set myrange = Range("b1: b”& days) > With myrange.Cells(1) > .Value = DateSerial(Year(Date), Month(Date), 1) > .AutoFill Destination:=myrange, Type:=xl

Re: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION

sir if u hav file related to use short cuts for using desktop and microsoft word  pls send --- On Tue, 15/5/12, NOORAIN ANSARI noorain.ans...@gmail.com wrote: From: NOORAIN ANSARI Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION To: excel-macros@googlegroups.com Date: Tuesday, 15 May,

Re: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION

i need material on excel shortcuts pls send if ne one have --- On Thu, 17/5/12, Tarun Mondal wrote: > From: Tarun Mondal > Subject: Re: $$Excel-Macros$$ ALL EXCEL FORMULA & FUNCTION > To: excel-macros@googlegroups.com > Date: Thursday, 17 May, 2012, 10:26 AM > dear Noorani, > > do you have ma

RE: $$Excel-Macros$$ VBA If statement

Hi Burbonizer, See if the following does what you want. It modifies your code to require both conditions for the field you printed in red to be made visible. If either condition is false, the field is made invisible again. If me.active_statuts = "IH" then Me.Input1.SetFocus Me.Button

RE: $$Excel-Macros$$ Row to repeat at the bottom of each page

Hi Siraj, I do not think so. Not automatically. You would have to have the rows repeated on your worksheet at appropraite places, or use a macro to temporarily insert those rows, print the sheet, and then remove them again. The most common solution, I think, is to use the page footer inst

Re: $$Excel-Macros$$ Values 2 New

Thank you so much Rajan you are really asset of this group. Can you guide how to become the expert like you in formulas & macros. Aamir Shahzad On Fri, May 18, 2012 at 12:50 AM, Rajan_Verma wrote: > I think it will be final J > > > > Sub CreateCopy() > > ActiveSheet.Copy after:=ActiveSheet > >

Re: $$Excel-Macros$$ Values 2 New

thanks rajan for your expertise. But if format started from B2 to H10 when run the code, sheet format automatically starts from A1 to. Please see & amend that create the new copy values sheet except copy. Aamir Shahzad On Fri, May 18, 2012 at 12:35 AM, Rajan_Verma wrote: > > > > > Sub MakeCopyof

RE: $$Excel-Macros$$ Values 2 New

Sub MakeCopyofValues() Dim rngRange As Range Dim wksSheet As Worksheet Set rngRange = Application.InputBox("Select A Range", , , , , , , 8) rngRange.Copy Set wksSheet = Worksheets.Add wksSheet.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks _ :=F

Re: $$Excel-Macros$$ Values 2 New

ok Rajan now code is working fine but it's removing the formating. Aamir Shahzad On Fri, May 18, 2012 at 12:24 AM, Rajan_Verma wrote: > *REMOVE THE ALL BLANK LINES BETWEEN LINES OF CODE* > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > > > *From:* excel-macros@goog

$$Excel-Macros$$ Need Network Security Engineer

*Hi;* * * *Greetings from Sigmatechnologies!* * * *I Hope you are doing great…* * * Let me know if you have anyone for the below role. This is a hot need from our client. Network Security Engineer Location: Dublin, OH, PA, NJ, Rate: depending on the exp Duration : 6 months • expert

RE: $$Excel-Macros$$ Values 2 New

REMOVE THE ALL BLANK LINES BETWEEN LINES OF CODE Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 18 May 2012 12:52 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ V

RE: $$Excel-Macros$$ Values 2 New

Did you select the range in input box?? Can you share the screenshot of Error? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Aamir Shahzad Sent: 18 May 2012 12:46 To: excel-macros@googlegroups.c

Re: $$Excel-Macros$$ Values 2 New

Don, Your macro is convert the sheet to values only not creating copy of sheet. Rajan, Your macro is showing error. Regards, Aamir Shahzad On Thu, May 17, 2012 at 10:37 PM, Rajan_Verma wrote: > *Try this One:* > > > > > > Sub MakeCopyofValues() > > > > Dim rngRange As Range > > Dim wksSheet

$$Excel-Macros$$ Need Network Security Engineer

*Hi;* * * *Greetings from Sigmatechnologies!* * * *I Hope you are doing great…* * * Let me know if you have anyone for the below role. This is a hot need from our client. Network Security Engineer Location: Dublin, OH, PA, NJ, Rate: depending on the exp Duration : 6 months • expert

RE: $$Excel-Macros$$ Values 2 New

Try this One: Sub MakeCopyofValues() Dim rngRange As Range Dim wksSheet As Worksheet Set rngRange = Application.InputBox("Select A Range", , , , , , , 8) rngRange.Copy Set wksSheet = Worksheets.Add wksSheet.Range("A1").PasteSpecial Paste:=xlPasteValues, Operation:=xlNone, SkipBlanks

Re: $$Excel-Macros$$ Values 2 New

Sub makevalues() ActiveSheet.UsedRange.Value = _ ActiveSheet.UsedRange.Value End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Aamir Shahzad Sent: Thursday, May 17, 2012 12:15 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Values 2 New Dear G

$$Excel-Macros$$ Values 2 New

Dear Group, Macro required which generate the same copy of sheet but values only. Regards, Aamir Shahzad -- 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,

RE: $$Excel-Macros$$ VBA If statement

We are not asking for your all data, you can send some sample data with your Code Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Burbonizer Sent: 17 May 2012 8:32 To: excel-macros@googlegroups.com Su

Re: $$Excel-Macros$$ VBA If statement

I can not do that, the file is nearly 200mb in size. The code that i have attached is all that i can really show. On Thursday, May 17, 2012 2:13:34 PM UTC+1, Rajan_Verma wrote: > > Please attach your sample file > > > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > >

RE: $$Excel-Macros$$ Re: Row to repeat at the bottom of each page

Hi I cannot send you the complete file because it is big file due to group restriction I have set example, in the file suppose I want to repeat rows A73:J76 I will be fixing these rows at the last rows of the sheet because my data is large, that I want to repeat at the bottom of the each page.

Re: $$Excel-Macros$$ Re: Delete Zero subtotal blocks

Provide file Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: sreenivas kammari Sent: Thursday, May 17, 2012 1:58 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Delete Zero subtotal blocks Hi Don, Say for an example: I have data from A to H...

Re: $$Excel-Macros$$ Ask for improvement for procedure for date filling

Sub dates() days = Day(DateSerial(Year(Date), myMonth + 1, 1) - 1) MsgBox days Set myrange = Range("b1: b”& days) With myrange.Cells(1) .Value = DateSerial(Year(Date), Month(Date), 1) .AutoFill Destination:=myrange, Type:=xlFillDays End With End Sub Don Guillett Microsoft MVP Excel SalesAid Softwa

RE: $$Excel-Macros$$ VBA If statement

Please attach your sample file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Burbonizer Sent: 17 May 2012 3:53 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ VBA If statement Hi

Re: $$Excel-Macros$$ Dynamic List range for Data validation

try Sub setdvlist() With Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row) .Sort Key1:=Range("A2"), Order1:=xlAscending, Header:=xlGuess, _ OrderCustom:=1, MatchCase:=False, Orientation:=xlTopToBottom .Name = "dvlist" End With With Range("b2").Validation .Delete .Add Type:=xlVal

RE: $$Excel-Macros$$ Anybody have total Floor's Electrical Load Calculation Sheet.Xls

If you can send the query with parameters and Calculation we can make it for you J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of jocky Beta Sent: 17 May 2012 2:36 To: excel-macros@googlegroups.com S

RE: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell

Hi Sabu, Intloop can not be 1 if your workbook have at least one worksheet with data , IntLoop is actually starting From first Blank Worksheets Index, Suppose if you have 5 filled workhseets then 10 blank worksheets, IntLoop will be start from 6 and end with 10 Regards Rajan verma +91 7

RE: $$Excel-Macros$$ Re: Row to repeat at the bottom of each page

One way is to save that row somewhere As an image, then Give that image in footer J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: 17 May 2012 1:23 To: excel-macros@googlegroups.com Subj

RE: $$Excel-Macros$$ Re: Delete Zero subtotal blocks

Please attach sample file to get Exact result J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of sreenivas kammari Sent: 17 May 2012 12:29 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re

RE: $$Excel-Macros$$ Ask for improvement for procedure for date filling

Hi, First you Can give Name ranges instead of Static Range like B1:B31 Second : You can create a Function for these lines to reduce the Lines from your code With myrange.Cells(1) .Value = DateSerial(Year(Date), month(Date), 1) .AutoFill Destination:=myrange, Type:=xlFi

Re: $$Excel-Macros$$ Dynamic List range for Data validation

Thanks to all! I will try and revert back to you! Sandeep Chhajer. Sent on my BlackBerry® from Vodafone -Original Message- From: chhajersand...@gmail.com Sender: excel-macros@googlegroups.com Date: Thu, 17 May 2012 04:21:51 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Ma

RE: $$Excel-Macros$$ Dynamic List range for Data validation

Hi Please find the attached Sheet It provide you a dynamic and sorted list in List Validation Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Seraj Alam Sent: 17 May 2012 11:07 To: excel-macros@go

Re: $$Excel-Macros$$ Dynamic List range for Data validation

Give a try to this link.. http://www.excelfox.com/forum/f12/dependent-data-validation-using-only-formulas-111/ Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Thu, May 17, 2012 at 11:07 AM, Seraj Alam wrote: > Hi, > > U can use this formula in data validation for dynami

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

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

Re: $$Excel-Macros$$ Anybody have total Floor's Electrical Load Calculation Sheet.Xls

Hi, Check this link, http://www.jiguparmar.com/1_22_Electrical-Engineering.html * * * MARIES* Excel Inspiration -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Ur

$$Excel-Macros$$ Anybody have total Floor's Electrical Load Calculation Sheet.Xls

Hi, Anybody have total Floor's Electrical Load Calculation Sheet.Xls If YES then request you to forward me the same * * * * *JOCKY* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Form

Re: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell

>From : Subu Dear Rajan other list members I'm a complete novice in VBA. Still, I think there is a problem in this reply / code below - When you reach this statement "...Worksheets(intLoop).Paste...", Intloop is still = 1. i.e. value of Int

Re: $$Excel-Macros$$ Row to repeat at the bottom of each page

Dear Siraj Momin, please follow the steps 1. go to file 2. paresetup 3. choose sheets 4 rows to repeat at top ok regards, Sanjib On Thu, May 17, 2012 at 11:17 AM, Siraj Momin (BTG) wrote: > Dear Excel Group Friends > > ** ** > > Is there any way that certain rows of a sheet is repeated

Re: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet name to a specific cell

>From : Subu Thanks for the post My follow up replies are shown as bullet points and are shown within -- / lines On Wednesday, May 16, 2012 6:59:34 PM UTC+4, Don Guillett wrote: > > Your example doesn’t help much. An ACTUAL s

Re: $$Excel-Macros$$ Re: Row to repeat at the bottom of each page

Hi, Excel having options for *"Rows to Repeat at Top" *- Press Alt + P + I, Select the Range and OK. There is no in-build function for *Rows to Repeat at Bottom*, You can try below codes to show it in footer. Sub MyFooter() Dim StrFtr As String, Rng As Range, Sh As Worksheet, c As Range

Re: $$Excel-Macros$$ Link Check Box many times

Thanks Asa Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: "Asa Rossoff" Sender: excel-macros@googlegroups.com Date: Wed, 16 May 2012 16:08:09 To: Reply-To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Link Check Box many times Hi Hilary,

$$Excel-Macros$$ Re: Row to repeat at the bottom of each page

Hello Siraj, Please give more information , attach an example. On Thursday, May 17, 2012 8:47:26 AM UTC+3, Siraj Momin (BTG) wrote: > Dear Excel Group Friends > > > > Is there any way that certain rows of a sheet is repeated at the bottom of > each page…… > > > > > > > > Siraj > >