Urgent Macro help needed...

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

sameer27p - 21 Jul 2004 17:01 GMT

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

Reply to this Message

Mark E. Philpot - 22 Jul 2004 10:27 GMT

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
excelmarksway@yahoo.com.au

>-----Original Message-----
>just wanted to know how can i pick up the totals from the two sheets for
>a particular item and put them under the Actual and

Forecast rows for

>the particular time-frame..
>
>i have already written a macro for getting the common

items from the

>two sheets and generating the horizontal date format.
>
>Now,I just need to write one for plucking in the total

values from the

>two sheets for the item and displaying it under the

proper date range

>in the Actual and Forecast row.THe variance(A-F) should

also be

>calculated......
>
>How can i pluck these values from two sheets and insert

them in the

>final excel sheet ? Could you aid me with some macro

which can do this

>?????
>
[quoted text clipped - 3 lines]
>
> Attachment filename:

sheet1.xls

>Download attachment: http://www.excelforum.com/attachment.php?postid=623864
>---
>Message posted from http://www.ExcelForum.com/
>
>.

Reply to this Message

sameer27p - 22 Jul 2004 14:45 GMT

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

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

Reply to this Message