Urgent Macro help needed...

[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 !

Sheet1.xls----required format (highlighted in yellow

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

 

[Mark E. Philpot]

Plucking numbers from unknown cells is hard to do blindly.

you could just pastelink a totals value for the sheet. I
say this because I cannot fully understand the request.

If you want to send me more info on the project and better
dummy info, I could create a userform that will do all the
work for you.

See some of my samples at:
http://www.geocities.com/excelmarksway
http://au.geocities.com/excelmarksway

regards
Mark
(e-mail address removed)

 

[sameer27p]

Hey Mark,
have mailed you my existing macro and my requirement.Hope you can hel
me out..
thanks for your time and consideration...