Re: $$Excel-Macros$$ copy paste in reverse order

Dear Amit, you can also try through VBA.. Sub reverse_order() Dim i, rw As Integer rw = Cells(Rows.Count, "A").End(xlUp).Row For i = 1 To rw Cells(i, "B").Value = Cells((rw + 1) - i, "A") Next i End Sub See attached sheet. On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU) wrote: > Hi, > >

$$Excel-Macros$$ checkbox query

Dear experts I have attached an excel file containing data of qualification. On the userform I created check boxes with similar to the datasheet data. I need action like, only the tickmarked check box data only shown on the data sheet all other have to go in hidden mode (even in print also). wa

Re: $$Excel-Macros$$ copy paste in reverse order

Hi, PFA. =OFFSET($A$1,ROW($A$20)-ROW(),0) Regards, MARIES. On Mon, Mar 19, 2012 at 8:52 PM, Rajan_Verma wrote: > See the attached File > > ** ** > > =INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1) > > ** ** > > Rajan. > > ** ** > > *From:* excel-macros@googlegroups.com [mailto: > e

RE: $$Excel-Macros$$ Macro to hide rows, print, unhide rows runs very slow - how to speed up?

Hi Mel, No need to select any ranges. You are not printing based on the selection, so it's irrelevant. Here are a few things you could try: 1. Hide the rows without looping. (Beware though that any method that hides rows will force those rows and their dependencies to be recalculated in E

RE: $$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

Hi Howard, No worries :) Ask as many questions as needed. Best to send your replies to the list though, so you get the benefit of other replies (if only because I may not have time to reply myself). This also allows other VBA learners can benefit from the conversation. A defined name (eithe

$$Excel-Macros$$ Macro to hide rows, print, unhide rows runs very slow - how to speed up?

I have a macro that will hide unused rows in a spreadsheet, print the active sheet, then unhide the rows. Spreadsheet is from cell A1 to P175. Base info is recorded in various cells on rows 1 to 4. Cells 5 to 16 display output. The main Data input starts in cell A18 to G 167. A18 is a fr

RE: $$Excel-Macros$$ Need help with VBAfor Excel naming and using column names for looping

I think I misunderstood your need. I thought you wanted the name to stay with the data, allowing you to insert columns and have the name still refer to the same data. This method does that. If you want the name to stick to the column/range reference without regard to inserted columns (always

RE: $$Excel-Macros$$ last copied item in windows clipboard

Hi Divaker, If you mean the last two things copied within Excel, and you want to identify them from VBA, Take a look at http://www.mrexcel.com/forum/showthread.php?t=167292 Keep in mind that the commandbar containing the Office Clipboard's name varies by Excel version. Here's how I think it goe

Re: $$Excel-Macros$$ Consolidate Two Weekly Reports into a Summary Report

Don, That was what I was hoping for, but when I click the button, it dulpicates some of the entries. Is it me or the macro? Thank you. John On Mon, Mar 19, 2012 at 1:30 PM, dguillett1 wrote: > See attached which works for as many sheets as you may have after the > summary sheet. It uses a

Re: $$Excel-Macros$$ Rank Formula required

Hi Pankaj PFA, Try : =RANK(E2,E$2:E$9)+SUMPRODUCT(--(E$2:E$9=E2),--(A2 wrote: > Shorter. Also enter using CSE (ctrl+shift+enter) > > =COUNTIF($F$2:$F$9,">"&F2)+**SUM(IF(F2=$F$2:F2,1,0)) > > > > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > -Original Messag

RE: $$Excel-Macros$$ Replace letters with numbers

=CODE(UPPER(A1))-64 A1 contains your letter Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Mon/2012 01:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace letters with numbers Hi, Try it,

RE: $$Excel-Macros$$ Replace letters with numbers

=CODE(UPPER(A1))-64 A1 contains your letter Rajan From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Maries Sent: Mar/Mon/2012 01:46 To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Replace letters with numbers Hi, Try it,

RE: $$Excel-Macros$$ copy paste in reverse order

See the attached File =INDEX($A$1:$A$20,COUNTA($A$1:$A$20)-ROW()+1,1) Rajan. From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Amit Desai (MERU) Sent: Mar/Mon/2012 06:03 To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ copy paste in rever

Re: $$Excel-Macros$$ copy paste in reverse order

Hi Amit, Try Transpose Option on Paste special..if Helps.. *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Mar 19, 2012 at 6:02 PM, Amit Desai (MERU) wrote: > Hi, > > ** ** > > Is there any formula to copy data from sa

Re: $$Excel-Macros$$ last copied item in windows clipboard

Hi Divakar, Copy data twice You will get Clipboard..You Can see Last Second Copied Data. [image: Inline image 1] *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Mar 19, 2012 at 5:23 PM, Divaker Pandey wrote: > Hi Expert

Re: $$Excel-Macros$$ Query (Remove duplicate)

Hi Karan, Try Advanced filter and select Unique records..And you can Copy and paste it in New Column.. [image: Inline image 1] *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Mon, Mar 19, 2012 at 1:07 PM, Karan Singh wrote: >

Re: $$Excel-Macros$$ Exl at expert level

Hi Maries, Nice Collections... *Best Regards,* *Venkat * *Chennai* *My Linked in profile * On Sun, Mar 18, 2012 at 1:53 PM, Maries wrote: > Hi, > > *Check below Weblinks.* > > *MVP's* *Web Link* Alan Beban > http://home.pacbell.net

RE: $$Excel-Macros$$ Re: Error while running macro

Hi Noorain Sir, If I write xlExcel7 instead of 51, the macro is running but the some part of disclaimer in the report are missing in output and if I ok in below screen shot then it is running properly. ActiveWorkbook.SaveAs FileName:=path, FileFormat:=51 Please can you advise on the same. Reg

Re: $$Excel-Macros$$ Re: Error while running macro

Dear Shrinivas, Check below link http://office.microsoft.com/en-us/excel-help/use-office-excel-2010-with-earlier-versions-of-excel-HA010342994.aspx On Mon, Mar 19, 2012 at 7:51 PM, Chidurala, Shrinivas < shrinivas.chidur...@citi.com> wrote: > ** > Divaker, > > I am facing the below error while

Re: $$Excel-Macros$$ Re: Error while running macro

Hi Don, Still i am facing the same problem. Regds Shrinivas On Mar 19, 7:35 pm, "dguillett1" wrote: > If xl2003, > tools>options>security>  remove > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > From: Chidurala, Shrinivas > Sent: Monday, March 19, 2012 9:21

Re: $$Excel-Macros$$ Consolidate Two Weekly Reports into a Summary Report

Dear John, See attached sheet..hope it help to you. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Mon, Mar 19, 2012 at 8:30 PM, John A. Smith wrote: > I ne

Re: $$Excel-Macros$$ Consolidate Two Weekly Reports into a Summary Report

Don, Thank you for such a quick response. I like the formula and will analyze it until I understand every part of it. The problem with this approach is the projects are actually names and therefore a clean list would have to be manually sorted to eliminate duplicates and then pasted into Column

Re: $$Excel-Macros$$ Consolidate Two Weekly Reports into a Summary Report

One possible formula to use vlookup if there is a match. See att =IF(ISNA((MATCH($J4,'Week One'!$A:$A,0))),0,VLOOKUP($J4,'Week One'!$A$2:$C$118,2,0))+IF(ISNA((MATCH($J4,'Week Two'!$A:$A,0))),0,VLOOKUP($J4,'Week Two'!$A$2:$C$118,2,0)) Don Guillett Microsoft MVP Excel SalesAid Software dguille...

Re: $$Excel-Macros$$ Re: Error while running macro

If xl2003, tools>options>security> remove Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Chidurala, Shrinivas Sent: Monday, March 19, 2012 9:21 AM To: excel-macros@googlegroups.com Subject: RE: $$Excel-Macros$$ Re: Error while running macro Divaker, I am facin

RE: $$Excel-Macros$$ Re: Error while running macro

Divaker, I am facing the below error while running macro. Please can you advise on the same. [cid:685132014@19032012-07C1] Regards, Shrinivas From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Divaker Pandey Sent: Monday,

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Hi Noorain, Congratulations Thanks for helping us always. Regards, Kaushik -- 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 q

$$Excel-Macros$$ copy paste in reverse order

Hi, Is there any formula to copy data from say 2 rows say 1 & 2 & paste them in reverse order. Data of 1st row will move to 2nd & of 2nd row to first.. Best Regards, Amit Disclaimer: This message and its attachments contain confidential information and may als

Re: $$Excel-Macros$$ VALUE ERROR PROBLEM

THANKS CHIEF On Mon, Mar 19, 2012 at 12:03 PM, NOORAIN ANSARI wrote: > Hi Hilary, > You can also use > =IFERROR(IF(A13="","",E13-D13),"") > or > =IF(ISERROR(IF($A14="","",$E14-$D14))," ",IF($A14="","",$E14-$D14)) > > See attached sheet. > On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey wrote: >

$$Excel-Macros$$ Re: last copied item in windows clipboard

Hello Pandey, If you are using excel 2007 or later , you can use Clipboard CTRL+C pressed twice. On Monday, March 19, 2012 1:53:08 PM UTC+2, Divaker Pandey wrote: > > Hi Expert, > > Can anyone give me a hint to findout last and second last copied item. > > > Divaker > -- FORUM RULES (986+

$$Excel-Macros$$ last copied item in windows clipboard

Hi Expert, Can anyone give me a hint to findout last and second last copied item. Divaker -- 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

Re: $$Excel-Macros$$ VALUE ERROR PROBLEM

Thanks both for your help, On Mon, Mar 19, 2012 at 10:24 AM, Shaik Waheed wrote: > Hi Hilary, > > Enter the below formula in F13 and drag it down > > =IF(OR(A13="",D13=""),"",E13-D13)) > > HTH, > Waheed > On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey wrote: > >> Hello Expert >> >> in the atta

$$Excel-Macros$$ Re: Most Helpful Member Feb'12 - Noorain Ansari

Hi Noorain, Congrats On Mar 15, 3:49 am, Ayush Jain wrote: >  Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consistent contributor t

Re: $$Excel-Macros$$ VALUE ERROR PROBLEM

Hi Hilary, Enter the below formula in F13 and drag it down =IF(OR(A13="",D13=""),"",E13-D13)) HTH, Waheed On Mon, Mar 19, 2012 at 3:24 PM, hilary lomotey wrote: > Hello Expert > > in the attached file, when i select from the drop down list in cell B8, i > get a value error in column F (colored

Re: $$Excel-Macros$$ Re: Error while running macro

can u write what error you got. or you can also send screen-shot of error Divaker On Mon, Mar 19, 2012 at 3:30 PM, SHREE wrote: > > > On Mar 15, 3:48 pm, "Chidurala, Shrinivas " > wrote: > > Hi > > > > I am facing the below error while running below macro. Please can you > advise on the same.

$$Excel-Macros$$ Re: Error while running macro

On Mar 15, 3:48 pm, "Chidurala, Shrinivas " wrote: > Hi > > I am facing the below error while running below macro. Please can you advise > on the same. > > Thank you for your help ! > > Sub Convert_HTML_to_Excel() > > Application.ScreenUpdating = False > > Dim fldpth As String > Dim fld, fil As

$$Excel-Macros$$ VALUE ERROR PROBLEM

Hello Expert in the attached file, when i select from the drop down list in cell B8, i get a value error in column F (colored yellow). i want a formula that will give me the correct value in column F when the value in column D under periodic withdrawals is blank. kindly note however that if i sel

Re: $$Excel-Macros$$ Replace letters with numbers

Hi, Also try below code for your quary, Sub numeric() Dim MyCell As Range For Each MyCell In Selection.Cells MyCell.Value = Asc(UCase(MyCell)) - 64 Next End Sub Code On Mon, Mar 19, 2012 at 12:15 PM, Maries wrote: > Hi, > > Try it, > > > =CONCATENATE(IF(LEN(A1)>=1,CO

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

Dear Brother, Heartily congratulation to you. Really feeling proud to be your friend. Keep it up. On Mon, Mar 19, 2012 at 1:45 PM, NOORAIN ANSARI wrote: > My heartly thanks to all of you. > > On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > >> Hello Everyone, >> >> Noorain Ansari has bee

Re: $$Excel-Macros$$ Replace letters with numbers

Hi, Try it, =CONCATENATE(IF(LEN(A1)>=1,CODE(LEFT(A1,1))-64,""),IF(LEN(A1)>=2,CODE(MID(A1,2,1))-64,""),IF(LEN(A1)>=3,CODE(MID(A1,3,1))-64,""),IF(LEN(A1)>=4,CODE(MID(A1,4,1))-64,""),IF(LEN(A1)>=5,CODE(MID(A1,5,1))-64,""),IF(LEN(A1)>=6,CODE(MID(A1,6,1))-64,""),IF(LEN(A1)>=7,CODE(MID(A1,7,1))-64,""),

Re: $$Excel-Macros$$ Most Helpful Member Feb'12 - Noorain Ansari

My heartly thanks to all of you. On Thu, Mar 15, 2012 at 4:19 AM, Ayush Jain wrote: > Hello Everyone, > > Noorain Ansari has been selected as 'Most Helpful Member' for the month of > Feb'12 > He has posted 156 posts in Feb'12 and helped many people through his > expertise. He has been consisten

$$Excel-Macros$$ Replace letters with numbers

I am using Excel 2007 I have a list of single letters A to F in column H2 to H26 These letters are are mixed but only one capital letter per cell I want to go to this list and replace each letter by its numerical value. So A becomes 1, B becomes 2, C becomes 3 and so on to the letter F Can you p

Re: $$Excel-Macros$$ Query (Remove duplicate)

Dear Karan, Please use below code.. Dim i, j As Integer Application.ScreenUpdating = False For i = 1 To Range("A65536").End(xlUp).Row For j = 1 To Range("B65536").End(xlUp).Row If Range("A" & i).Value = Range("B" & j).Value Then Range("B" & j).Delete Shift:=xlUp End If Next j Next i Application.S

Re: $$Excel-Macros$$ Exl at expert level

Really this link will pay more to each excel user. Excellent collection ! Divaker On Mon, Mar 19, 2012 at 12:32 PM, NOORAIN ANSARI wrote: > Good Collections Maries.. > > and you also follow excel macro group on regular basis. > > -- > Thanks & regards, > Noorain Ansari > **

Re: $$Excel-Macros$$ Query (Remove duplicate)

Go to data- remove duplicates Krishnan Sent on my BlackBerry® from Vodafone -Original Message- From: Karan Singh Sender: excel-macros@googlegroups.com Date: Mon, 19 Mar 2012 13:07:52 To: Reply-To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Query (Remove duplicate) Dear Al

Re: $$Excel-Macros$$ Exl at expert level

Good Collections Maries.. and you also follow excel macro group on regular basis. -- Thanks & regards, Noorain Ansari *http://noorainansari.com/* *http://excelmacroworld.blogspot.com/* On Sun, Mar 18, 2012 at 1:30 PM,