Load Data Form Table to Order Form Using VLookUp in VBA

**Ivy_1011** · 02-02-2022, 03:29 PM

I have the code below which I am having trouble with. I am trying to load data from a Order_Table to an Order_Form using vlookup. I am using vlookup vba and copy and paster. Vlookup is contingent on order number input. I have attached the file.

Sub Load_Order()

Dim rng As Range
Dim temp As Variant
Dim i As Long
Dim a As Long
Dim rng_dest As Range
Dim Order_Number As String
Order_Number = Order_Form.cell("C_5")

'Order_Number = InputBox("Enter Order Number :")

If IsEmpty(Range("C5").Value) = True Then
MsgBox "Cell C5 is empty"

Else

Order_Form.cell("C5") = Application.WorksheetFunction.VLookup(Order_Number, ORDER_TABLE.Range("B6:B9"), 1, False)

' Date
Worksheets("ORDER_TABLE").Range("C6").Copy
Worksheets("ORDER_FORM").Range("B8" & Rows.Count).End(xlUp).Offset(1, 0).PasteSpecial xlPasteValues

End If

End Sub

ORDER # ITEM DESCRIPTION QTY
101 9987 White T-Shirt 5
102 4286 Red T-Shirt 7
103 2938 Green T-Shirt 8
104 9257 Yellow T-Shirt 3

Order# 101

ORDER # ITEM DESCRIPTION QTY

**sourabhg98** · 02-02-2022, 03:55 PM

Although I am not sure what exactly you're looking for and why, but based on the code you shared I think you're trying to do this -

Please Login or Register  to view this content.

**Ivy_1011** · 02-02-2022, 04:21 PM

Hi Sourabhm

This is what I am trying to accomplish, but my actual data will not be placed in a row; for example, I will copy and paste random cells in the table to random cells on the form. I created a simple example, but the original code I wrote would have copied select or randoms and copied them to select or random cells. I think the code would look different.

Thank you for getting back to me so quickly.

I this modifiable?

Ivy_1011

**sourabhg98** · 02-02-2022, 04:24 PM

Sorry, I didn't really understand what you're trying to accomplish here. It might be easier if you can share another example with the results that you need manually typed in so I can replicate the same.

**Ivy_1011** · 02-02-2022, 04:55 PM

Okay, thank you.

**Ivy_1011** · 02-02-2022, 05:03 PM

Hi Sourabhg98,

I have uploaded a revised spreadsheet. Hopefully, my objective will be more clear.

Thanks.

Ivy_1011

**sourabhg98** · 02-02-2022, 05:28 PM

Does this work?

Also, not sure but why are doing this via VBA and not formulas?

**Ivy_1011** · 02-02-2022, 06:09 PM

Hi Sourabhg98,

This is very close to what I am looking for. The original file is more complex which is why it's not being done with formulas; orders are input into the order form, cleared, and loaded if necessary.

Thank you this was extremely helpful!,

Regards,
Ivy_1011

**sourabhg98** · 02-03-2022, 03:00 AM

Glad I could assist. If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

Load Data Form Table to Order Form Using VLookUp in VBA

LinkBack

Thread Tools

Rate This Thread

Display

Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Re: Load Data Form Table to Order Form Using VLookUp in VBA

Thread Information

Users Browsing this Thread

Similar Threads

Order Form with Select items, and different options for each item...how to create form?

Alternative to VLOOKUP when data is in min/ max (i.e. 0-5) form vs. table form

Want to auto-populate an order form from a storeroom count form

How to use Vlookup or If fuction to create an order form.

Order form Vlookup

Form not displaying cell data on load.

Form Load Picture form variable

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions