Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Yes, the names are all ok, i double checked it, even try to change names, but doesn´t work :S 2011/7/21 Anish Shrivastava > Please check if the sheet name is "Pivot". > if not then rename it to Pivot. > On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote: > >> Hi guys, i have this macro i us

Re: $$Excel-Macros$$ Help Macro doesn´t work anymore, keeps giving same error

Please check if the sheet name is "Pivot". if not then rename it to Pivot. On Thu, Jul 21, 2011 at 10:44 PM, Jorge Marques wrote: > Hi guys, i have this macro i use to copy a range from column D of a > worksheet of a workbook to column G of another workbook and worksheet, but > it keeps giving me

Re: $$Excel-Macros$$ help requ

Hi, I have names, order no and county names in two sheets.. need to consolidate in one sheet.. Thanks On Thu, Jul 21, 2011 at 7:04 PM, Anish Shrivastava wrote: > Vijay, > > Though you have provided the sample sheet your requirement is not clear. > > What do you mean by merge the names in one s

Re: $$Excel-Macros$$ help requ

Vijay, Though you have provided the sample sheet your requirement is not clear. What do you mean by merge the names in one sheet. do you want to consolidate the data or you want a concatenation. On Thu, Jul 21, 2011 at 5:33 PM, vijayajith VA wrote: > fyi > > > On Wed, Jul 20, 2011 at 6:25 PM, N

RE: $$Excel-Macros$$ Help with Pivot Table

There is incompatibility in the way both versions are handling pivots. If you are to design pivots with Excel 2007 for Excel 2003 users, you should run Excel 2007 in compatibility mode. Regards. Daniel De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de

Re: $$Excel-Macros$$ help requ

Dear Vijay, Please provide sample sheet On Wed, Jul 20, 2011 at 5:49 PM, vijayajith VA wrote: > Hi, > > > 1; > I have several names in two sheets..i need to merge it in one sheet...is > this possible using formula.. > > Thanks > > > > -- > > -

Re: $$Excel-Macros$$ Help required

Dear Noorain, Really helpful solution. thanks a lot. one question to you, is there any process to select two groups at a time? cause I have a large database 15 customer groups from where I have to select only Distributor & Super Stokist only. please reply Thanks in advance Kalyan On Mon, Jul

RE: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work

Use this Sub EndLoop() Range("A2").Select Do ActiveCell.Value = "2010 Real" ActiveCell.Offset(1, 0).Select Loop Until ActiveCell.Offset(0, 1).Value = "Total" End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Thursday

Re: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work

Ah that was fast and PERFECT :), i suppose, cell(i,2), the 2 is for column B, 3 C 4 D and so on(this is a huge implement in my learning), many many many thanks Ashish, perfect as always :). 2011/7/14 ashish koul > try this > > Sub fill2010real() > Dim i As Long > i = 1 > Do Until Cells(i

Re: $$Excel-Macros$$ Help My "Do Loop" statement doesn´t work

try this Sub fill2010real() Dim i As Long i = 1 Do Until Cells(i, 2).Value = "Total" Cells(i, 1).Value = "2010 Real" i = i + 1 Loop End Sub On Thu, Jul 14, 2011 at 5:39 AM, Jorge Marques wrote: > Hi guys, i have this table where i want to fill the column A with "2010 > Real" but stopping when

Re: $$Excel-Macros$$ HELP urgent

You Can use conditinoal formatting On Wed, Jul 13, 2011 at 4:05 PM, Jorge Marques wrote: > Hi friend, i don´t understand exactly what you want, but if you want to > highlight the entire row that has the negative numbers like this, or do you > want it to copy to another column the year and negati

RE: $$Excel-Macros$$ HELP urgent

@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: Wednesday, July 13, 2011 4:05 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ HELP urgent Hi friend, i don´t understand exactly what you want, but if you want to highlight the entire

Re: $$Excel-Macros$$ HELP urgent

Hi friend, i don´t understand exactly what you want, but if you want to highlight the entire row that has the negative numbers like this, or do you want it to copy to another column the year and negative value? Year Cash Available 2002 0 1983 6.71 1995 23.75 1994 21.06 2007 -11 2009 20 2011 29

RE: $$Excel-Macros$$ HELP urgent

Please attach a sample file with more explaination.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Puneet Jain Sent: Wednesday, July 13, 2011 12:45 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ HELP urgent Guys Need Help.

Re: RE: RE: $$Excel-Macros$$ Help with formula

oops sorry, 291log -- -- 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=1871

RE: RE: $$Excel-Macros$$ Help with formula

Can you mail the sheet password back ? De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Bob Envoyé : dimanche 10 juillet 2011 20:57 À : excel-macros@googlegroups.com Objet : Re: RE: $$Excel-Macros$$ Help with formula Here is the file. On the Quote

RE: $$Excel-Macros$$ Help with formula

Please attached Some Data with More Specification.. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Bob Sent: Sunday, July 10, 2011 6:28 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help with formula =IF(A30="","",SUM(C3:C25)*ROUNDUP

Re: $$Excel-Macros$$ Help Required Urgent :)

Thanks a lot Ashish its working perfectly Regards, Rakesh. On Fri, Jul 8, 2011 at 10:54 AM, ashish koul wrote: > add this code to new workbook and run the macro and choose the csv file > > Option Compare Text > > > > Sub swa() > > Application.ScreenUpdating = False > Application.DisplayAlerts =

RE: $$Excel-Macros$$ Help regarding bank statment

See if it help, Use this in L2 =OFFSET(INDEX(F:F,MATCH(K2,F:F,0),1),COUNTIF(F:F,K2)-1,-4,1,1) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Friday, July 08, 2011 11:06 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel

Re: $$Excel-Macros$$ Help regarding bank statment

*hi LK modi use this simpler formula =LOOKUP(2,1/(A1:A10=A2),B1:B10) file is attached *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Fri, Jul 8, 2011 at 10:56 AM, harsh shah wrote: > HOPE THIS MIGHT BE USEFUL.

Re: $$Excel-Macros$$ Help regarding bank statment

HOPE THIS MIGHT BE USEFUL. On 8 July 2011 10:09, L.K. Modi wrote: > Dear Members, > > Thanks for your valuable support. I have an querry in which i have to check > interest calculation for banks. > > Me attaching a sheet in which column A have date that is in different > format. and in column B

Re: $$Excel-Macros$$ Help regarding bank statment

hi check the attachment see if it helps On Fri, Jul 8, 2011 at 10:09 AM, L.K. Modi wrote: > Dear Members, > > Thanks for your valuable support. I have an querry in which i have to check > interest calculation for banks. > > Me attaching a sheet in which column A have date that is in different

Re: $$Excel-Macros$$ Help Required Urgent :)

add this code to new workbook and run the macro and choose the csv file Option Compare Text Sub swa() Application.ScreenUpdating = False Application.DisplayAlerts = False Dim s As Workbook Dim i, j, k As Long Set s = Workbooks.Open(Application.GetOpenFilename) j = 1 For i = 1 To s.Sheets(1).Ra

Re: $$Excel-Macros$$ Help on Chart

l apply filter in Pivot table it will Show Only Filter Summary > Data, > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Atul Kesaria > Sent: Thursday, July 07, 2011 1:18 PM > To: excel-macros@googlegroup

RE: $$Excel-Macros$$ Help on Chart

Sent: Thursday, July 07, 2011 1:18 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on Chart Hello Team, I think i was not very clear on my request. Please find attached excel sheet in which there is main data on sheet 1 and on the basis of which I have prepare chart on sheet 6.

Re: $$Excel-Macros$$ help regarding date formula

hi, the betterr is   =DATE(YEAR(C4),MONTH(C4)+1,5) because he wants 'next month' 5th. R.Karunanithi --- On Thu, 7/7/11, ashish koul wrote: From: ashish koul Subject: Re: $$Excel-Macros$$ help regarding date formula To: excel-macros@googlegroups.com Date: Thursday, July 7, 2011

Re: $$Excel-Macros$$ help regarding date formula

Hi,    u use this     =DATE(YEAR(C4),MONTH(C4)+1,5)and drag the fill handle down till c4 is not blank. u will get what u want.   R.Karunanithi. --- On Thu, 7/7/11, L.K. Modi wrote: From: L.K. Modi Subject: $$Excel-Macros$$ help regarding date formula To: excel-macros@googlegroups.com Date: Th

RE: $$Excel-Macros$$ Help on Chart

See if it help -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Atul Kesaria Sent: Thursday, July 07, 2011 12:11 PM To: excel-macros Cc: atul.kesaria Subject: $$Excel-Macros$$ Help on Chart Hello Team, I am preparing chart basis

Re: $$Excel-Macros$$ Help on Chart

*hi atul dynamic chart preparation can help have a look link below http://chandoo.org/wp/2009/02/12/make-a-dynamic-chart-using-data-filters/ *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 12:11

Re: $$Excel-Macros$$ Help on Chart

chart only represent the data of visible cells if you hide any rows or will apply filter it will show the data of visible cells only check the attachment choose any name u will see the chart will automatically change if it is not working as per the default setting . http://office.microsoft.com

Re: $$Excel-Macros$$ help regarding date formula

*ok sir *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 11:44 AM, L.K. Modi wrote: > THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS > > > REGARDS > LKMODI > > On Thu, Jul 7, 2011

Re: $$Excel-Macros$$ help regarding date formula

THANKS A LOT MY PROBLEM IS SOLVED NOW BY THESE VALUABLE MEMBERS REGARDS LKMODI On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote: > Dear Members, > > Me attaching a sheet which relates to Excise duty payment.The result should > be 5 of the next of the month of Invoice.We are currently doing it

Re: $$Excel-Macros$$ help regarding date formula

* hi L K modi use this formula in d4 =EOMONTH(C4,0)+5 *Have A Nice Time & Enjoy Life Regards: CMA Ankur Pandey (Someone Different) I'm not the best but i'm not like the rest~~ On Thu, Jul 7, 2011 at 11:29 AM, Rajan_Verma wrote: > *Use this in D4* > > *=DATE(YEAR(C4),MONTH(C4)+1,5)* > > * * >

RE: $$Excel-Macros$$ help regarding date formula

Use this in D4 =DATE(YEAR(C4),MONTH(C4)+1,5) From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of L.K. Modi Sent: Thursday, July 07, 2011 10:26 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ help regarding date formula Dear Members, Me

Re: $$Excel-Macros$$ help regarding date formula

use this=DATE(YEAR(C4),MONTH(C4),5) On Thu, Jul 7, 2011 at 10:25 AM, L.K. Modi wrote: > Dear Members, > > Me attaching a sheet which relates to Excise duty payment.The result should > be 5 of the next of the month of Invoice.We are currently doing it > manually. But is there any formula b

RE: $$Excel-Macros$$ Help for Excel query

Use =max(A1:C1) in D1 -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of satish Sent: Wednesday, July 06, 2011 2:32 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Help for Excel query Hi, I want to compare Colum A , B anc

Re: $$Excel-Macros$$ Help for Excel query

HI,     APPLY THE MAX FORMULA AT A4 AND CLICK THE FILL HANDLE AND DRAG.    =MAX(A2:C2)   DOUBTS IF ANY CONTACT. -R.KARUNANITHI --- On Wed, 7/6/11, satish wrote: From: satish Subject: $$Excel-Macros$$ Help for Excel query To: "MS EXCEL AND VBA MACROS" Date: Wednesday, July 6, 2011, 2:31 AM Hi,

Re: $$Excel-Macros$$ Help for Excel query

try the attchement On Wed, Jul 6, 2011 at 2:31 AM, satish wrote: > Hi, > > I want to compare Colum A , B anc C > > for ex. > > > A BMOQ > 21 1 - Select - A > 1 2 10 - Select - MOQ > 24 1 - Select - B > > Basically I want to pick most best selling colu

Re: $$Excel-Macros$$ Help Urgent Please

its Not working getting the wrong emaild id s Hi Ashish the formula which u have provieded its working somewht but "out 10 geeitn the id for 2 employees id " Thanks, On Tue, Jul 5, 2011 at 10:48 PM, PRAVESH KUMAR wrote: > HI, > i think solved your quetions. > otherwise revert me. > Regards > Pra

Re: $$Excel-Macros$$ help me urgent

Next* > > * * > > *End Sub* > > * * > > * * > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *ashish koul > *Sent:* Tuesday, July 05, 2011 2:17 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re

Re: $$Excel-Macros$$ Help Urgent Please

hope you will get most of ids from these formula's c2 = VLOOKUP(LEFT(A2,FIND(" ",A2)-1)&"*",B:B,1,0) d2 = VLOOKUP("*"&RIGHT(A2,LEN(A2)-FIND("~",SUBSTITUTE(A2," ","~",LEN(A2)-LEN(SUBSTITUTE(A2," ",""),B:B,1,0) On Tue, Jul 5, 2011 at 9:58 PM, ICWAI Help wrote: > Search the employee name in

RE: $$Excel-Macros$$ help me urgent

f Next End Sub From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of ashish koul Sent: Tuesday, July 05, 2011 2:17 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ help me urgent try this http://akoul.blogspot.com/search/

Re: $$Excel-Macros$$ help me urgent

try this http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheets%20to%20sheet1%20in%20same%20workbook On Tue, Jul 5, 2011 at 11:12 AM, vijayajith VA wrote: > Hi, > > I have 30 to 40 excel sheets in one workbook..if i want to copy all the > excel sheet data in one sheet .

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

can you share the workbooks On Mon, Jul 4, 2011 at 9:44 PM, Jorge Marques wrote: > Mmm i checked the range, and everything is ok, even if i open the pivot > workbook and choose the source range again, it gives the same error when i > do refresh data :(, gives #NAME, and also on the list formulas

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

Mmm i checked the range, and everything is ok, even if i open the pivot workbook and choose the source range again, it gives the same error when i do refresh data :(, gives #NAME, and also on the list formulas appears #NAME. 2011/7/4 ashish koul > have you changed name of a name range used in th

Re: $$Excel-Macros$$ Help what the hell is wrong with my pivot table?

have you changed name of a name range used in the formula On Mon, Jul 4, 2011 at 9:23 PM, Jorge Marques wrote: > Hi guys, i have a pivot table that is feeded through another workbook, > then i calculate the rest of the pivot with the option "Calculated fields" > but i have a problem, each time i

Re: $$Excel-Macros$$ help

Thankyou very much sir I got it... On Sun, Jul 3, 2011 at 4:11 PM, vijayajith VA wrote: > HI Sir, > > I am unable to run the program...if i press f5 or run the program. it will > ask > > "Create macro " please see the attached sheet. > > > thankyou > > -- > >

RE: $$Excel-Macros$$ help

Function procedure can not be Run By F5 if they have any Arguments, they can only return a value on worksheet and to variable. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of vijayajith VA Sent: Sunday, July 03, 2011 4:12 PM To: excel-macros@googlegroups.

Re: $$Excel-Macros$$ help

workbook is not having any macro it contains UDF user defined function. write =vrate(b1) in d1 and then drag down the formula. it work like excel formula if you press alt + f11 and press on module 1 you can see the code Option Explicit Function vRate(iResult As Integer) As Variant Select C

Re: $$Excel-Macros$$ Help with saving files with path in cell B2

try this http://akoul.blogspot.com/search/label/Merge%20data%20from%20multiple%20sheet%20from%20multiple%20workbook%20to%20a%20workbook On Sun, Jul 3, 2011 at 11:33 AM, Nasim wrote: > Hi Ashish, > > First of all congrats! You are a big help to all of us :) > > Also, Thanks a lot for your hel

Re: $$Excel-Macros$$ Help with saving files with path in cell B2

Hi Ashish, First of all congrats! You are a big help to all of us :) Also, Thanks a lot for your help. you. I tweaked your code a bit and got it to work the way I needed. now I have another problem: I am combining files from different location into one sheet (a new workbook). The list of files t

RE: $$Excel-Macros$$ HELP

Dear Chandra Singh, I think you are very new to excel , this group will be more profitable for you, See if it help, From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Chandra Singh Bora Sent: Saturday, July 02, 2011 4:41 PM To: excel-macros@googlegroup

Re: $$Excel-Macros$$ Help with saving files with path in cell B2

try this select the folder in which files are saved Function SelectFolder(Optional Title As String, Optional TopFolder _ As String) As String Dim objShell As New Shell32.Shell Dim objFolder As Shell32.Folder Set objFolder = objShell.BrowseForFolder _ (0, Title, 1, TopFolder) If Not objFolder Is

Re: $$Excel-Macros$$ help req.

Correction: the macro shd be : Sub Insert2Rows() ' siti Vi / jakarta, 29 Jun 2011 '--- Dim RNG As Range, r As Long Set RNG = ActiveSheet.Cells(1).CurrentRegion.Offset(1, 0) For r = RNG.Rows.Count To 2 Step -1 *RNG(r, 1).Resize(2, 1).EntireRow.Inse

Re: $$Excel-Macros$$ help req.

use this code Sub InsertRows() Dim WkSht As Worksheet Dim Rng As Range Set WkSht = ThisWorkbook.Worksheets("Sheet1") For x = 2 To WkSht.Range("A65536").End(xlUp).Row If WkSht.Range("A" & Trim(Str(x))) <> "" Then Application.StatusBar = "Inserting Rows on Row : " & Trim(Str(x + 1)) WkSht.Rang

Re: $$Excel-Macros$$ help req.

Sub Insert2Rows() ' siti Vi / jakarta, 29 Jun 2011 '--- Dim RNG As Range, r As Long Set RNG = ActiveSheet.Cells(1).CurrentRegion.Offset(1, 0) For r = RNG.Rows.Count To 2 Step -1 If r Mod 2 > 0 Then RNG(r, 1).Resize(2, 1).EntireRow.Insert Next En

Re: $$Excel-Macros$$ Help Formating a dynamic table just some cells

good, i tried this way, but i don´t like the results because it´s hard to define the last row to format Sub tabela() ' ' tabela Macro ' ' Range("A7").Select Range(Selection, Selection.End(xlToRight)).Select With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Co

Re: $$Excel-Macros$$ Help Formating a dynamic table just some cells

did u try Range("A1048576").end(xlup).row '-- to get the last populated row in column A On Mon, Jun 27, 2011 at 3:58 PM, Jorge Marques wrote: > > Hi guys i need your expertise, i have this macro and i need your advise, i > just need to format the excel like i put in the example to format the

Re: $$Excel-Macros$$ Help on Percentile Function

Dear Prashant, Please look below links... http://www.techonthenet.com/excel/formulas/percentile.php http://office.microsoft.com/en-us/excel-help/percentile-HP005209211.aspx *Best Regards,* *Venkat* * * On Mon, Jun 20, 2011 at 6:16 PM, Prashant wrote: > Dear Experts, > > ** ** > > Need he

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Hari, U can use this simple UDF. Public Function CommonNumbers(Rng1 As Range, Rng2 As Range) Fc = "" For x = 1 To Len(Rng1.Value) src = Mid(Rng1.Value, x, 1) If InStr(Fc, src) = 0 Then Fc = Fc & src End If Next x For x = 1 To Len(Rng2.Value) src = Mid(Rng2.Value,

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Hari, Please find the attached file. Thanks & Regards Anil Kumar 113784 On Sun, Jun 19, 2011 at 10:33 PM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP > THANKS IN ADVANCE.. > > HARI > > -- > > -

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hi Try =IF(COUNTIF(B:B,A2)>0,A2,"") Thanks Mahesh On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE HELP > THANKS IN ADVANCE.. > > HARI > > -- > > --

Re: $$Excel-Macros$$ HELP NEEDED FOR FORMULA

Hari, Find attached *Best Regards,* *Venkat* * * *Join My Group: http://groups.google.com/group/excel-miracle * On Mon, Jun 20, 2011 at 11:03 AM, HARI NAIR wrote: > I WANT YOUR VALUE HELP TO PUT A FORMULA IN THE ATTACHED SHEET. PLEASE

RE: $$Excel-Macros$$ HELP: Macro to PARSE Lines of Data

Hello, Try : Sub test1() Dim Enrgt As String Close #1 Close #2 mypath = "d:\donnees\daniel\mpfe\" 'files path, please change Open mypath & "RPTbamCommon Maintenance201106061432493.txt" For Input As #1 Open mypath & "Output.txt" For Output As #2 Do While Not EOF(1) Line Input #1,

Re: $$Excel-Macros$$ Help with Excel macro

i guess you want to create addin in excel check the link below http://www.ozgrid.com/VBA/excel-add-in-create.htm On Wed, Jun 8, 2011 at 2:13 AM, programmernovice wrote: > Hello, I need to an Excel macro that will click a button on the > toolbar. A drop-down menu appears and then I need to make

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

;>> >>> >>> *From:* excel-macros@googlegroups.com [mailto: >>> excel-macros@googlegroups.com] *On Behalf Of *karan 1237 >>> *Sent:* Thursday, June 02, 2011 4:21 PM >>> >>> *To:* excel-macros@googlegroups.com >>> *Subject:* Re

Re: $$Excel-Macros$$ Help on macro to next empty worksheet to another workbook

It worked perfectly:), 1000 thanks Mahesh 2011/6/1 Mahesh parab > Hi > > Try : > > Sub Test() > Dim ws As Worksheet > Sheets("Brands").Select > Sheets("Brands").UsedRange.Copy > Windows("Comparsheet.xls").Activate > For Each ws In Worksheets > If ws.UsedRange.Cells.Count < 1 Then ws.Delete >

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

>> >> >> *From:* excel-macros@googlegroups.com [mailto: >> excel-macros@googlegroups.com] *On Behalf Of *karan 1237 >> *Sent:* Thursday, June 02, 2011 4:21 PM >> >> *To:* excel-macros@googlegroups.com >> *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

On Behalf Of *karan 1237 > *Sent:* Thursday, June 02, 2011 4:21 PM > > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!! > > > > Thnx a lot Rajan but I want one more thing that is it possible to make > input box character l

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

t; > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of *Vishal Gupta > *Sent:* Wednesday, June 01, 2011 8:05 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$ !HELP : URGENT !!! > > > > *Dear кαя

Re: $$Excel-Macros$$ Help! Filtering/subtotal issue in Excel2007

Hi See the attached file apply pivot table on the data, like what i have done & see the grand total. which have 3 in subtotal that is the person you want. Regards, Deepak On Thu, Jun 2, 2011 at 10:17 AM, Rajan_Verma wrote: > See if it help > > -Original Message- > From: excel-macros@g

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

Thnx for this vishal but I dnt wnt to prtect sheet as you think I want to protect sheet in different way. I hope you'v seen that excel file which I'v attached. I made a combo box & I want to protect it like : I chose a name from combobox like Dharmendra mishra & now I want that when I choose name

RE: $$Excel-Macros$$ Help! Filtering/subtotal issue in Excel2007

See if it help -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sarah Seager Sent: Thursday, June 02, 2011 2:49 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Help! Filtering/subtotal issue in Excel2007 I'm not too sure i

Re: $$Excel-Macros$$ Help on macro to next empty worksheet to another workbook

Hi Try : Sub Test() Dim ws As Worksheet Sheets("Brands").Select Sheets("Brands").UsedRange.Copy Windows("Comparsheet.xls").Activate For Each ws In Worksheets If ws.UsedRange.Cells.Count < 1 Then ws.Delete Next ws Application.DisplayAlerts = True Set ws = Worksheets.Add(After:=Sheets(Sheets.Count)

Re: $$Excel-Macros$$ !!!!!HELP : URGENT !!!!!!!

*Dear кαяαηη,* *Greetings for the day!!!* *to protect your sheet or workbook go to review pane in office 2007, then protect sheet, then limit of protection. by doing this u can protect ur project with a password.* ** Regards Vishal Gupta On Wed, Jun 1, 2011 at 3:58 PM, karan 1237 wrote: > > H

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

Dear Kaushik, I am having a small doubt pertaining to your solution given for transpose formula. When i look into the sheet, the claim no. 1 shows the Amount of 10, 10, 50 & 20 was been given. But as per your formula, the Amount of 10, 30 & 20 has got transpose to the Claim NO.1. Where as Amount R

Re: $$Excel-Macros$$ Help -Extract data from one file to onother file

Hi Seti, Thanks for responce but i know that formula but i need here vba code for same. On 5/20/11, STDEV(i) wrote: > (1) > Array formula: > > =SMALL(IF(('[Row data.xlsx]Sheet1'!$D$3:$D$105>=C2)* > ('[Row data.xlsx]Sheet1'!$D$3:$D$105<=C3),ROW(1:103)),ROW(1:103)) > > (2) > Formula > =IF(ISERR($

RE: $$Excel-Macros$$ Help on Transpose Function based upon criteria

Check this one it will help you http://en.kioskea.net/forum/affich-132961-vlookup-find-value-3-4-5-etc Regards,Anil Bhange IP Phone - 512320 | Mobile - 90290 32123 From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of KAUSHIK SAVLA Sent: Wednesday, May

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

*Array Formula, written in 9 cells (oneRow Range) at once !* =IFERROR(TRANSPOSE(INDEX($B$3:$B$11,SMALL(IF($A$3:$A$11=$C16,ROW($1:$9)),ROW($1:$9,"") On Wed, May 18, 2011 at 5:36 PM, KAUSHIK SAVLA wrote: > Hi All, > > I want to transpose certain data from row to column if meets specific > cri

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

hatts o.. On Wed, May 18, 2011 at 8:19 PM, NOORAIN ANSARI wrote: > Dear Kaushik, > > see if it help > > On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA wrote: > >> Hi All, >> >> I want to transpose certain data from row to column if meets specific >> criteria: eg >> Whole d

Re: $$Excel-Macros$$ Help on Transpose Function based upon criteria

Dear Kaushik, see if it help On Wed, May 18, 2011 at 4:06 PM, KAUSHIK SAVLA wrote: > Hi All, > > I want to transpose certain data from row to column if meets specific > criteria: eg > Whole data is as below: > Claim No. Amount > 1 10 > 2 20 > 1

Re: $$Excel-Macros$$ Help Needed - Copy & paste data for dynamic data_need Excel Macro Solution

Sub ests() Dim i As Long Dim j, s As Long For i = 1 To Sheets(1).Range("a65356").End(xlUp).Row If Sheets(1).Cells(i, 1).Value = "" Then j = i + 1 i = i + 2 End If If Sheets(1).Cells(i, 1).Value <> "" Then Sheets(2).Range("b65356").End(xlUp).Offset(1, 0).Value = Sheets(1).Cells(j, 1).Value End If

Re: $$Excel-Macros$$ help me

Hi =ROUNDUP(5284/12,1) = 440.4 =ROUNDDOWN(440.4*12,0) = 5284 -- *Thanks & Regards Thamu * On Mon, May 16, 2011 at 11:57 AM, memonkavi wrote: > Dear sir > > thanks 1nz again wat i requst that result i got from ur formula.,i > want to reverse for example i multiple 440.04 by 12 then i got the

Re: $$Excel-Macros$$ help me

Dear sir thanks 1nz again wat i requst that result i got from ur formula.,i want to reverse for example i multiple 440.04 by 12 then i got the result on excel itz (5280.48) bt i wnt the answer as 5284 how can i get it? regards kavi On May 15, 9:32 pm, Rajesh Naharwal wrote: > Hi Dear, > > Use th

Re: $$Excel-Macros$$ help me

thanks oflot Rajesh Nahawal! kavi On May 15, 9:32 pm, Rajesh Naharwal wrote: > Hi Dear, > > Use this formula, > > =roundup(5284/12,1) > > *Rajesh Naharwal > > On 15 May 2011 19:27, memonkavi wrote: > > > > > > > > > > > Dear Sir > > > This is my problem > > > one cartoon 12  boxes > > I have 44

Re: $$Excel-Macros$$ help me

thanks alot rajan verma!! kavi On May 15, 9:10 pm, rajan verma wrote: > Use minus Sign before your formula... > > > > > > > > > > On Sun, May 15, 2011 at 7:27 PM, memonkavi wrote: > > > Dear Sir > > > This is my problem > > > one cartoon 12  boxes > > I have 440 cartoon 4 boxes > >        cart

Re: $$Excel-Macros$$ help me

Hi Dear, Use this formula, =roundup(5284/12,1) *Rajesh Naharwal On 15 May 2011 19:27, memonkavi wrote: > > Dear Sir > > This is my problem > > one cartoon 12 boxes > I have 440 cartoon 4 boxes >cartoon 440x12=5280 >boxes4 > >

Re: $$Excel-Macros$$ help me

Use minus Sign before your formula... On Sun, May 15, 2011 at 7:27 PM, memonkavi wrote: > > Dear Sir > > This is my problem > > one cartoon 12 boxes > I have 440 cartoon 4 boxes >cartoon 440x12=5280 >boxes4 > > 5284/12=440.33

Re: $$Excel-Macros$$ HELP SECOND MAIL

Hi Mahesh, firslty thanks for your great favour it is working fine but some times it happen to ask the path2 name i created one folder with dump and created one sub folder as Working then i placed the Before After Entry sheets dump.xls , Global Company Code List .xls in both dump folder and sub

Re: $$Excel-Macros$$ Help needed in macro.

i would like say thanks for new tips for me i haven't tried it as if now i am doing it through formula "IF" itself however to automate this work if possible could help me to write a macro. On 5/10/11, ashish koul wrote: > see if it helps > > On Tue, May 10, 2011 at 12:13 PM, Born to Win wrote:

Re: $$Excel-Macros$$ HELP SECOND MAIL

sorry for confusing will cut short all the steps . i will send the recorded code , i have prepared it using Macro recording can anyone please edit that code will send today end of the day. Thanks for your help in advance. Regards, Prathima On Mon, May 2, 2011 at 1:49 PM, Mahesh parab wrote: >

Re: $$Excel-Macros$$ help Please

Dear Mahesh, May i know how this is possible. I want to learn it. Thanks in advance. Regards, Saroj. On Tue, May 3, 2011 at 10:58 PM, Mahesh parab wrote: > Hi > check attach, whether its as per u r requirement > > On Tue, May 3, 2011 at 8:29 PM, m7md.gmail wrote: > >> all, >> please i need

RE: $$Excel-Macros$$ Help with formula

Hi, One way to do it would be: -Find the last cell in your data (eg A1000) -Multiply that cell's row number by 2 (eg 2000) -Paste that cell's data into the cell with the doubled row number (eg A2000) -Clear that cell (ie A1000) -Decrement the row by 1 (ie A999) -Loop to step 2 Regards - Dave.

Re: $$Excel-Macros$$ help Please

Hi check attach, whether its as per u r requirement On Tue, May 3, 2011 at 8:29 PM, m7md.gmail wrote: > all, > please i need help to solve my problem > > if there cell i give it red color in another cell record the date whose i > colored 1st cell - if there any function make this > > > ** > * >

Re: $$Excel-Macros$$ HELP SECOND MAIL

Hi it would be great if u could explain some steps; it seems confusing, keep it as simple as you can; which is the first step, what are the 6 vlookups ? which workbook contain base data of your pivot. On Mon, May 2, 2011 at 10:07 AM, Prathima R wrote: > Hi Experts, > > > Due size constance i a

Re: $$Excel-Macros$$ Help in Access

lto:talk2mar...@gmail.com] > Sent: 02 May, 2011 5:13 PM > To: excel-macros@googlegroups.com > Cc: Prashant > Subject: Re: $$Excel-Macros$$ Help in Access > > Hi Prashant, > > Find the attachment... I hope that it will bring unmatch as per your new > tables... > >

RE: $$Excel-Macros$$ Help in Access

Subject: Re: $$Excel-Macros$$ Help in Access Hi Prashant, Find the attachment... I hope that it will bring unmatch as per your new tables... Code: SELECT Lanpos.Match FROM Lanpos LEFT JOIN Bank ON Lanpos.[Match] = Bank.[Match] WHERE (((Bank.Match) Is Null)) UNION SELECT Bank.Match FROM Bank LEFT

Re: $$Excel-Macros$$ Help required in average if - Excell 2003

OPEN AND RUN THE FILE ANYTHING NEED CONDUCT ME j.mOTHILAL vELLORE On Sun, May 1, 2011 at 2:34 AM, N.Shivkumar wrote: > It is easy in exel2007. Kindly show how the same is to be worked in excel > 2003 > Thanx in advance > > > > N.SHIVKUMAR > Mobile : +919422613567 > Office : +912332301775 > A

Re: $$Excel-Macros$$ Help in Access

Hi Prashant, Find the attached file.. I hope this will fulfill your requirement... We can arrive it with help of union query by using following SQL codes. SELECT Bank.card, Bank.aut, Bank.amt FROM Bank LEFT JOIN lanpos ON Bank.[card] = lanpos.[card] WHERE (((lanpos.card) Is Null)) UNION SELECT la

Re: $$Excel-Macros$$ help macro commands need -reg

http://www.ozgrid.com/ http://www.excel-vba.com/excel-vba-contents.htm http://www.webandmacros.net/excel-macros-vba.htm On Fri, Apr 29, 2011 at 7:55 PM, jmothilal wrote: > Dear any one > > i want to learn macro commands ,

<    4   5   6   7   8   9   10   11   12   13   >