At Fixya.com, our trusted experts are meticulously vetted and possess extensive experience in their respective fields. Backed by a community of knowledgeable professionals, our platform ensures that the solutions provided are thoroughly researched and validated.
Excel Database Hi friends, I am actually preparing to purchase a Point of Sale System but I've just finished entering all my stock barcodes, with the unit cost, selling price, mark up percentage etc etc.. Now i'm going to validate that all my data entry is correct. Is there any way to fast query my database and see in a form format that the price and description is correct for the barcode that is being scanned. I tried using the ctrl find but it seems very troublesome. anyone know of any short cuts that enables a more clear presentation. I tried using Data form and den clicking on criteria, but if i accidentally changed the data, it instantly changes it. would anyone be able to advise a better method to check all e prices?
I would suggest to protect the sheet first off all. Make sure you write your password down so you won't lose it. Second, try to sort your data A-->Z it'll make your job much easier.
- If you need clarification, ask it in the comment box above.
- Better answers use proper spelling and grammar.
- Provide details, support with references or personal experience.
Tell us some more! Your answer needs to include more details to help people.You can't post answers that contain an email address.Please enter a valid email address.The email address entered is already associated to an account.Login to postPlease use English characters only.
Tip: The max point reward for answering a question is 15.
×