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

--
Regards,
Tom Ogilvy


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

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

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