Narayan sir
thanks for help me. i also forwarded a mail just for introduction
i am giving you my another problem related my sample sheet
your micro works only with sample data, when i insert new data in col B:14 to K14 and onwards, no stock value is calculate automatically.
am i not...
Hello Narayan Sir
thanks for showing interest towards my problems
i just saw the sample sheet but could not understand.
if i create a new worksheet for the session 2012-13 how i can used your solutions.
pl guide me
with regards
tanwar
Hello Naryank991 sir
i tried to explain what i need at my best level in forwarded sheet
sorry for delay, i was busy some other assignment.
with regards
tanwar
here is my file
http://speedy.sh/RBm9g/Narayank991.xls
i think jskushawah's solution is short and sweets
click of DATA ribbon and select the "TEXT To Columns"
then check to Fixed width and click on "Next"
your data will appear, click at point where from you want to split data.then finish
pl note that before do this, insert the columns...
Nayayank991
thanks sir to solve my problems, but my question is differ.
pl look at my attachments below :
http://speedy.sh/dFBS9/TANWAR-R1.xls
with regards
tanwar
I have linked on xl file. pl solve my problem for calculating cl stock and value on FIFO basis
here is my linked file.
http://www.2shared.com/document/trfPxgyL/TANWAR.html
tanwar
my formula is below:
=VLOOKUP($B$5&"1",$D$5:$F$30,2,FALSE)
I HAVE WRITTEN FORMULA IN SHEET#2 AT A1
BUT I COPY THIS FORMULA AT A2, VALUE OF ($B$5&"1") IS NOT CHANGED, I WANT TO CHANGE NEXT
AT A2 ($B$5&"2") AT A3($B$5&"3")ONWARDS.....
PLEASE HELP ME
hi kiran
tnks for reply
but my question is that if i insert data in sheet#1 that should be retrieve automatically scrip wise in sheet#2. for example reliance scrip purchased on 01/08/12, 5/08/12, 10/08/12 data should be like that
Scrip Purdate
Reliance 01/08/12
08/08/12
10/08/12
i regular purchase scrips on various dates like reliance, ITC and so many, i insert data in sheet i in col. a; scrip b: purchase date C: amount. how i arrange date wise data of reliance then ITC in sheet#2