Urgent Help needed !

[sameer27p]

Hi,
I need to pick up values from two different sheets and put them unde
two rows (Actual and Forecast) as per the transaction date..Also i nee
to calculate the variance(actual-forecast).Is there a readymade macr
available for plucking values from two sheets and placing them in th
output sheet (i need the total value of each item in the two columns t
be picked up and displayed ),,,,,,,,,,,,,,,,,,,,,

does anyone have an idea how i can go about ? look forward to have
reply soon.thanks for ur time and consideration....refer Sheet1.xl
which specifies my requirement......

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

 

[Tom Ogilvy]

macros, ready made or custom, would be specific to the way the sheets are
laid out.

Much more information would be required to do anything specific

in general

set rng = worksheets("Data1").Range("A1")
set rng1 = Worksheets("Data2").Range("A1")
with worksheets("Results")
.Range("B9").Value = rng.value
.Range("B10").Value = rng1.Value
.Range("B11").Formula = "=B10-B9"
End With

two rows <> two columns

 

[sameer27p]

THANKS TOM...BUT I REALLY NEED SOMETHING SPECIFIC....HOPE U CUD HELP M
IN DOING THAT...
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 ? Thanks for your time an
consideration...Attached:Sheet1.xls.....

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