• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

VLOOKUP PROBLEM

T

tanwar

New Member
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
 
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
 
Hi Tanwar ,


Can you go through this uploaded file , and say what the closing stock valuation rates should be ?


Even if you cannot work out the rates for all the cells , just give the rules for each cell.


http://speedy.sh/7TZgP/tanwar-r2.xlsm


Narayan
 
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
 
Hi Tanwar ,


Can you please check this ?


http://speedy.sh/q7bse/Tanwar-Narayank991.xlsm


Try it out with sample data before trying it out on important data. Ensure you have a backup before running macros , since changes made by macros cannot be undone by using Excel's Undo feature.


Narayan
 
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
 
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 handling micro properly ? or other any reason.

with regards

tanwar
 
You must log in or register to reply here.
Back
Top