Re: $$Excel-Macros$$ Help me to generate Report

I think you should use a pivot table for this. click anywhere in the list and then click insert/Pivot table and follow the prompts. On 15 May 2012 17:14, Ankit Agrawal wrote: > Deal All, > > I need your help on the same. > > Any Confusion plz let me know. > > Regards, > Ankit > > > On Fri, May

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

*Hi Anil, It was a awesome attempt, and done it, thanks for the same. But i have some again query, Please find the attached file, i have explained it clearly, i have added one more button, please find that. i want seems to be like search engine in the second form. thank you all the experts. *

$$Excel-Macros$$ suggest a formula on this attachement

Hi, Please suggest a formula on this attachment. -- 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 b

Re: $$Excel-Macros$$ suggest a formula on this attachement

Hi, Please correct my formula on this attachment. On Wed, May 16, 2012 at 2:31 PM, Smitha S R wrote: > Hi, > > Please suggest a formula on this attachment. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Pleas

Re: $$Excel-Macros$$ suggest a formula on this attachement

Hi Smitha, Attached is the soln. Cheers, Andy On Wed, May 16, 2012 at 2:31 PM, Smitha S R wrote: > Hi, > > Please suggest a formula on this attachment. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please >

Re: $$Excel-Macros$$ suggest a formula on this attachement

Sorry missed the last part of the formula The corrected formula is: =IF(F4=0,MIN(E4,C4),(E4+F4-C4)) Cheers, Andy On Wed, May 16, 2012 at 2:37 PM, Smitha S R wrote: > Hi, > > Please correct my formula on this attachment. > > > On Wed, May 16, 2012 at 2:31 PM, Smitha S R wrote: > >> Hi, >> >>

$$Excel-Macros$$ help required for creating a formula

Dear All, I have a list of industry in one column and in corresponding column the rates as per industry are given. I want to create a formula whereby when i selected a specific industry from the dropdown list automatically the corresponding rate is displayed in next cell. I am enclosing my workshe

$$Excel-Macros$$ Re: help required for creating a formula

Hello, PFA! On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote: > Dear All, > > I have a list of industry in one column and in corresponding column > the rates as per industry are given. I want to create a formula > whereby when i selected a specific industry from the dro

Re: $$Excel-Macros$$ help required for creating a formula

Dear Ashish Damor, solved, sheet attached. =VLOOKUP(D7,$A$7:$B$291,2,0) Thanks & Regards, Prajakt Pande +971551388482 ** On Wed, May 16, 2012 at 1:48 PM, ashish damor wrote: > Dear All, > > I have a list of industry in one column and in corresponding column > the rates as per industry are

RE: $$Excel-Macros$$ suggest a formula on this attachement

Hope this solution helps From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Smitha S R Sent: Wednesday, May 16, 2012 2:32 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ suggest a formula on this attachement Hi, Please suggest a formula o

Re: $$Excel-Macros$$ Want to use micros

Hi Reshma for that i want your raw data . Provide me then i can give you with the solved attached sheet On Wed, May 16, 2012 at 11:08 AM, Reshma Shelar wrote: > Hi, > I want to sort my data date & name wise can i use micros for that, if yes > please help me with the formula. > > > Thanks > Reshm

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

*Dear Anil, Thank you so so much for that. any way when you get time please do it. But the attached file that you have send is not at all working properly for customer name too. please find it. * Thanks & Regards, Deba Ranjan P On Wed, May 16, 2012 at 3:51 PM, Anil Gawli wrote: > Hi D

Re: $$Excel-Macros$$ 2 Values in the same cell

Hi, PFA... * * * MARIES* Excel Inspiration -- 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 n

$$Excel-Macros$$ IF Function

How can we add so many conditions in IF function? -- 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

Re: $$Excel-Macros$$ IF Function

Hi Smitha, Can you please send sample file. So that we can help you. In If function you can add any function. Thanks, Naresh V On Wed, May 16, 2012 at 7:11 AM, Smitha S R wrote: > How can we add so many conditions in IF function? > > -- > FORUM RULES (986+ members already B

$$Excel-Macros$$ Re: IF Function

Hello Smitha, Instead of IF , if you are using 2007 version you can use SUMIFS , if you are on 2003 Sumproduct can help you. On Wednesday, May 16, 2012 2:11:28 PM UTC+3, Smitha S R wrote: > How can we add so many conditions in IF function? > -- FORUM RULES (986+ members already BANNED f

Re: $$Excel-Macros$$ Want to use micros

Dear, Please find below are the code for your query. Sub prajakt_pande() Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select ActiveWorkbook.Worksheets("Reg").Sort.SortFields.Clear ActiveWorkbook.Worksheets("Reg").Sort.SortFields.Add Key:=Range("B2:B2484"), _ SortOn:=x

Re: $$Excel-Macros$$ Want to use micros

Hi, * * *Alt + A + S, then Select the Field & Order, Press OK.* On Wed, May 16, 2012 at 4:15 AM, Reshma Shelar wrote: > here is my raw data > > > On Wed, May 16, 2012 at 4:24 PM, Anil Gawli wrote: > >> Hi Reshma >> for that i want your raw data . >> Provide me then i can give you with the solved

$$Excel-Macros$$ Time Difference

Hi Friends, Please help me on this issue. Please refer the attached file. In file, I need time at other countries depending on the time in Mumbai. Time difference is mentioned in the sheet. Please help me by providing answer/vba code. Thanks Mangesh -- FORUM RULES (986+ members already BAN

Re: $$Excel-Macros$$ 2 Values in the same cell

or, replace the values with formulas =d1&”“&e1. See attached Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Maries Sent: Wednesday, May 16, 2012 6:04 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ 2 Values in the same cell

Re: $$Excel-Macros$$ Want to use micros

Sub SortByColBAndColC() ActiveSheet.UsedRange.sort _ Key1:=Range("B2"), Order1:=xlAscending, _ Key2:=Range("C2"), Order2:=xlAscending, _ Header:=xlGuess, OrderCustom:=1, MatchCase:=False, _ Orientation:=xlTopToBottom End Sub Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com

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

Dear Members I use XL 2003, Win XP. I have the following *request* 1. I have a workbook with approx 170 sheets 2. The first 90 or so sheets have some content in them (call them the old sheets), the remaining 80 or so are blank as of now (call them new sheets) 3. I wish to take the content from

RE: $$Excel-Macros$$ 2 Values in the same cell

Are you looking for this See the attached Sheet Sub ManageThem() Dim rngRange As Range Dim rngOutput As Range Dim rngCell As Range Dim lngLoopCounter As Long Dim rngBorders As Range Set rngRange = Application.InputBox("Please select value(s)",

Re: $$Excel-Macros$$ Re: Charts

http://office.microsoft.com/en-us/excel-help/add-data-labels-to-a-chart-HP005198471.aspx#BMpositiondatalabels http://www.techrepublic.com/article/make-your-excel-charts-easier-to-read-with-custom-data-labels/6145493 http://www.ozgrid.com/forum/showthread.php?t=53916 Don Guillett Microsoft MV

Re: $$Excel-Macros$$ help required for creating a formula

Dear Sir, Thanks for your very useful and prompt reply. I am really very grateful to you. Take care. With regards, Ashish On 5/16/12, Prajakt Pande wrote: > Dear Ashish Damor, > > solved, sheet attached. > > > > =VLOOKUP(D7,$A$7:$B$291,2,0) > > > Thanks & Regards, > Prajakt Pande > +97155138

Re: $$Excel-Macros$$ Re: help required for creating a formula

Dear Ashish PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 3:27 PM, CoRe wrote: > Hello, > > PFA! > > > > On Wednesday, May 16, 2012 12:48:35 PM UTC+3, ashish damor wrote: >> >> Dear All, >> >> I have a list of industry in one column and in cor

RE: $$Excel-Macros$$ Want to use micros

Can I ask , why you want macro, if you have Data time Column in your row data? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Reshma Shelar Sent: 16 May 2012 11:08 To: excel-macros@googlegroups.com S

Re: $$Excel-Macros$$ IF Function

Dear Smitha, You can try this accordingly If condition1 = true and condition2 = true and condition3 = true then 'Your code here else 'Your code here end if Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 4:44 PM, Nare

Re: $$Excel-Macros$$ Time Difference

Hi, Find the attachments.. -- * * * MARIES* Excel Inspiration -- 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$$ Time Difference

On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne wrote: > Hi Friends, > > Please help me on this issue. > > Please refer the attached file. > > In file, I need time at other countries depending on the time in Mumbai. > Time difference is mentioned in the sheet. > Please help me by providing answer/

Re: $$Excel-Macros$$ Time Difference

Hi, Thanks for your great help. In vba code, Range("C11").Value = Range("C10") + 0.2916667 why did you have taken 0.2916667 value and many other in formula. Please explain the logic behind it. Thanks Mangesh On Wed, May 16, 2012 at 6:43 PM, Maries wrote: > Hi, > > Find the

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

Pls put your name on the FROM request and provide a file. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: .. Sent: Wednesday, May 16, 2012 7:52 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ 1. paste standard content to all sheets 2. paste sheet na

RE: $$Excel-Macros$$ Re: IF Function

Hi See the discussion on this page http://www.excelforum.com/excel-worksheet-functions/637114-more-than-7-if-st atements.html Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of CoRe Sent: 16 May 20

Re: $$Excel-Macros$$ Re: help required for creating a formula

Core. Please REPLY to messages instead of creating a new one. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: CoRe Sent: Wednesday, May 16, 2012 4:57 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: help required for creating a formula Hello, P

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

Try this :: Sub CopyPaste() Dim wkssheet As Worksheet Dim IntIndex As Integer Dim intLoop As Integer Dim StrSrcName As String For Each wkssheet In ThisWorkbook.Worksheets If wkssheet.UsedRange.Cells.Count > 1 Then IntIndex = wkssheet.In

Re: $$Excel-Macros$$ Time Difference

Dear Mangesh PFA Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 6:48 PM, Mangesh Dayne wrote: > Hi, > > Thanks for your great help. > In vba code, > Range("C11").Value = Range("C10") + 0.2916667 > why did you have taken  0.2916667 

Re: $$Excel-Macros$$ Re: Charts

Give a try to this link http://www.mrexcel.com/archive/Chart/index.html Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Wed, May 16, 2012 at 6:28 PM, dguillett1 wrote: > http://office.microsoft.com/en-us/excel-help/add-data-labels-to-a-chart-HP005198471.aspx#BMposition

RE: $$Excel-Macros$$ Time Difference

HI You can use this also =C10+(HOUR(NOW()+INT(RIGHT(C3)-LEN(C3)-1))) Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ?» lal?? ?sa?? Sent: 16 May 2012 7:14 To: excel-macros@googlegrou

Re: $$Excel-Macros$$ Time Difference

Thanks Rajan On Wed, May 16, 2012 at 7:20 PM, Rajan_Verma wrote: > HI > You can use this also > > =C10+(HOUR(NOW()+INT(RIGHT(C3)-LEN(C3)-1))) > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegro

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

>From : Subu Thanks for the reply *Rajan verma* Unfortunately this did not work. This is what happened 1. I opened the sp sheet. Selected one of the blank sheets. Then hit Control F 11 (macro window opens). Then copy past(ed) your macro to the macro window and hit

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

FROM : Subu --- Thanks Don Guillett - I have written my name on top of this mail... NOT sure if that is what is needed. I generally sign with my name as below - Sample sheet (of course with fewer sheets) is also enclosed regards Subu On Wednesday, May 16, 2012

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

I would suggest a different layout... Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: hilary lomotey Sent: Wednesday, May 16, 2012 9:06 AM To: excel-macros Subject: $$Excel-Macros$$ Link Check Box many times Hello Gurus, i am trying to create a call report in th

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

Your example doesn’t help much. An ACTUAL sample is required. Dummy data is fine but must make sense. Why do you have 90 different sheets with data. Maybe one would do. You do not need to have blank sheets until needed. Each can be created as needed with a macro. I don’t understand copying an ent

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

Hi Donald pls what sort of layout are you thinking? tx On Wed, May 16, 2012 at 2:50 PM, dguillett1 wrote: > I would suggest a different layout... > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* hilary lomotey > *Sent:* Wednesday, May 16, 2012 9:

$$Excel-Macros$$ Pls help for expression col no * 25 + row no

I am happy for your kind support Pls help me again for below issue . Find attached sheet Thanks. -- 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 Nee

Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no

Hi, Try it, * =COLUMN()*25+ROW()* On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote: > I am happy for your kind support > > Pls help me again for below issue . > > Find attached sheet > > > Thanks. > > -- > FORUM RULES (986+ members already BANNED for violation) > > 1) Use concise, accurate

Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no

*PFA...* On Wed, May 16, 2012 at 8:11 PM, Maries wrote: > Hi, > > Try it, > * > =COLUMN()*25+ROW()* > > > > On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote: > >> I am happy for your kind support >> >> Pls help me again for below issue . >> >> Find attached sheet >> >> >> Thanks. >> >> -- >>

Re: $$Excel-Macros$$ Pls help for expression col no * 25 + row no

Thanks It works. On Wed, May 16, 2012 at 9:41 PM, Maries wrote: > Hi, > > Try it, > * > =COLUMN()*25+ROW()* > > > > On Wed, May 16, 2012 at 8:05 PM, Mangesh Dayne wrote: > >> I am happy for your kind support >> >> Pls help me again for below issue . >> >> Find attached sheet >> >> >> Thanks. >>

Re: $$Excel-Macros$$ Time Difference

UNSUBSCRIBE Thanks and Regards, Swarup Choghale --- On Wed, 16/5/12, Naresh V wrote: From: Naresh V Subject: Re: $$Excel-Macros$$ Time Difference To: excel-macros@googlegroups.com Cc: "Mangesh Dayne" Date: Wednesday, 16 May, 2012, 6:47 PM On Wed, May 16, 2012 at 8:04 AM, Mangesh Dayne

Re: $$Excel-Macros$$ Time Difference

TO UNSUBSCRIBE Google Groups help on the subject: http://support.google.com/groups/bin/answer.py?hl=en&answer=46608 Key points thereof: Leave the group by any of these methods: · Reply to any group email and change the subject to "REMOVE ME" · Send a blank email to excel-macros

$$Excel-Macros$$ Unsubscribe

Sent on my BlackBerry® from Vodafone -- 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.

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

Hi Hilary, You could use a character with a check box, and a Worksheet.Click event to place and remove the checks. You can use the Windows Character Map utility (charmap.exe) to browse your fonts. Unicode includes a Ballot Box character (☐), Ballot Box with Check (☑) and Ballot Box with X (☒)

Re: $$Excel-Macros$$ How to get sheet name with formula

Hi U can try below code also... Sub Rename_sheet() Sheets(2).Activate ActiveSheet.Name = "Sheet ka name Change hua" End Sub On Mon, May 14, 2012 at 11:56 AM, hilary lomotey wrote: > tnks boss > > > On Mon, May 14, 2012 at 5:44 PM, Seraj Alam wrote: > >> Hi >> >> You can below code also >>

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

Dear all, I want to create a list in data validation which take a dynamic range in alphabetic order. Can it be possible I have tried to find it google but could not solve this though have got solutions! Please help like you help us with indirect function module! Sandeep Chhajer. Sent on my B

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

dear Noorani, do you have material for intermediate level user in which macro and other material related to advance is not included. plz send me. On 5/15/12, Mangesh Dayne wrote: > Its really valuable material and study file I have ever seen in my > life...!!! > User friendly > > Thanks friend

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

Hi, U can use this formula in data validation for dynamic range =OFFSET($A$1,0,0,COUNTA(A:A),1) And also find the attached sheet with example hope it will help you what u are looking for On Wed, May 16, 2012 at 9:21 PM, wrote: > Dear all, > > I want to create a list in data validation whic

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

Dear Excel Group Friends Is there any way that certain rows of a sheet is repeated at the bottom of each page.. Siraj -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help,

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

Dear all, I have written a simple procedure to fill cells with dates, it depends on the current month and decide the range of the cells. Can anyone suggest any room for improvement for my code? Sub monthfill() Dim myrange As Range Dim mth As Integer Cells.Clear mth = month(Date) Select Cas

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

dear Noorani, do you have material for intermediate level user in which macro and other material related to advance is not included. plz send me. On Thursday, May 17, 2012 7:56:40 AM UTC+3, TARUN wrote: > > dear Noorani, > > do you have material for intermediate level user in which macro

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

Hi Don, Say for an example: I have data from A to H G col : HCol : 5 : -5 Subtotal: 0 Now, what I want is ...copy the entire block to another sheet and delete that zero subtotal block. Please do let me know if you need any more information. Thanks, Srini On Monday,