Re: $$Excel-Macros$$ Copy multiples tables from one worksheet to separate worksheets

Hi, Can you share Sample with group. On Wed, Dec 21, 2011 at 3:43 AM, 0 1 wrote: > I have an Excel worksheet containing many tables of data. Each table is > separated by a blank row followed by a table title (which is merged across > all 6 columns). (If it's helpful I can make these titles all

$$Excel-Macros$$ when I open any mail automatically save contacts

Message flagged Wednesday, 21 December 2011 11:13 AM Message Body Hello expert,  I have thousands of mail in many archive folders in Microsoft office outlook 2007. Is any function or VBA script to save all contacts when I open any mail automatically.   Regards LAKSHMAN -- FORUM RULES (934+ mem

Re: $$Excel-Macros$$ Re: Copy multiples tables from one worksheet to separate worksheets

Send your file Don Guillett SalesAid Software dguille...@gmail.com From: 0 1 Sent: Tuesday, December 20, 2011 4:29 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ Re: Copy multiples tables from one worksheet to separate worksheets I should add that these tables are not formatt

$$Excel-Macros$$ Re: Copy multiples tables from one worksheet to separate worksheets

I should add that these tables are not formatted as data tables. I suspect it would be easier to first format them as such (I need to do that at some point anyway, so a macro for that would also be handy. Once they're formatted as data tables, I can use the following macro to loop through each

$$Excel-Macros$$ Copy multiples tables from one worksheet to separate worksheets

I have an Excel worksheet containing many tables of data. Each table is separated by a blank row followed by a table title (which is merged across all 6 columns). (If it's helpful I can make these titles all start with a common word, like "Table," so "Table 1," "Table 2," etc.) The tables all h

Re: $$Excel-Macros$$ Fwd: Drop down list

Hello Ankit, Another way. See the attached. ___ HTH, Haseeb -- FORUM RULES (934+ 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 at

Re: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet

Please !! Thanks Rohan. -- FORUM RULES (934+ 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 po

Re: $$Excel-Macros$$ Searching Query

What you want can be done but why not just goto the db sheet and filter??? Don Guillett SalesAid Software dguille...@gmail.com From: SAJID MEMON Sent: Tuesday, December 20, 2011 10:15 AM To: Sundarvelan Natarajan Subject: $$Excel-Macros$$ Searching Query Dear Expert I want to make some search

Re: $$Excel-Macros$$ For Excel Beginner, please try this test...

Which test? On Mon, Dec 19, 2011 at 12:19 PM, Ravinder Negi wrote: > For Excel Beginner, please try this test...and enhance your > skills.. > > -- > FORUM RULES (934+ members already BANNED for violation) > > 1) Use concise, accurate thread titles. Poor thread titles, like Please > Help, Urge

Re: $$Excel-Macros$$ Need Help

Assumes xl2010. =WORKDAY.INTL(B6,A6,6,D1:D2) d1etc for holidays WORKDAY.INTL function Show AllHide AllReturns the serial number of the date before or after a specified number of workdays with custom weekend parameters. Weekend parameters indicate which and how many days are weekend days. Weekend

Re: $$Excel-Macros$$ APPLICABLE ACCOUNTING STANDARDS

Dear Vivek, I am based at Punjab. Do send me the requirements and I will try to help in whatever way I can. On Mon, Dec 19, 2011 at 8:49 AM, vivek wrote: > Dear Group Members, > > I am a practicing chartered accountant. In the accountancy world there are > many accounting standards which ar

Re: $$Excel-Macros$$ Help on isblank & iferror

Glad to help Don Guillett SalesAid Software dguille...@gmail.com From: Vijayendra Rao Sent: Sunday, December 18, 2011 11:52 PM To: excel-macros@googlegroups.com Subject: Re: $$Excel-Macros$$ Help on isblank & iferror Thanks Don Guillett and Aamir Shahzad for your support. The solutions was ve

Re: $$Excel-Macros$$ Financial Tools in excel.

2) Don't post a question in the thread of another member. A complete explanation with examples? Don Guillett SalesAid Software dguille...@gmail.com From: Mishra, Kailash (GE Capital, Non-GE) Sent: Monday, December 19, 2011 6:08 AM To: excel-macros ; rajanverma1...@gmail.com Subject: RE: $$Excel

Re: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet

Send file Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: Ometoon Sent: Monday, December 19, 2011 8:40 AM To: MS EXCEL AND VBA MACROS Subject: $$Excel-Macros$$ Lookup and summarize multiple values from another worksheet Hello, What I want the following

Re: $$Excel-Macros$$ APPLICABLE ACCOUNTING STANDARDS

Send a file along with this msg and a complete explanation with examples Don Guillett SalesAid Software dguille...@gmail.com From: vivek Sent: Sunday, December 18, 2011 9:19 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ APPLICABLE ACCOUNTING STANDARDS Dear Group Members, I am

Re: $$Excel-Macros$$ anil kumar wants to chat

This is a no no Don Guillett SalesAid Software dguille...@gmail.com -Original Message- From: anil kumar Sent: Tuesday, December 20, 2011 2:56 AM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ anil kumar wants to chat --

Re: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

maybe? Untested Sheets("PivotTable").Cells(2, 10).Value = format(sheets(“summary”).Cells(5, "C").End(xlDown).Offset(1, -2),”asdesired”) Don Guillett SalesAid Software dguille...@gmail.com From: NOORAIN ANSARI Sent: Tuesday, December 20, 2011 12:16 AM To: excel-macros@googlegroups.com Subject

Re: $$Excel-Macros$$ Re: Help On Print

Very very thanks for help On Mon, Dec 19, 2011 at 1:10 PM, Rohan wrote: > If you can replicate this for your own sheetwell and good. Else > send the worksheet over the group as an attachemnt and I will work > that out. !! Thank you ! > > > Sub Test() > Dim SDate As DateDim EDate As D

Re: $$Excel-Macros$$ Help on isblank & iferror

Thanks Don Guillett and Aamir Shahzad for your support. The solutions was very good and very quick. Regards, Vijayendra 2011/12/18 dguillett1 > =IF(A3="","",IFERROR(VLOOKUP(A3,Sheet1!$A:$A,1,0),"not recieved")) > > Don Guillett > SalesAid Software > dguille...@gmail.com > > *From:* Vijayend

Re: $$Excel-Macros$$ regarding addins in vba

Dear Vijay Can you help me out I Want to maintain database in Exce through VBA Programming. Can you suggest me about id Nishant Mobile09724055586 2011/12/17 NOORAIN ANSARI > Dear Vijay, > > Please try it > > file:///D:/VBA%20Training/Add-In/excel-add-in-create.htm > http://www.ozgri

RE: $$Excel-Macros$$ Financial Tools in excel.

Hi Expert, I have required these below mentioned PIN Code in one command in single raw IF City equal to Ahamadbad then Pin Code is 380001 Similarly for other city Pin Code Ahamadabad 380001 Delhi 110001 Bangalore 560001 Chennai 61 Mumbai 41 Pune 411001 Hy

$$Excel-Macros$$ Lookup and summarize multiple values from another worksheet

Hello, What I want the following: In sheet 1 in cell B2 and C2 I want the corresponding totalization of sheet 2 per calendar month. I do not know how I can put this into a formula, so I like someone to ask how I can establish this. PS: Ifyou need the corresponding example sheet I can forward thi

Re: $$Excel-Macros$$ Identify Button type

hello, I need a code for excel 2003 but I don't know how to upload my sheet. From: hanumant shinde To: Excel Group Sent: Sunday, December 18, 2011 6:22 AM Subject: $$Excel-Macros$$ Identify Button type Hi, How to find if the command button present on Excel

$$Excel-Macros$$ For Excel Beginner, please try this test...

For Excel Beginner, please try this test...and enhance your skills.. -- FORUM RULES (934+ 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

$$Excel-Macros$$ Re: Please help to convert tables from PDF to Excel.

Yes, I have tried so many programs like able2extract and stuff...I am glad I found PDF2XL. Sorry, I am just really excited, because it helped me save about 3 hours of my work!! -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread t

Re: $$Excel-Macros$$ shortcut key .

Alt+D+F+S Regards On Sun, Dec 18, 2011 at 10:47 AM, vijayajith VA wrote: > Sorry . that is for put filter and remove filter.i need to clear checked > items .in filtered coloumn. > > > On Sun, Dec 18, 2011 at 12:10 PM, Ms-Exl-Learner . < > ms.exl.lear...@gmail.com> wrote: > >> Alt+D+F+F >> >> ---

Re: $$Excel-Macros$$ MIS Opening

Dear Sir, Thanks for your suggestion... Regards Manoj On Mon, Aug 29, 2011 at 7:10 PM, Manoj Kumar wrote: > Dear Sir, > > Please find the attached CV in this mail, and revert for the same ASAP. > > Regards > Manoj Kumar > > > On 8/25/11, Rahul Gandhi wrote: > > I Have 2 Off-roll Opening with

Re: $$Excel-Macros$$ pls fill up this sheet with this pattern

Hi, Can you please be more specific? Can you give me an example of the output, like what are you expecting? Thanks, Amar On 19/12/2011, Sara Lee wrote: > i have two columns... zip code and the weights... i need to complete this > sheet . i.e zip codes with starting from 1001 to 9 should

Re: $$Excel-Macros$$ jpj file convert in excel file

a better explanation along with a url and what you want? Don Guillett SalesAid Software dguille...@gmail.com From: anil kumar Sent: Monday, December 19, 2011 11:20 PM To: excel-macros@googlegroups.com Subject: $$Excel-Macros$$ jpj file convert in excel file Hi friends, I need some help, I m t

Re: $$Excel-Macros$$ convert jpj in excel

Dear Laxman, Thanks for this excellent tool. This is awesome! Regards, Abhi On Tue, Dec 20, 2011 at 4:25 PM, Lakshman Prasad wrote: > Dear Anil, > > Like This ..? U want? means U want to convert a JPG file in xls..? > > > Regard > LAKSHMAN > > *From:* anil kumar > *To:* excel-macros@goo

Re: $$Excel-Macros$$ convert jpj in excel

sorry sir, I explain, I have some name and add. in hard copy and I have to print out lebal for post some doc. so i want to that scan that hard copy and convert in to excel file and forment that file according to lebal. so i will not have to type that data in excel. I thing now u understand. Thank

Re: $$Excel-Macros$$ convert jpj in excel

Hello anil,   U want to do self programming for this? or u can try attch. file already programed. From: anil kumar To: excel-macros@googlegroups.com Sent: Tuesday, 20 December 2011 4:34 PM Subject: Re: $$Excel-Macros$$ convert jpj in excel HI LAKSHMAN

Re: $$Excel-Macros$$ convert jpj in excel

HI LAKSHMAN, u r right I want to convert some jpg file into excel and modify according myself. Thanks -- FORUM RULES (934+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, an

Re: $$Excel-Macros$$ convert jpj in excel

hello sir, I have tryed many time but gat same result. like that file i m atteched below. -- FORUM RULES (934+ 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 w

Re: $$Excel-Macros$$ convert jpj in excel

Hello sir, Thanks for u r respons. I have tryed but same result. -- FORUM RULES (934+ 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 attent

Re: $$Excel-Macros$$ convert jpj in excel

Dear Anil, Once again try http://www.coolutils.com/Online-Excel-Converter.php# On Tue, Dec 20, 2011 at 2:29 PM, anil kumar wrote: > Hello every body, > > I m trying convert some jpj file into excel by ocr online.but i m not able > to convert. plz tell me were m i going wrong. > Plz find the

Re: $$Excel-Macros$$ Fwd: Drop down list

Dear Ankit, First create name range as per group name as i have created then... paste below formula in Data->Validation =INDIRECT(SUBSTITUTE($E$7,"-","_")) Note : As per naming convention its only accept Service_1 instead of Service-1 So please keep *_* instead of *-* during naming range

Re: $$Excel-Macros$$ Fwd: Drop down list

thank you sir, But how could I use it in another sheet. Regards, Ankit On Tue, Dec 20, 2011 at 3:25 PM, NOORAIN ANSARI wrote: > Dear Ankit, > > Please find attached Sheet, I hope it will help to you. > > > -- > Thanks & regards, > Noorain Ansari > *http://excelmacroworld.blogspot.com/*

Re: $$Excel-Macros$$ Fwd: Drop down list

Dear Ankit, Please find attached Sheet, I hope it will help to you. -- Thanks & regards, Noorain Ansari *http://excelmacroworld.blogspot.com/* *http://noorain-ansari.blogspot.com/* On Tue, Dec 20, 2011 at 1:09 PM, Anki

Re: $$Excel-Macros$$ Fwd: Drop down list

Hi, You can use Vlookup to get the result. If you can give ur example list with proper codes it will done. And in your drop down list ther are spaces after the name like "Admin ", so remove those extra spaces... Hope it solved your query. On Tue, Dec 20, 2011 at 1:09 PM, Ankit Agrawal wrote: >

$$Excel-Macros$$ anil kumar wants to chat

--- anil kumar wants to stay in better touch using some of Google's coolest new products. If you already have Gmail or Google Talk, visit: http://mail.google.com/mail/b-ed00186c8a-bc205b15b0-HJTs17g9CL5Q2gFJLre8IdRWfjo You'll nee

Re: $$Excel-Macros$$ Instead of using Isempty(), what other ways can be used for filling up the data

please check the below mentioned code Sub Macro_del() ' ' ' Keyboard Shortcut: Ctrl+q ' Selection.SpecialCells(xlCellTypeBlanks).Select Selection.EntireRow.Delete ActiveWindow.SmallScroll Down:=-15 End Sub On Tue, Dec 20, 2011 at 12:25 PM, Asa Rossoff wrote: > Hi Darwin, > Instead o