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)
*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
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
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,
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:
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
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
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
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
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#
.
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
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.
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
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
--
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
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:
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
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
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
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
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:*
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
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
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
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
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?
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.
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
28 matches
Mail list logo