Forum

How to pull data fr...
 
Notifications
Clear all

How to pull data from database into new sheet

5 Posts
3 Users
0 Reactions
158 Views
(@tikkis)
Posts: 3
Active Member
Topic starter
 

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.

 
Posted : 22/01/2023 2:00 pm
Riny van Eekelen
(@riny)
Posts: 1185
Member Moderator
 

Please try to attach the file again. This time, press "Start upload" before you submit your reply.

 
Posted : 23/01/2023 3:46 am
(@tikkis)
Posts: 3
Active Member
Topic starter
 

try now.

 
Posted : 23/01/2023 1:23 pm
Alan Sidman
(@alansidman)
Posts: 221
Member Moderator
 

You have not provided any Order IDs in your DB. Without this information, a lookup via a parameter query is not possible.

 
Posted : 24/01/2023 1:17 am
(@tikkis)
Posts: 3
Active Member
Topic starter
 

cant you just use ean/barcode numbers to get a row in the new sheet?

is it another way to do what i want? 🙂

 
Posted : 26/01/2023 2:15 pm
Share: