https://www.youtube.com/watch?v=L4BuUzccLpo&lc=Ugx3ov_KjSD7tksxV6B4AaABAg.9l27HouNl3y9l4StwJO7TA
using your file, If i want to pull out 60 rows of the data in to a new blank data sheet. how do i do this easy.? I want the same headers in the new sheet. And under colum (A1 order id). in row A2 i type the order id number, and hit enter. The rest of the colums for that row ,and order id auto fills. is this possible?
Then if i have had a barcode with the orderid number on the box. Before shipping i could just scan or type the order id into excel and the name, quantity, price, etc pops up in a blank sheet.
i attached a xls file. with a small database.
Please try to attach the file again. This time, press "Start upload" before you submit your reply.
try now.
You have not provided any Order IDs in your DB. Without this information, a lookup via a parameter query is not possible.
cant you just use ean/barcode numbers to get a row in the new sheet?
is it another way to do what i want? 🙂