Re: $$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

Dear Noorian, I am quite thrilled when found the logo of your *CompareWorksheetsAdd-in.xla *different from the usual one. I have been trying to change logo of single file without success. Can you guide how can i put different logo for a couple of files in a folder to separate them by logo? Say fo

$$Excel-Macros$$Read column(s) and calculate currency on multiple target spreadsheets/worksheets

Hi all, I'm trying to build an Excel solution that would do the following: - User select a given spreadsheet/worksheet/column(sample below), where file location may vary and exchange rate column will vary (based on Month) - Allows target selection: User selects target spreadsheet(s) a

$$Excel-Macros$$ Re: Report Generation

Try Ms-Access. Put your data in a table and try the report wizard, which will guide you. If you still want the report in excel itself, it can be done using VBA coding. Send a sample file so that best approach can be decided based upon the quantity of data and compelxity of the report. Regards,

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Hi, Thanks a lot for the response. Regards Anu On Thu, Sep 8, 2011 at 11:10 PM, dguillett1 wrote: > Try using data>subtotal as shown on the attached for col D > > *From:* anu gomathi > *Sent:* Thursday, September 08, 2011 12:11 PM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $

Re: $$Excel-Macros$$ Crystal Reports for vba excel

Hi , See below links if Helps http://forums.esri.com/Thread.asp?c=93&f=992&t=67019 http://www.codeguru.com/forum/showthread.php?t=356836 *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Fri, Sep 9, 2011 at 10:42 AM, Shankar Bh

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Hi Bheema, See below image and Try Data Validation and use custom and formula as * =COUNTIF(C:C,C1)=1* [image: image.png] *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I

Re: $$Excel-Macros$$ Crystal Reports for vba excel

See below link if it help to u.. http://softwaretopic.informer.com/how-to-use-crystal-report-with-vba/ On Fri, Sep 9, 2011 at 10:42 AM, Shankar Bheema wrote: > Good morning to all, > > Is the crystal report software which will use for report generation in > Visual Basic 6 will work with VBA Exc

$$Excel-Macros$$ Crystal Reports for vba excel

Good morning to all, Is the crystal report software which will use for report generation in Visual Basic 6 will work with VBA Excel ? If so, I request to you all, provide me sample project to understand. -- -- Some

Re: $$Excel-Macros$$ problem with cell width in a workbook

is it possible to split the cell column into On Thu, Sep 8, 2011 at 6:05 PM, dguillett1 wrote: > NO can do. Cell width for the entire column must be the same. You can > merge cells but NO one suggests that so maybe format to WRAP and raise the > height of the row > > > *From:* Shankar Bheema

Re: $$Excel-Macros$$ Code to control the database not to accept repeated number

Dear Bheema, Please see attached Sheet... On Tue, Sep 6, 2011 at 8:10 PM, Bheema Shankar wrote: > I made a userform. linked it with the datasheet. the filenumber acts > as a bridge between userform and datasheet. I have to make the file > number unique in excel. Because the duplica

$$Excel-Macros$$ Loop Practice in VBA

Dear Group, Please find attached sheet, it is very usefull to understand Loop in VBA Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* -- --

Re: $$Excel-Macros$$ How to add command button in excel....

visit to this site: http://office.microsoft.com/en-us/excel-help/add-a-button-and-assign-a-macro-to-it-in-a-worksheet-HP010236676.aspx On Thu, Sep 8, 2011 at 11:55 PM, Madhukar wrote: > Hi all, > I'm new to VBA Programming. But how o add a command button in excel without > using form. > > -- -

Re: $$Excel-Macros$$ reference auto copy in shee2

Hi Sanjib, You Can try Advanced filter Option in 2007 *Best Regards,* *Venkat * *Chennai* *My Linked in profile * * * On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Good Morning Everybody, > > I wa

RE: $$Excel-Macros$$ Code to control the database not to accept repeated number

Use COUNTIF to check filenumber is unique : =COUNTIF(the filenumber column,filenumber)=0 Daniel -Message d'origine- De : excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] De la part de Bheema Shankar Envoyé : mardi 6 septembre 2011 16:40 À : MS EXCEL AND VBA MACROS Obje

$$Excel-Macros$$ Compare multiple tables - hopefully through a pivot table?

Thanks in advance, experts! What I have: 2 worksheets in same Excel file, each has a table (Table1 on WS1, Table2 on WS2) with the SAME headers/type of data. As an example (only), BOTH tables have: Invoice#Cat1SalesCat2SalesCat3Sales TotalSales The only difference is

Re: $$Excel-Macros$$ How to add command button in excel....

Dear Madhukar, Please tyr First step Check Excel Option->Popular-> Show Develper tab in the ribbon Next step : Developer-Insert-form Controls/Active X controls-Select Commond Button On Thu, Sep 8, 2011 at 10:25 PM, Madhukar wrote: > Hi all, > I'm new to VBA Programming. But how o add a

$$Excel-Macros$$ Need to populate the data from Pivot

Hi All, Please help me with macro to populate the data from the the pivot to the specific fields Regards Anu On Wed, Sep 7, 2011 at 3:17 PM, anu gomathi wrote: > Hi, >> >> Attached the File >> >> Regards >> >> Anu >> >> On Wed, Sep 7, 2011 at 12:25 PM, Abhishek Jain > >wrote: >> >> > Anu, >>

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Hi, Need to add the value from X to DO column. Regards Anu On Thu, Sep 8, 2011 at 6:11 PM, dguillett1 wrote: > Which columns need to be totaled? > > *From:* anu gomathi > *Sent:* Thursday, September 08, 2011 12:14 AM > *To:* excel-macros@googlegroups.com > *Subject:* Re: $$Excel-Macros$$

$$Excel-Macros$$ How to add command button in excel....

Hi all, I'm new to VBA Programming. But how o add a command button in excel without using form. -- -- Some important links for excel users: 1. Follow us on TWITTER for tips tricks and links : http://twitter.com/exce

Re: Fwd: $$Excel-Macros$$ Re: Marquee in Excel

NO From: suresh k Sent: Thursday, September 08, 2011 9:49 AM To: Excel group Subject: Fwd: $$Excel-Macros$$ Re: Marquee in Excel Hi All, Anyone is there to provide solution for this query.. Is it possible to work on other worksheet while markquee is there in sheet1. /suresh -- Forw

Re: $$Excel-Macros$$ calculating age with months

Dear varun, There is one more formula available. ="Age is "&DATEDIF(C8,TODAY(),"y")&" Years, "&DATEDIF(C8,TODAY(),"ym")&" Months and "&DATEDIF(C8,TODAY(),"md")&" Days" For Example:Age is 51 Years, 8 Months and 7 Days On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body gu

Re: $$Excel-Macros$$ calculating age with months

Dear varun, You can use below mentioned formulas.. =DATEDIF(C8,TODAY(),"y") =For Year =DATEDIF(C8,TODAY(),"ym") =For Month =DATEDIF(C8,TODAY(),"md") =For Days On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel w

Fwd: $$Excel-Macros$$ Re: Marquee in Excel

Hi All, Anyone is there to provide solution for this query.. Is it possible to work on other worksheet while markquee is there in sheet1. /suresh -- Forwarded message -- From: suresh k Date: Wed, Sep 7, 2011 at 10:39 PM Subject: Re: $$Excel-Macros$$ Re: Marquee in Excel To: raj

Re: $$Excel-Macros$$ calculating age with months

Hey Varun , thy this =DATEDIF(A1,TODAY(),"Y") & " Years, " & DATEDIF(A1,TODAY(),"YM") & " Months, " & DATEDIF(A1,TODAY(),"MD") & " Days" On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards

Re: $$Excel-Macros$$ calculating age with months

Use it ="Year "& DATEDIF(E7,F7,"y")& " Days "&DATEDIF(E7,F7,"d") On Thu, Sep 8, 2011 at 1:57 PM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards > > Varun Chawla > > -- > >

Re: $$Excel-Macros$$ Problem extracting data from multiple columns

Why cant i attach to this On Sep 5, 3:04 pm, "dguillett1" wrote: > Post a file > > > > -Original Message- > From: Andy McGooner > Sent: Monday, September 05, 2011 7:56 AM > To: MS EXCEL AND VBA MACROS > > Cc: amcni...@jaguarlandrover.com > Subject: $$Excel-Macros$$ Problemextractingd

Re: $$Excel-Macros$$ calculating age with months

Dear Varun, Try to use Datedif function, if you are familiar with it or just google it you will get the solution in seconds. On Thu, Sep 8, 2011 at 11:27 AM, VARUN CHAWLA wrote: > > > Can any body guide me the formula to calculate the Age in excel with months > and days. > > Regards > > Varun

Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row

Which columns need to be totaled? From: anu gomathi Sent: Thursday, September 08, 2011 12:14 AM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Add the multiple row values & delete the duplicate row Hi Noorain, Opportunity column contains the duplicate. I need to convert the r

$$Excel-Macros$$ JOB

*Experience:* 3 - 5 Years *Location:* Gurgaon *Compensation:* Rupees 6,00,000 - 8,00,000 *Education:* UG - Any Graduate - Any Specialization PG - Any PG Course - Any Specialization *Industry Type:* Banking/Financial Services/Broking *Role:* Analyst *Functional Area:* Banking, Insurance *Posted Date

$$Excel-Macros$$ JOB

*Experience:* 4 - 9 Years *Location:* Bengaluru/Bangalore *Education:* UG - B.B.A - Management,B.Com - Commerce PG - Any PG Course - Any Specialization,Post Graduation Not Required *Industry Type:* BPO/ITES *Role:* Finance Exec. *Functional Area:* Accounts, Finance, Tax, CS, Audit *Posted Date:* 02

Re: $$Excel-Macros$$ problem with cell width in a workbook

NO can do. Cell width for the entire column must be the same. You can merge cells but NO one suggests that so maybe format to WRAP and raise the height of the row From: Shankar Bheema Sent: Wednesday, September 07, 2011 11:33 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$

$$Excel-Macros$$ JOB

*Experience:* 4 - 8 Years *Location:* Noida *Compensation:* Rupees 1,75,000 - 2,00,000 *Education:* UG - Any Graduate - Any Specialization PG - Post Graduation Not Required *Industry Type:* IT-Software/ Software Services *Role:* Finance Exec. *Functional Area:* Accounts, Finance, Tax, CS, Audit Jo

Re: $$Excel-Macros$$ problem with duplication of data

I tried with this code. But it is not stopping the entry of the duplicate row with the same file number. file numbers may be given consequently 1,2,3 ., if we enter file number 1 for twice, it would fire msgbox that it already exists. pls provide solution On Wed, Sep 7, 2011 at 8:03 PM, m

$$Excel-Macros$$ JOB

*Experience:* 2 - 5 Years *Location:* Noida *Education:* UG - Any Graduate - Any Specialization,Graduation Not Required PG - Any PG Course - Any Specialization,Post Graduation Not Required *Industry Type:* IT-Software/ Software Services *Role:* Business Analyst *Functional Area:* IT-Other Job Desc

Re: $$Excel-Macros$$ reference auto copy in shee2

Dear Sanjib, Please see updated sheet.. On Thu, Sep 8, 2011 at 5:03 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Dear Friends, > > error message "will not take any arguments" > > > On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI > wrote: > >> Dear Sanjib, >> >> Another option,

Re: $$Excel-Macros$$ A Suggestion To Moderators....

its right. it would be better if the facility incorporates to the forum On Thu, Sep 8, 2011 at 5:02 PM, deepu wrote: > Hi, > > If it is in your reach than please think about this.. Most of the time > in a day I spend in my office, where I cannot access to Gmail but can > open Google Groups, when

Re: $$Excel-Macros$$ Re: blink the Label caption

Deepak ji I want to blink the text on the Label object on form initialize event. On Thu, Sep 8, 2011 at 11:04 AM, Deepak Pal Singh wrote: > It won't work... Just want to confirm whether do you want to blink your > text in a label or in cells...?? > > Regards > Deepak > > On Wed, Sep 7, 2011 at

Re: $$Excel-Macros$$ reference auto copy in shee2

Dear Friends, error message "will not take any arguments" On Thu, Sep 8, 2011 at 1:31 PM, NOORAIN ANSARI wrote: > Dear Sanjib, > > Another option, you record macro with short-cut key > and paste red color code > > Sub Macro10() > ' > ' Macro10 Macro > ' > ' Keyboard Shortcut:

$$Excel-Macros$$ A Suggestion To Moderators....

Hi, If it is in your reach than please think about this.. Most of the time in a day I spend in my office, where I cannot access to Gmail but can open Google Groups, whenever i get free time I try to solve queries posted by other members, sometimes I get solutions and sometimes not because of some

Re: $$Excel-Macros$$ pie chart -how to remove in chart

Well... The file is working fine in... you just need to save the workbook before you open it.. So select 'Save' option instead of 'Open' (to directly open the workbook), I've used dynamic ranges for charts, that might be the reason for why its not working... Best of Luck... :-) Regards Deepak On

Re: $$Excel-Macros$$ reference auto copy in shee2

Dear Sanjib, Another option, you record macro with short-cut key and paste red color code Sub Macro10() ' ' Macro10 Macro ' ' Keyboard Shortcut: Ctrl+r ' *If TypeName(Selection) = "Range" Then Selection.Copy Sheets("Sheet2").Range("A" & Sheets("Sheet2").UsedRange.Rows.Count +

Re: $$Excel-Macros$$ Conditional Formatting Excel 2007

OK, please see attachment. zp18 On Thu, Sep 8, 2011 at 2:22 PM, Venkat CV wrote: > Hi , > > See Below Links... > http://www.contextures.com/xlcondformat03.html\ > > http://www.dummies.com/how-to/content/applying-conditional-formatting-in-excel-2007.html > > *Best Regards,* > *Venkat * > *Chenna

Re: $$Excel-Macros$$ reference auto copy in shee2

Dear Sanjib, Please see attached sheet. On Thu, Sep 8, 2011 at 12:40 PM, Sanjib Chatterjee < chatterjee.kolk...@gmail.com> wrote: > Good Morning Everybody, > > I want to create a macro to copy the selected data from sheets1 to sheet2 > automatically > after

Re: $$Excel-Macros$$ Need some help in transposing data

Brother Noorain It good solution but make it some easiest solution instead of new user can write this type of complex formula. Thanks Tariq Aziz On 7 September 2011 21:10, NOORAIN ANSARI wrote: > Dear Nishant, > > Please see attached sheet.. > > > -- > Thanks & regards, > Noorain A