Don,Rollin,Tom, and all others...Cud u help me in this (Urgently needed)

[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

 

[Tom Ogilvy]

Putting all the data on one sheet when it will really will be on 3 sheets
doesn't help that much.

 

[Frank Stone]

there are few "ready made" excel macros. reason being that
usually users all structure their data differently. and
what works in one file has to be re-written to work in
another file.
it can be done with a do loop or a for next loop but you
didn't give enought info to realy help you.

 

[sameer27p]

just wanted to know how can i pick up the totals from the two sheets fo
a particular item and put them under the Actual and Forecast rows fo
the particular time-frame..

i have already written a macro for getting the common items from th
two sheets and generating the horizontal date format.

Now,I just need to write one for plucking in the total values from th
two sheets for the item and displaying it under the proper date rang
in the Actual and Forecast row.THe variance(A-F) should also b
calculated......


How can i pluck these values from two sheets and insert them in th
final excel sheet ? Could you aid me with some macro which can do thi
?????

Thanks for your time and consideration