Re: $$Excel-Macros$$ unable to use advance vlookup

2012-05-21 Thread LAKSHMAN PRASAD
Hi Aamir,   Thanks   Is working, that’s what I exactly want to do.But Its better if we avoid extra column. I am able to avoid sheet “Subsidiary Ledger Trial Balance” Helpingcolumn but unable to avoid sheet “Sheet2” Helping column. Can you ………?   =VLOOKUP(A2,Sheet2!$A$2:$C$7493,3,0)  

Re: $$Excel-Macros$$ Form tracker and new base-1

2012-05-21 Thread Deba Ranjan
*Hi Anil and experts, Yes it working good. very very very thank you. you all are genius. i am feeling very guilty that i am unable to create such things (marcos coding). i have tried to learn form various website and books, but i am unable to code my self. i think i very fool on this. Please

$$Excel-Macros$$ REMOVE ME

2012-05-21 Thread Ashish Saxena
REMOVE ME Regards, Ashish Saxena The Cosmic Realtors 8586928623 9717111457 From: Shelly Murray lt;shelly.mur...@eamc.orggt; Sent: Sun, 20 May 2012 04:43:18 To: excel-macros@googlegroups.com lt;excel-macros@googlegroups.comgt; Subject: $$Excel-Macros$$ REMOVE ME Shelly Murray, PHR

$$Excel-Macros$$ Ashish Saxena -The Cosmic Realtors

2012-05-21 Thread Ashish Saxena
Hi Guys, I am into a real estate business.please contact me if you want to purchase any property in Delhi NCR. we will provide you the best rate as compare to the market. Also if you have any references than please give my number to them or their no. to me. My offices is as c-4, Sec-63,

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-21 Thread Shekhar Sharma
Welcome, your decision. However I would request you to allow Job openings related with Excel, VBA else Can we have our signatures include Searching for Job (in any of the member is looking for job)? Regards Shekhar Sharma On Sun, May 20, 2012 at 8:24 PM, Ayush Jain jainayus...@gmail.com wrote:

$$Excel-Macros$$ Drop down list

2012-05-21 Thread Smitha S R
Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I start entering P itself Pen and pencils

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

2012-05-21 Thread Anil Gawli
File attached FYI On Mon, May 21, 2012 at 1:50 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, I have a drop down list which is created using menu 'data validation'. Is it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item

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

2012-05-21 Thread Smitha S R
Hi, PFA the book with dropdown list prepared using data validation. Suggest whether it is possible in this also. (s it possible to get the items in the first line in the drop down while start entering the letters of the items. Eg: Item Pen, pencils, Notepad is there in my drop down list, if I

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

2012-05-21 Thread Anil Gawli
with data validation i don't think so, i have prepared in combo box control. Is it Ok? On Mon, May 21, 2012 at 3:53 PM, Smitha S R sperdwo...@gmail.com wrote: Hi, PFA the book with dropdown list prepared using data validation. Suggest whether it is possible in this also. (s it possible

$$Excel-Macros$$ How to distribute one value into different cells proportionately based on some conditions

2012-05-21 Thread Amit Gandhi
Hi Experts I am finding some problem in excel formula, pls help me here. I have a excel data at two locations, 1st is Supplier's Bill details and 2nd is Purchase order details. I need a formula that can distribute the Party Bill Amount figure proportionately to PO Amount figures based on B/L# .

$$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

2012-05-21 Thread renuka chari
Hi All Actually i need Export ladger data from tally in .htm format exported data saved in one perticular folder, then i need to send each individual file willbe sending to the individual receipitent Ex: xyz.htm file wilbe sending to the xyz customer and xyz2.htm file will be sending to the

$$Excel-Macros$$ Appropriate formula required

2012-05-21 Thread Dhanesh Verma
Dear Friends, In the attached list the total monthly allocations is more than the total amount to be allocated, please suggest a suitable formula to compute the same. R'gds Dhanesh -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles.

Re: $$Excel-Macros$$ Form tracker and new base-1

2012-05-21 Thread Bé Trần Văn
2012/5/21 Deba Ranjan drdeva...@gmail.com *Hi Anil and experts, Yes it working good. very very very thank you. you all are genius. i am feeling very guilty that i am unable to create such things (marcos coding). i have tried to learn form various website and books, but i am unable to

RE: $$Excel-Macros$$ REMOVE ME

2012-05-21 Thread Rajan_Verma
See the last line of Group Signature To unsubscribe, send a blank email to excel-macros+unsubscr...@googlegroups.com Regards Rajan verma +91 7838100659 [IM-Gtalk] From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On Behalf Of Ashish Saxena Sent: 21

$$Excel-Macros$$ Unsubscribe

2012-05-21 Thread Priya Jose
-- 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 post a question in the

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-21 Thread prernachadha
Hi Ayush sir, Can you plz exlude me from this forum. Sent on my BlackBerry® from Vodafone -Original Message- From: Ayush Jain jainayus...@gmail.com Sender: excel-macros@googlegroups.com Date: Sun, 20 May 2012 07:54:03 To: excel-macros@googlegroups.com Reply-To:

Re: $$Excel-Macros$$ Appropriate formula required

2012-05-21 Thread dguillett1
I don’t understand your example but here is a formula you can adapt if you have the analysis toolpak =MAX(0, MIN(EOMONTH(F$1,0), $B2) - MAX(F$1, $A2) + 1) * $C2 / $D2 Don Guillett Microsoft MVP Excel SalesAid Software dguille...@gmail.com From: Dhanesh Verma Sent: Monday, May 21, 2012 7:13 AM

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-21 Thread Mangesh Dayne
Hi All, Welcome decision. In addition, it is also good that job posting should be related to excel, vba only. Our objective is to make universal platform for EXCEL/VBA LOVERS. with regards, Mangesh On Mon, May 21, 2012 at 7:10 PM, prernacha...@ymail.com wrote: ** Hi Ayush sir, Can you plz

Re: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-21 Thread Ayush Jain
Thanks everyone for your support. Initially, I allowed to post excel related jobs but that allowance was misused by spammers. It is very difficult to differentiate excel jobs with other technical jobs for moderators. Hence, I have decided not to allow any job opening posts in this forum. Thanks

Re: $$Excel-Macros$$ unable to use advance vlookup

2012-05-21 Thread Aamir Shahzad
sorry not understand make it clear, lots of expert here can solve your issue. Aamir Shahzad On Mon, May 21, 2012 at 11:13 AM, LAKSHMAN PRASAD lakshman_...@yahoo.comwrote: Hi Aamir, Thanks Is working, that’s what I exactly want to do. But Its better if we avoid extra column. I am able to

Re: $$Excel-Macros$$ help in matching data in excel sheet

2012-05-21 Thread Bé Trần Văn
2012/5/19 Rajan_Verma rajanverma1...@gmail.com Sample file?? ** ** * * *Regards* *Rajan verma* *+91 7838100659 [IM-Gtalk]* ** ** *From:* excel-macros@googlegroups.com [mailto: excel-macros@googlegroups.com] *On Behalf Of *Cute Awesome *Sent:* 19 May 2012 6:13 *To:*

$$Excel-Macros$$ Double click Bar Charts

2012-05-21 Thread pankaj gmail account
Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five product bars. what i wants is when i click on product 2 bar i should get/open product 2 sales charts linked to it go on

Re: $$Excel-Macros$$ Double click Bar Charts

2012-05-21 Thread ashish koul
can you share the sample data On Tue, May 22, 2012 at 7:40 AM, pankaj gmail account pankaji...@gmail.comwrote: Dear Gurus, I want to create a chart with click event or any other option. Please suggest :- like if i have a bar/pie chart with five products with some sale so i gets five

Re: $$Excel-Macros$$ Double click Bar Charts

2012-05-21 Thread pankaj gmail account
Thanks for quick response. Please find attached data. I donot want to use pivot table for this. this is just a new imagination can we do this in excel. Linked Drill down Charts. Thanks and regards, Pankaj Michael On Tue, May 22, 2012 at 7:42 AM, ashish koul koul.ash...@gmail.com wrote: can

RE: $$Excel-Macros$$ NEW RULE : No more job postings in this forum.

2012-05-21 Thread Mohammed Muneer
Mr. Ayush I also support u r decision to ban those who post the job offer applications. Regards, Muneer, CC... -- FORUM RULES (986+ members already BANNED for violation) 1) Use concise, accurate thread titles. Poor thread titles, like Please Help, Urgent, Need Help, Formula

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

2012-05-21 Thread Anil Gawli
your attached file is corrupted and cannot be opned? Regards Gawli Anil On Tue, May 22, 2012 at 12:20 AM, Bé Trần Văn betnmtdongna...@gmail.comwrote: 2012/5/21 Anil Gawli gawlianil8...@gmail.com with data validation i don't think so, i have prepared in combo box control. Is it Ok?

Re: $$Excel-Macros$$ REMOVE ME

2012-05-21 Thread Anil Gawli
just email a blank with out subject to excel-macros+unsubscr...@googlegroups.com to remove yourself from the group. Regards Gawli Anil On Tue, May 22, 2012 at 4:01 AM, Asa Rossoff a...@lovetour.info wrote: Best not to quote my old post that indicates that a remove me subject will work.

Re: $$Excel-Macros$$ Re: Hi all Experts Cna u share a Macro for outlook emails sending Specific Templet With Attachments formats of .PDF .htm

2012-05-21 Thread Anil Gawli
file attached with modifications disadvantages is that it will ask to attach for every row as an attachments. Regards, Anil Gawli On Mon, May 21, 2012 at 5:44 PM, Anil Gawli gawlianil8...@gmail.com wrote: File attached for ur Reference. On Mon, May 21, 2012 at 5:25 PM, renuka chari