macro help required

[zelhopper]

Hi,

how do I write macro code to use information on current sheet, to enter information in specific cell in another sheet.

click button on sheet 1

use information in [sheet 1 A8] ("DAVE") to find row in [sheet 2]("row 3")

use information in [sheet 1 B8] ("MONDAY") to find column in [sheet 2]("column C")

copy information from [sheet 1 C8] ("APPLE") to found cell [sheet 2 C3]

 

[rpaulson]

try this

Sub do_it()

Dim rs As Worksheet
Set rs = Worksheets("Sheet2")

r = WorksheetFunction.Match(Range("A8"), rs.Range("A:A"), 0) 'get row
c = WorksheetFunction.Match(Range("B8"), rs.Range("1:1"), 0) 'get column
rs.Cells(r, c) = Range("C8")

End Sub

 

[zelhopper]

YES! That has worked a treat thank you so much!