Guys,can u help me in this ??

S

sameer27p

the required format is in Sheet1.xls (highlighted in yellow)....i nee
to pick the total of quantities from two sheets and insert them in th
Actual and Forecast rows as per the item number and transactio
date......also,i need to calculate variance (ACTUAL-FORECAST)......

Can u help me in this ?Is there any ready macro available for this ?
Thanks for your time and consideration...Attached:Sheet1.xls.....

Attachment filename: sheet1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62359
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Don,Rollin,Tom, and all others...Cud u help me in this (Urgently needed) 3
Macro help needed... 0
Urgent Help needed ! 2
Power Pivot with 2 sets of values 0
Macro help needed... 0
Urgent Macro help needed... 2
Help pulling data from pivot table for calculation 1
Sumproduct Please Help! 1

Top