Re: $$Excel-Macros$$ VLOOKUP HELP NEED

Thanks a lot On May 15, 2012 1:22 AM, "dguillett1" wrote: > Sub lookitup() > Dim c As Range > For Each c In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row) > c.Offset(, 1) = Columns("F").Find(c, LookIn:=xlValues, _ > LookAt:=xlWhole, SearchOrder:=xlByRows, _ > SearchDirection:=xlNext).**Offset

$$Excel-Macros$$ VBA Libraries

Hi Guyz, I want to learn about VBA libraries (For Eg: linking VBA to other programming languages like C/C++, writing/editing library functions etc). I have search a lot online, but couldn't find the exact source. Can any one share notes (if they have) or any online links? Regards Kumar -- FORU

Re: $$Excel-Macros$$ Require total timing

Hi, Try this formula,* =TEXT(B2-A2,"[h]:mm:ss")* * * * * On Mon, May 14, 2012 at 9:40 PM, Seraj Alam wrote: > Hi Expert, > > > I have attached sheet in which I need total time taken in column C, I have > applied formula but its not working properly. So please help me on this one. > > > -- > Than

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

*Hi Experts, Very good morning, Dear groups and experts, i have some data base which need to be created in userform, i have explained in the attached file. Please help me sort out this problem. Thanks in advance. * Thanks & Regards,* * *Deba Ranjan P*** -- FORUM RULES (986+ members already

$$Excel-Macros$$ Require total timing

Hi Expert, I have attached sheet in which I need total time taken in column C, I have applied formula but its not working properly. So please help me on this one. -- Thanks & Regards Seraj Alam *+91 989 130 1776* -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, acc

Re: $$Excel-Macros$$ Find differences in two worksheets.

Nice different approach verma...thanks a lot.is there any formula to do the same.i mean to find out the differences between the two sheets. -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Ne

$$Excel-Macros$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

These Youtube Videos my might Help http://youtu.be/nZfySb0FI8w - A VBA Formula Trick http://youtu.be/W82P4cxVK3M - Application.WorksheetFunction On Monday, May 14, 2012 4:23:28 AM UTC-6, Bullet wrote: > > > Hi All, > > Can anyone explain how to use Vlookup, Index, Match, Offset function in >

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Hi Sunny, I know it's one of those two. To help I need to know which one. Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sunny Kapoor Sent: Monday, May 14, 2012 1:04 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Printin

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Thanks a lot to all of you. On Mon, May 14, 2012 at 9:44 PM, Rajan_Verma wrote: > ** ** > > You can put the entire Formula in Evaluate Function of VBA > > ** ** > > *Range("A1").Value=Evaluate("=Vlookup(1, D1:D5,2,0)")* > > *Range("A1").Value=Evaluate("=Index(D1:E5,Match(1,D1:D5,0),2)")

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

@ Ranjan, thanks a lot for all of your effort, but it is not working properly, only 1st cell is working perfectly On Mon, May 14, 2012 at 9:35 PM, Rajan_Verma wrote: > See the attached Sheet > > ** ** > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* >

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

yes. Just like that. But , the macro doesn't print in colour. Sunny On Mon, May 14, 2012 at 10:00 PM, Asa Rossoff wrote: > Sunny, when you say "manually print in color" how do you do that? > > ** ** > > Do you click on Printer Settings or Page Setup to select that option? > > Asa >

RE: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Sunny, when you say "manually print in color" how do you do that? Do you click on Printer Settings or Page Setup to select that option? Asa From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Sunny Kapoor Sent: Monday, May 14, 2012 12:55 PM To: excel-mac

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Hmm, Well, do you think of something thats avoiding the macro from printing in colour?? Sunny On Mon, May 14, 2012 at 9:53 PM, dguillett1 wrote: > My ans was based on what you sent > > Don Guillett > Microsoft MVP Excel > SalesAid Software > dguille...@gmail.com > > *From:* Sunny Kapoor

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

My ans was based on what you sent Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Sunny Kapoor Sent: Monday, May 14, 2012 2:38 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel well, Thanks for y

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

Sub lookitup() Dim c As Range For Each c In Range("a2:a" & Cells(Rows.Count, 1).End(xlUp).Row) c.Offset(, 1) = Columns("F").Find(c, LookIn:=xlValues, _ LookAt:=xlWhole, SearchOrder:=xlByRows, _ SearchDirection:=xlNext).Offset(, -1) Next End Sub Don Guillett Microsoft MVP Excel SalesAid Software

RE: $$Excel-Macros$$ Need help-- Related to UDF

I had a typo in the Const line.. I seem to be getting sloppy lately! Here the function is, corrected: Function LookupSomething(LookupValue, TableArray) Const ColIndex = 3, RangeLookup = True LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray, ColIndex, RangeLookup) End Fun

RE: $$Excel-Macros$$ Need help-- Related to UDF

Hello Amol, Sounds like you are asking for something like this: Function LookupSomething(LookupValue, TableArray) Const ColIndex 3, RangeLookup = True LookupSomething = WorksheetFunction.VLookup(LookupValue, TableArray, ColIndex, RangeLookup) End Function Modify the Const line for the VLO

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

well, Thanks for your reply. However, the file is quite big with more than 25 sheets. I sent one sheet to give an example. Now, the file will be used by many people but everyone would be interested in different sheets. The problem i am facing currently, like you must have seen is, the macro print

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Based on the file you sent me with ONE sheet with graphs the easiest way would be to set up an additional printer with ONLY grayscale and call it bw or whatever and then print to that printer for bw and the other for color. Application.Dialogs(xlDialogPrinterSetup).ShowDon Guillett Microsoft MVP

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

tnks boss On Mon, May 14, 2012 at 5:44 PM, Seraj Alam wrote: > Hi > > You can below code also > > Sub change_sheetName() > Sheets(1).Activate > ActiveSheet.Name = "New Sheet" > End Sub > > > > > On Mon, May 14, 2012 at 4:42 AM, hilary lomotey wrote: > >> working Perfectly. thanks Maries >>

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

Hi Rajan, Can i get VBA code for this Thanks, Venkatesh. On Tue, May 15, 2012 at 12:13 AM, Venkatesh Narla wrote: > Thanks a lot... > > On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma > wrote: >> See the attached Solution >> With >> >> Index/Match() >> Lookup() >> >> >> Regards >> Rajan verma

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

Thanks a lot... On Mon, May 14, 2012 at 11:50 PM, Rajan_Verma wrote: > See the attached Solution > With > > Index/Match() > Lookup() > > > Regards > Rajan verma > +91 7838100659 [IM-Gtalk] > > -Original Message- > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

Thanks Aamir.. thanks. I can write simeple VBA code for this On Mon, May 14, 2012 at 11:45 PM, Aamir Shahzad wrote: > =OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1) > > Aamir Shahzad > > On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla > wrote: >> >> Hi All, >> I need help in Vlookup need formula.

RE: $$Excel-Macros$$ VLOOKUP HELP NEED

See the attached Solution With Index/Match() Lookup() Regards Rajan verma +91 7838100659 [IM-Gtalk] -Original Message- From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Venkatesh Narla Sent: 14 May 2012 11:30 To: excel-macros@googlegroups.com Subje

Re: $$Excel-Macros$$ VLOOKUP HELP NEED

=OFFSET($F$1,MATCH(A2,$F$2:$F$21,0),-1) Aamir Shahzad On Mon, May 14, 2012 at 11:00 PM, Venkatesh Narla wrote: > Hi All, > I need help in Vlookup need formula. > > "Hi All, > Column A has data; Column ""F"" is the range need E to pull" > > > 10001 #N/AA 10001 > 10002

$$Excel-Macros$$ VLOOKUP HELP NEED

Hi All, I need help in Vlookup need formula. "Hi All, Column A has data; Column ""F"" is the range need E to pull" 10001 #N/AA 10001 10002

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

Hi You can below code also Sub change_sheetName() Sheets(1).Activate ActiveSheet.Name = "New Sheet" End Sub On Mon, May 14, 2012 at 4:42 AM, hilary lomotey wrote: > working Perfectly. thanks Maries > > > On Mon, May 14, 2012 at 11:35 AM, Maries wrote: > >> Hi, >> >> It can be VBA T

RE: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

You can put the entire Formula in Evaluate Function of VBA Range("A1").Value=Evaluate("=Vlookup(1, D1:D5,2,0)") Range("A1").Value=Evaluate("=Index(D1:E5,Match(1,D1:D5,0),2)") Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-

Re: $$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Send me your file and tell me your excel version. I’ll look a bit later. When you say give the user an option to print. What do you mean. Be VERY specific. What I did will should do it for each sheet in the file when it is printed. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gma

$$Excel-Macros$$ Re: Printing sheets in colour using VBA in ecel

Hello Don, Thanks for the reply. Actually, i ned to give the user an option to print the sheet if he/she wants. Also, the command ou provided does not work. The print out is still not coloured. let me know if you could suggest something else... Sunny On Monday, 14 May 2012 16:56:25 UTC+2, S

Re: $$Excel-Macros$$ Printing sheets in colour using VBA in ecel

Put this in the THISWORKBOOK module and delete your buttons. Now each sheet will print as desired. If you don’t want ALL sheets in the file then you can restrict by UN commenting lines Private Sub Workbook_BeforePrint(Cancel As Boolean) ‘if activesheet.name <> “dontdothisone” then ActiveShee

$$Excel-Macros$$ Printing sheets in colour using VBA in ecel

Hi Guys, I am trting to print sheets in colour using VBA. I am using the following code... Sub Print_sheet() With ActiveSheet .PageSetup.BlackAndWhite = False .PrintOut Copies:=1, Collate:=True End With End Sub _

$$Excel-Macros$$ Re: Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

you can use any Excel function in vba via Application.WorksheetFunction. Application.WorksheetFunction.VLookup(arg1,arg2,arg3,arg4) arg= parameters required in excel functions Application.WorksheetFunction.VLookup(range("A1").value,Range("B1:D7"),2,0) Best Regards, Anubhav On Monday, May 1

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Dear Indrajit range("A1").value = WorksheetFunction.VlOOKUP(lookup_value, table_array, col_index_num, [range_lookup) Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Mon, May 14, 2012 at 7:54 PM, ╰» ℓαℓιт мσαнη wrote: > Dear  Indrajit > > range("A1").value = WorksheetFun

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Dear Indrajit range("A1").value = WorksheetFunction.=VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup) same for the other formula Regards, Lalit Mohan https://www.facebook.com/buzinesstransformation On Mon, May 14, 2012 at 7:15 PM, Indrajit $nai wrote: > Thanks for the sugge

Re: $$Excel-Macros$$ Need help-- Related to UDF

Give a couple of examples of your vlookup formula(s) Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Amol Jadhav Sent: Monday, May 14, 2012 8:42 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Need help-- Related to UDF Hi Experts, I need your help

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Thanks for the suggestion.I know the formula, but how can I migrate those formulas with VBA Coding. On Mon, May 14, 2012 at 6:40 PM, Rajan_Verma wrote: > Hi > > *You can refer Excel Formula Help to understand how they work **J*** > > ** ** > > ** ** > > * * > > *Regards* > > *Rajan

Re: $$Excel-Macros$$ Passing Values Between UserForms

Thanks all for the resolution. YOu guyz are great. On Fri, May 11, 2012 at 10:13 PM, Rajan_Verma wrote: > Also can assign the value to a public variable if wanted to unload first > user form, > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk]* > > ** ** > > *Fro

Re: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

@ Ranjan, no attachment file available.can you please forward it once again. On Mon, May 14, 2012 at 6:18 PM, Rajan_Verma wrote: > Please find the attached Sheet > > *I have used Validation in that table* > > ** ** > > * * > > *Regards* > > *Rajan verma* > > *+91 7838100659 [IM-Gtalk

Re: $$Excel-Macros$$ Split Large Excel file to multiple excel files and possible save the files

Hi Couple of links you may find useful http://www.excelfox.com/forum/f12/split-unique-data-into-multiple-workbooks-33/ http://www.excelfox.com/forum/f2/split-data-into-multiple-workbooks-3-conditions-393/ Kris ExcelFox -- FORUM RULES (986+ members al

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

Hi Rajan, Thanks so much for the resolution. However I was looking for a Fuction rather than VBA code. On Mon, May 14, 2012 at 6:45 PM, Rajan_Verma wrote: > ** ** > > ** ** > > Try this: > > ** ** > > *Function WorksheetName(lngIndex As Long) As String* > > *If lngIndex <= ThisWorkbook.Work

RE: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

Try this: Function WorksheetName(lngIndex As Long) As String If lngIndex <= ThisWorkbook.Worksheets.Count Then WorksheetName = ThisWorkbook.Worksheets(lngIndex).Name End If End Function = WorksheetName(Row()) In A1 and Drag Regards Rajan verma +91 7838100659 [IM-Gtalk

RE: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Hi You can refer Excel Formula Help to understand how they work J Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 14 May 2012 3:53 To: excel-macros@googlegroups.com Subject: $

RE: $$Excel-Macros$$ urgently help required "how to get access field value into word table"

Can you please explain more with Example and attach your file? Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Dhartikumar Sahu Sent: 14 May 2012 12:59 To: excel-macros@googlegroups.com Subject: $$Exc

Re: $$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

I suggest you look in the vba help index for FIND and FINDNEXT. Find the value and then use offset to get data. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Indrajit $nai Sent: Monday, May 14, 2012 5:23 AM To: excel-macros@googlegroups.com Subject: $$Excel-Mac

RE: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

If all sheets have data in same format Sub CompileWOrksheets() Dim wksSheet As Worksheet With ThisWorkbook .Worksheets.Add.Name = "Compiled" For Each wksSheet In .Worksheets If wksSheet.Name <> "Compiled" Then wksSheet.UsedRange.Copy .Worksheets("Compi

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

Provide a file with an explanation and example. One or many?? Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: sreenivas kammari Sent: Monday, May 14, 2012 3:25 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Delete Zero subtotal blocks Hi, Is there

RE: $$Excel-Macros$$ Find differences in two worksheets.

Try this: Please remove Replace all error by 0 or other Characters with in Ranges before Compare Sub ShowDifferen() Dim Arr1 Dim Arr2 Dim rng1 As Range Dim rng2 As Range Dim lngRow As Long Dim intCol As Integer Set rng1 = Application.InputBox(

Re: $$Excel-Macros$$ hii i need copy a row to another based on condition

Provide a file with a complete explanation. I am a retired regional manager for ING and held a series 7 brokers license but have never heard of “nifty” stocks. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: coolguy Sent: Sunday, May 13, 2012 11:35 PM To: excel-mac

RE: $$Excel-Macros$$ How to calculate WPM (Word Per Minute) in Excel (Only for numeric keys)?

Please find the attached Sheet I have used Validation in that table Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Indrajit $nai Sent: 14 May 2012 4:17 To: excel-macros@googlegroups.com Subject: Re:

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

Not the BEST solution. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Shekhar Sharma Sent: Monday, May 14, 2012 7:16 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs Thanks guys, it got r

Re: $$Excel-Macros$$ Split Large Excel file to multiple excel files and possible save the files

You may send to my personal email with an example. If you need to email or print you shouldn’t need to create at file for each. Simply create a report for each or email each. Details of your NEED for a separate file.. Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From:

Re: $$Excel-Macros$$ Defining Same Name For ranges available in multiple tabs

Thanks guys, it got resolved with the suggestion of =SUMIF(sheet1!WBS,A1,sheet1!COST)+SUMIF(sheet2!WBS,A1,sheet2!COST)+SUMIF(sheet3!WBS,A1,sheet3!COST) ** ** On Sat, May 12, 2012 at 6:48 PM, dguillett1 wrote: > This is very possible with an indirect formula or defined names or with > a

Re: $$Excel-Macros$$ urgently help required "how to get access field value into word table"

Why is your request more urgent than other requests Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dhartikumar Sahu Sent: Monday, May 14, 2012 2:28 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ urgently help required "how to get access field v

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

working Perfectly. thanks Maries On Mon, May 14, 2012 at 11:35 AM, Maries wrote: > Hi, > > It can be VBA Try below code, > > Sub ShNmeChng() > Dim nme As String > nme = InputBox("Enter sheet name here...") > ActiveSheet.Name = nme > End Sub > > Regards, > > MARIES. > > On Mon, May 14, 2012 a

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

Hi, It can be VBA Try below code, Sub ShNmeChng() Dim nme As String nme = InputBox("Enter sheet name here...") ActiveSheet.Name = nme End Sub Regards, MARIES. On Mon, May 14, 2012 at 4:27 AM, hilary lomotey wrote: > EXCELLENT IT WORKED but i guess u cant change the sheet name with a > fo

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

EXCELLENT IT WORKED but i guess u cant change the sheet name with a formula On Mon, May 14, 2012 at 11:23 AM, Maries wrote: > Try it, > > =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename"))) > > > On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote: > >> the name of the c

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

Try it, =MID(CELL("filename"),FIND("]",CELL("filename"))+1,LEN(CELL("filename"))) On Mon, May 14, 2012 at 4:16 AM, hilary lomotey wrote: > the name of the current sheet into one of the cells -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Po

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

Hello Guys, is there any way to get the name of the current sheet into one of the cells WITHOUT vb code? 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 Prob

$$Excel-Macros$$ Vlookup, Index, Match, Offset function in VBA Coading!!!!!!!!

Hi All, Can anyone explain how to use Vlookup, Index, Match, Offset function in VBA Coading -- Indrajit Disclaimer: This electronic message and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you a

$$Excel-Macros$$ একটি নতুন সামাজিক আয়ের সাইট

বন্ধুরা আজকে আপনাদের সবাইকে একটি নতুন সামাজিক আয় করার সাইটের সাথে পরিচয় করিয়ে দিব। জেনে খুশি হবেন যে সাইটটি বাংলাদেশীদের এবং দারুন একটি সাইট। সাইটটি Facebook এবং Odesk এর সমন্বয়ে তৈরি করা। মানে হল আপনার এই সাইটটিতে Facebook এর মত করে নতুন বন্ধুর তৈরি করতে পারবেন আবার Odesk এর মত আয়ও করতে পারবেন

Re: $$Excel-Macros$$ Find differences in two worksheets.

PLs see attached file On Mon, May 14, 2012 at 7:49 AM, Mr excel wrote: > I want to know the differences between the two sheets.i.e. Main > worksheet(Master SHEET) and the Current Month(Apr'12) Worksheet. > > Please give me any formula or code for finding out the differences between > the two sh

$$Excel-Macros$$ Delete Zero subtotal blocks

Hi, Is there anyone help me please on the below one. If the subtotal value is zero..copy to those block to another sheet and delete the entire subtotal block. Thank you, Srini -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread ti

$$Excel-Macros$$ urgently help required "how to get access field value into word table"

hi group need urgently help required, to get ACCESS field value into word table. if any sample data that will also very helpful to me. -- *Regards,* *Dhartikumar Sahu* Sr.Database Manager - Institutional Equities * **IDBI Capital Markets Services Ltd* 5th Floor, Mafatlal Centre | Nariman

Re: $$Excel-Macros$$ Query for Merging two excel sheets using Command Prompt

Dear Rakesh, you can use following code Sub CommandButton1() Sheets("your sheet name").Select 'first sheet from you will copy the data Range(Selection, ActiveCell.SpecialCells(xlLastCell)).Select Selection.Copy Sheets("your sheet name").Select ' where you want to paste Selection.PasteSpecia