All help is worthy

[Robert]

I have set up a simple database in excel, using barcodes (i found this
easier to scan and lookup, than access) plus the people working with
this will find it simple to use. I have however reached a giant full
stop.
The database is pulled from Dave Peterson's update log worksheet, which
works very well, the problems is that on a lookup sheet( using Vlookup
) where the user scans the barcode it will pull all info from the
"database" sheet in reference to the barcode, ie: barcode number,
surname,forename,address, early greenfees purchased,mid purchased,late.
Is it possible to manipulate early, mid and late and return the new
values to overwrite the existing?
Any help will be thankful

 

[Bernie Deitrick]

Robert,

You could use code like this to store your modified data. With a cell selected on the row with the
modified data, and the key in column A, and your Database on a sheet named DataBase:

Dim myRow As Long

With Worksheets("DataBase")
myRow = Application.Match(Cells(ActiveCell.Row,1).Value, .Range("A:A"), False)
.Cells(myRow,2).Value = Cells(ActiveCell.Row,2).Value
.Cells(myRow,3).Value = Cells(ActiveCell.Row,3).Value
.Cells(myRow,4).Value = Cells(ActiveCell.Row,4).Value
'Etc...
End With

Of course, you might need to format the data, and use error checking, etc.
to tell when you are modifying existing data versus adding new data...

HTH,
Bernie
MS Excel MVP

 

[Robert]

Thanks Bernie
this code is great
thank you

Robert,

You could use code like this to store your modified data. With a cell selected on the row with the
modified data, and the key in column A, and your Database on a sheet named DataBase:

Dim myRow As Long

With Worksheets("DataBase")
myRow = Application.Match(Cells(ActiveCell.Row,1).Value, .Range("A:A"), False)
.Cells(myRow,2).Value = Cells(ActiveCell.Row,2).Value
.Cells(myRow,3).Value = Cells(ActiveCell.Row,3).Value
.Cells(myRow,4).Value = Cells(ActiveCell.Row,4).Value
'Etc...
End With

Of course, you might need to format the data, and use error checking, etc.
to tell when you are modifying existing data versus adding new data...

HTH,
Bernie
MS Excel MVP

 

[Bernie Deitrick]

Thanks Bernie

this code is great
thank you

Glad you liked it, and thanks for letting me know.

Bernie
MS Excel MVP