Ok.

In nearly there.

I have now stored the row number in variable "x".

How do I select the cell B"x" ?

Range("Bx") doesn't work, so how?

Thanks


--
thegooner
------------------------------------------------------------------------
thegooner's Profile: http://www.excelforum.com/member.php...o&userid=36618
View this thread: http://www.excelforum.com/showthread...hreadid=563633

Instead of the range object use cells.

so for instance:

datevariable = sheets("Sheet2").cells(rowvariable,1)
valuevariable = sheets("Sheet2").cells(rowvariable,2)


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563633

Thanks for your help

Could you please tell me why this doesn't work (sorry for being such a
noob)

Dim was
Dim site
Dim locality
Dim y
Dim now
Dim testdate As Long
Dim x

' these 2 lines get what column to edit in the last query
' site should return the number 3, locality should return the number 2

site = Application.VLookup(F6, Worksheets("List").Range("B3:C5"), 2,
False)
locality = Application.VLookup(H6, Worksheets("List").Range("E3:F4"),
2, False)

'add the results of the 2 varaibles above to get a number of column
(should be 5)
y = site + locality

' this line returns the value already in that cell
was = Application.VLookup(A6, Worksheets("Data").Range("A:V"), y,
False)

' this line adds the input amount in L6 to the amount already in the
cell
now = was + Range("L6")

testdate = Range("A6")

x = Application.Match(testdate, Worksheets("Data").Range("A:A"), 0)

Worksheets("Data").Cells(x, thevalue) = now


--
thegooner
------------------------------------------------------------------------
thegooner's Profile: http://www.excelforum.com/member.php...o&userid=36618
View this thread: http://www.excelforum.com/showthread...hreadid=563633

is it the vlookups that arent working?

probably cos you need to quote the search criteria.

vlookup("H6",Range,returncol,false)


--
MattShoreson
------------------------------------------------------------------------
MattShoreson's Profile: http://www.excelforum.com/member.php...fo&userid=3472
View this thread: http://www.excelforum.com/showthread...hreadid=563633