Re: $$Excel-Macros$$ Automatic insert of row at each change in particular data

Dear Vaibhav, Please select required range and run this code.. Sub InsertRows_Vaibhav() Dim InsQuan As Integer On Error Resume Next InsQuan = InputBox("Enter number of rows to insert", "Your Call") If InsQuan <= 0 Then MsgBox "Invalid number entered", vbCritical, "Stop!" Exit Sub End If Applicati

$$Excel-Macros$$ Code for range shifting based on month

Dear all, I have a spreadsheet containing daily customer transaction data. I have used SUMIF to find out the monthly customer transaction data. However, it is tedious to copy the formula and paste for next month when next month comes. Can anyone suggest any VBA code / idea to help shifting the

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Dear Rajan Congratulation brother. :) On 5/3/12, Maries wrote: > *Congrats Brother.* > > On Wed, May 2, 2012 at 8:15 PM, xlstime wrote: > >> Congratulation Rajan >> >> On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: >> >>> Hello Everyone, >>> >>> Rajan Verma has been selected as

$$Excel-Macros$$ Congrats Rajan ......

Congrats Rajan .. bhayee -- 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. 2) Don't

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congrats Rajan.. On Thu, May 3, 2012 at 10:58 AM, Maries wrote: > *Congrats Brother.* > > > On Wed, May 2, 2012 at 8:15 PM, xlstime wrote: > >> Congratulation Rajan >> >> On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: >> >>> Hello Everyone, >>> >>> Rajan Verma has been selected as

Re: $$Excel-Macros$$ Automatic insert of row at each change in particular data

Hi, Try it, Sub insertrows() Dim i As Long On Error Resume Next For i = Cells(Rows.Count, "A").End(xlUp).Row To 2 Step -1 Cells(i, "A").EntireRow.Insert Next i End Sub Regads, MARIES. On Wed, May 2, 2012 at 10:36 PM, vaibhav joshi wrote: > Hi i wanted to insert a row between cell A1 & A2 at

Re: $$Excel-Macros$$ Automatic insert of row at each change in particular data

Hi i wanted to insert a row between cell A1 & A2 at each change in column A text On Thu, May 3, 2012 at 10:39 AM, Maries wrote: > *Can you share sample file...* > > > On Wed, May 2, 2012 at 9:58 PM, vaibhav joshi wrote: > >> Dear all >> >> I am having a sheet ,which contains data of various p

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

*Congrats Brother.* On Wed, May 2, 2012 at 8:15 PM, xlstime wrote: > Congratulation Rajan > > On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: > >> Hello Everyone, >> >> Rajan Verma has been selected as 'Most Helpful Member' for the month of >> April'2012 >> He has posted 185 posts in

Re: $$Excel-Macros$$ Automatic insert of row at each change in particular data

*Can you share sample file...* On Wed, May 2, 2012 at 9:58 PM, vaibhav joshi wrote: > Dear all > > I am having a sheet ,which contains data of various parties. > I want to insert row at each change in party name automatically ,whether > it can be done automatically or i have to make it manually

$$Excel-Macros$$ Automatic insert of row at each change in particular data

Dear all I am having a sheet ,which contains data of various parties. I want to insert row at each change in party name automatically ,whether it can be done automatically or i have to make it manually Regards Vaibhav -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise,

Re: $$Excel-Macros$$ Need rank formula

Dear Don guillet/Kris. Thank u so much for your reply. Don guillet i have a doubt for the same query that i want rank from month of jan'09 to apr'12.so what i have to do .Plz reply On Wed, May 2, 2012 at 8:21 PM, Kris wrote: > Hi, > > PFA. > > Kris > > -- > FORUM RULES (986+ members already BAN

Re: $$Excel-Macros$$ Help required on how to create iterative formula

If you want to calculate for a different net amount (m) just put the new value in the cell at the top marked "Target". All the calcs will then change. You can also change (h) if required but if you change any of the other formulas the whole exercise has to be reworked. On 3 May 2012 13:49, Milin

Re: $$Excel-Macros$$ Help required on how to create iterative formula

Thanks David. It is working. Though I am still trying to understand algebra :) Just one more query : as data input value will change the formula will also change , right ? Regards, Milin On Thu, May 3, 2012 at 4:54 AM, David Grugeon wrote: > Hi Milin > > I attach a revised version with worki

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congratulation Rajan On Wed, May 2, 2012 at 9:30 PM, Ayush Jain wrote: > Hello Everyone, > > Rajan Verma has been selected as 'Most Helpful Member' for the month of > April'2012 > He has posted 185 posts in April 2012 and helped many people through his > expertise. He has been consistent contrib

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congrats Rajan .. On Wed, May 2, 2012 at 2:21 PM, ChilExcel wrote: > Congratulations Rajan, a great contribution to the forum > Thanks also for your patience and help > > A hug! > Chilexcel from Chile > > 2012/5/2 Asa Rossoff > >> Congratulations Rajan, you're very generous with your

Re: $$Excel-Macros$$ Find differences between four columns.

Sorry Verma,,i had messed up everything here.Got confused with the requirement. What i want actually is to find out the differences between the FIRST table with Receipt No & Amt and SECOND table with Receipt No & Amt. Example: The receipt no 1151881 in Master data is 4500 It should match the

Re: $$Excel-Macros$$ Find differences between four columns.

Getting error bhayy..please correct. On Thu, May 3, 2012 at 12:59 AM, Rajan_Verma wrote: > ** ** > > *Wanna Use VBA?? > > * > > See the attached Sheet.. You can A*dd record dynamically* in second table > Try this ; > > Sub GetUnMatchedValueonNewSheet() > > > > Dim ArrTabl

RE: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi Pascal, I'm glad you found the problem (specifying the whole path with Getfile) With late binding you don't need to set a library reference. If you don't set a library reference, the constants aren't defined. You can easily verify the values of the constants in the immediate window like

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congratulations Rajan, a great contribution to the forum Thanks also for your patience and help A hug! Chilexcel from Chile 2012/5/2 Asa Rossoff > Congratulations Rajan, you're very generous with your time and expertise! > > > Asa > > ** ** > > *From:* excel-macros@googlegroups.c

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Oops my mistake, Set f = fs.GetFile("y:\test2.txt") I didn't specify the path, nothing related to flash memory and else...just that msdn used "filename" to declare the path+file variable and I got confused,to me filename means filename not file path...since the getfile method is linked to thef

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

The msdn link here OpenAsTextStream Method I deleted my previous post just to make a few changes as English is not my first language and I was even confused reading a last time after posting. -- FORUM RULES (986+ members already BA

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi Asa, I don't think there is any issues with constant, undefined variable types or else, i do use option explicit for each module... I use late binding for library references. The code that doesn't work is from msdn OpenAsTextStream Method. I don't see any mistake I could have made. If yes t

Re: $$Excel-Macros$$ NAND memory flash-drive, writing from Excel to a text file

Hi Asa, > I don't think there is any issues with constant, undefined variable types or else, i do use option explicit for each module... I use late binding for library references. The code that doesn't work is from msdn OpenAsTextStream Method

RE: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congratulations Rajan, you're very generous with your time and expertise! Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ayush Jain Sent: Wednesday, May 02, 2012 9:01 AM To: excel-macros Subject: $$Excel-Macros$$ Rajan verma : Most Helpful Member- A

RE: $$Excel-Macros$$ Find differences between four columns.

Hi, I think it is already highlighting Receipt number with different amount.. I mean which amount against same receipt number is not matching in first table, Do you want to highlight the receipt number in first table also?? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: exce

Re: $$Excel-Macros$$ Find differences between four columns.

A small correction for my requirement please i need to highlight those receipt nos which had different amounts..Verma bhayya...formula ko change karona please taaki,Receipt nos with different amounts highlight hue to color kardena thanks a lot for the help On Thu, May 3, 2012 at 12:21

Re: $$Excel-Macros$$ Find differences between four columns.

thanks for the speedy reply sir..how about using VBA for finding the differences between the columns and pasting them(only the DIFFERENT ones-Receipt no & amount which are not matched to a new sheet one down the other... On Thu, May 3, 2012 at 12:08 AM, Mr excel wrote: > hi all, > i m in need

RE: $$Excel-Macros$$ Find differences between four columns.

If you want to highlight the unmatched Record you can put this formula in conditional formatting Please see the attached file Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Mr excel Sent: 03 May

RE: $$Excel-Macros$$ Find differences between four columns.

Use this in F2 and Drag where Result is False mean that record does't exist in first table =SUMPRODUCT(--($A$1:$A$8=D2)*--($B$1:$B$8=E2))=1 See the attached File Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.co

$$Excel-Macros$$ Find differences between four columns.

hi all, i m in need of help regarding finding the differences between four columns i.e. RECEIPT No & AMT. in sheet1 and RECEIPT No & AMT in sheet2.i would like to know the Formula which will highlight the differences between the two columns in both sheets. Receipt No Total Paid Receipt No Tota

$$Excel-Macros$$ POSITION:Java Developer; LOCATION:Cambridge, MA; DURATION:6 Months+

Hello, Hope you are doing fine!! Please review the requirement and let me know if you have any consultants for this opening .. If yes, Please forward resumes with contact details, rate, location ASAP to harrysingh7...@gmail.com .. *POSITION:Java Developer* *LOCATION:Cambridge, MA* *DURATIO

Re: $$Excel-Macros$$ Multi Combo Box

2012/5/2 Rajan_Verma > Hi Chandru > > Please find the attached sheet, you can use list validation for that.. > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > excel-macros@googlegroups.com] *On Behalf Of

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Good work Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sam Mathai Chacko Sent: Wednesday, May 02, 2012 11:40 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012 Congrats Cheetah Regards, Sam On Wed,

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congrats Cheetah Regards, Sam On Wed, May 2, 2012 at 10:04 PM, NOORAIN ANSARI wrote: > यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. > और अपनी तरक्की से छोटा कर दो आसमा के माप को. > हम दोस्तों की दुआए,छोड़े ना हरगिज़ साथ, > मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको. > > -- > Thanks & regards, > N

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

यूँ ही बरकरार रखो भाई अपने Expertise के छाप को. और अपनी तरक्की से छोटा कर दो आसमा के माप को. हम दोस्तों की दुआए,छोड़े ना हरगिज़ साथ, मेरे ओर से लाख-लाख बधाई, राजन बाबु आपको. -- Thanks & regards, Noorain Ansari www.noorainansari.com www.excelmacroworld.blogspot.com On Wed, May 2, 2012 at 9:30 PM,

Re: $$Excel-Macros$$ Rajan verma : Most Helpful Member- Apr'2012

Congrats Raj. Proud of you Sent from my BlackBerry® smartphone from Airtel Ghana -Original Message- From: Ayush Jain Sender: excel-macros@googlegroups.com Date: Wed, 2 May 2012 21:30:32 To: excel-macros Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Rajan verma : Most

$$Excel-Macros$$ Chart Not Overlapping

Hello Guru's i am trying to do a progress chart comparing Actuals to budgeted and for some strange reasons my chart is not over lapping as it should be.i have overlapped a 100% however the chart still seem to be separated. am i missing something? thanks -- FORUM RULES (986+ members already BANN

RE: $$Excel-Macros$$ Hiding Work Sheets

You just hide your worksheet and protect your workbook.. ATL +T + P + W Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Pradhan Sent: 02 May 2012 12:50 To: Excel Macros Subject: $$Excel-Macros$$

RE: $$Excel-Macros$$ Query.

Hi See the attached file Function DatedDiff(dtStart As Date, dtEnd As Date) As String Dim ArrStart Dim ArrEnd Dim ArrResult ArrStart = Array(Year(dtStart), Month(dtStart), Day(dtStart)) ArrEnd = Array(Year(dtEnd), Month(dtEnd), Day(dtEnd)) Ar

RE: $$Excel-Macros$$ Help on Changing code on Color Macro

Did you attached Wrong file ? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Jorge Marques Sent: 02 May 2012 15:36 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Help on Changing code o

Re: $$Excel-Macros$$ Need rank formula

Hi In G1 on sheet1 and copied across upto I1 =MATCH($A1&"|"&B2,Data!$A$2:$A$770&"|"&Data!$B$2:$B$770,0) In B3 and copied down and across, =INDEX(Data!$D$1:$BH$1,MATCH(LARGE(INDEX(Data!$D$2:$BH$771,G$1,),ROWS(B$3:B3)),INDEX(Data!$D$2:$BH$771,G$1,),0)) Both are array formulas. Kris -- F

Re: $$Excel-Macros$$ Multi Combo Box

Hello, Could you please help me on the attached file. Thanks in advance. Regards, Chandra Shekar B On Tue, May 1, 2012 at 3:39 PM, Rajan_Verma wrote: > *HI Chandru,* > > * * > > *File size will be very larege with 1000 controlls on worksheet.. I > suggest to use List Validation on each cell i

RE: $$Excel-Macros$$ Hiding Work Sheets

Hi Ashish, Workbook protection. http://spreadsheetpage.com/index.php/tip/spreadsheet_protection_faq1/ Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Pradhan Sent: Wednesday, May 02, 2012 12:20 AM To: Excel Macros Subject: $$Excel-Macros$$ Hi

$$Excel-Macros$$ Hiding Work Sheets

Hello I have an excel file with multiple worksheets. I need to hide many sheets in this file. However, only I should be able to "unhide" the "hidden" sheet. I did the following: Visual Basic Editor Double Click on the correct Project in the Explorer window Click on the required Sheet name T