 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / December 2006All help is worthy
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 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 >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 [quoted text clipped - 8 lines] > values to overwrite the existing? > Any help will be thankful Thanks Bernie this code is great thank you > Robert, > [quoted text clipped - 30 lines] > > values to overwrite the existing? > > Any help will be thankful > Thanks Bernie > this code is great > thank you Glad you liked it, and thanks for letting me know. Bernie MS Excel MVP
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.