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
--
Message posted from http://www.ExcelForum.com

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

--
Regards,
Tom Ogilvy

"sameer27p " wrote in message
...
the required format is in Sheet1.xls (highlighted in yellow)....i need
to pick the total of quantities from two sheets and insert them in the
Actual and Forecast rows as per the item number and transaction
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=623598
---
Message posted from http://www.ExcelForum.com/

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.

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

--
Regards,
Tom Ogilvy

"sameer27p "
wrote in message
...
the required format is in Sheet1.xls (highlighted in
yellow)....i need
to pick the total of quantities from two sheets and
insert them in the
Actual and Forecast rows as per the item number and
transaction
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=623598
---
Message posted from http://www.ExcelForum.com/



.

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

--
Message posted from http://www.ExcelForum.com