*Can you explain more about FIFO calculation.*
On Fri, May 4, 2012 at 8:19 PM, B Sharma sharma@gmail.com wrote:
Dear Friends and excel experts,,
I have a sheet in which there are columns like QtyRate of purchase
of items,
In Another sheet I need a formula for auto calculation of
FIFO calculation means calculation on the basis of First In First Out.
In a year we purchase goods on different rates,
For Example
In April I purchased 10 Pcs @ Rs. 5.00
In May I purchased 5 Pcs @ Rs. 6.00
In June I purchased 8 Pcs @ Rs. 5.50
So when I will put the consumption for
Revised...
On Sun, May 6, 2012 at 12:19 AM, Maries talk2mar...@gmail.com wrote:
Hi,
Find the attachment I hope this fulfill your requirements
Regards,
MAIRES.
On Sat, May 5, 2012 at 11:37 PM, BS CTC sharma@gmail.com wrote:
FIFO calculation means calculation on the basis
Thank You Maries for your try..
The output is what I wanted but the way is not as per my need.
I have a huge file in which there are about 25 sheets. Out of which one
sheet is named as PURCHASE another is as Consumption
In purchase there are many items are purchased on different dates
Hi,
Any one please help:
PFA the attachment of office stock.
One sheet shows the closing stock of stationery items.
In the second sheet, if I select particulars as Opening stock I need toe
get the closing stock of that Particular item, else for Purchase and Issue
I have to manually
On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Any one please help:
PFA the attachment of office stock.
One sheet shows the closing stock of stationery items.
In the second sheet, if I select particulars as Opening stock I need toe
get the closing
HI
Please try below one
=IFERROR(VLOOKUP(D2,'Utilization and Closing stock'!A2:C19,3,FALSE), )
On Sun, May 6, 2012 at 2:38 PM, Smitha S R sperdwo...@gmail.com wrote:
On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Any one please help:
PFA the
Hi Smitha,
please find attached sheet with correction in formula
you just have to put Opening stock in inverted comms. i.e. Opening stock
thanks
rajesh
On Sun, May 6, 2012 at 2:37 PM, Smitha S R sperdwo...@gmail.com wrote:
Hi,
Any one please help:
PFA the attachment of office
**
2012/5/5 Maries talk2mar...@gmail.com
Hi,
Check below link,
http://www.angelfire.com/biz7/julian_s/julian/julians_macros.htm
Regards,
MARIES.
On Sat, May 5, 2012 at 4:41 AM, karthik N n.karthi...@gmail.com wrote:
Hi Friends,
How learn the macro's in step by step,kindly
Dear,
Instated of learn from web site, just try your self with small small tools
it will help you lot, i learn like this only this is my personal
experience.
all the best.
Thanks Regards,
Prajakt Pande
+971551388482
**
On Sun, May 6, 2012 at 5:09 PM, Bé Trần Văn
Provide a file
Don Guillett
Microsoft MVP Excel
SalesAid Software
dguille...@gmail.com
-Original Message-
From: joseph.cam...@gmail.com
Sent: Saturday, May 05, 2012 2:23 AM
To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ Charts
Sent on my BlackBerryŽ from Vodafone
You mean, You want to know how many cells you can fill in a minute?
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com]
On Behalf Of Indrajit $nai
Sent: 05 May 2012 03:57
To: excel-macros@googlegroups.com
Subject:
Thanks.
The logic is for every three items, the third is free nd the free should be
the lowest price.
The items should be arranged in order they are bought in batches of three.
See attached
On 6 May 2012 16:39, dguillett1 dguille...@gmail.com wrote:
A VERY simple formula for the 1st question.
You can use this non Array function to Calculate the day to completion of
starting month
=DAY(DATE(YEAR(A2),MONTH(A2)+1,0)-DAY(A2)+1)
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Behalf Of Maries
Dear karthik
you can also learn VBA by your self and for this you just need to record
macro for anything you do.
*Regards,*
*Lalit Mohan*
*https://www.facebook.com/buzinesstransformation*https://www.facebook.com/buzinesstransformation
On Sun, May 6, 2012 at 7:07 PM, Prajakt Pande
If you are using excel 2007 and previous version of you will not be able to
record macro of working with Shapes and Charts.. you can do this in Excel 2010 J
Regards
Rajan verma
+91 7838100659 [IM-Gtalk]
From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] On
Dear All,
Appreciate an help to write a macro to create a request number as per the
below condition.
for each name on the same date should be a same request number, but should
not be repeated more than five times.
Important: If the date column is blank and Name column having data macro
should
17 matches
Mail list logo