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 !

Sheet1.xls...Highlighted in yellow---format require

Attachment filename: sheet1.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=62385
--
Message posted from http://www.ExcelForum.com