How to pull data from a sheet into a format in another sheet using VBA?

**RDD1987** · 07-23-2019, 02:39 PM

Hello everyone!

I need help with the following scenario.

I have the following sales invoice format in one sheet ("Sheet1") where I record my sale of items and the data get posted in another sheet ("Sheet2").
Invoice format.jpg

Lets say I have made 10 number of sales so far and the item details are recorded in Sheet2 as shown in the picture below:
Sales.jpg

Now based on the invoice number I want to pull the item records (Item name and their quantity) from Sheet2 back into the invoice format sheet ("Sheet1") in their designated place.
As shown in the second picture, for Invoice no. 1, for example, I have sold Items 2, 3 and 10 and based on the invoice number I want the sales invoice format ("Sheet1") to populate only the items that I had sold for that particular invoice number as shown in the picture below:
Result.jpg

How do I do this in VBA?

**jolivanes** · 07-23-2019, 04:50 PM

Nice Pictures.
I, for one am not going to make a workbook with all your info so it can be tested.
I have such an idea that most people won't
So, you might have to attach a workbook with sufficient data so it can be tested.

After you transfer data to Sheet2 for invoice 1, do you want invoice 2 to just overwrite invoice 1, Does not seem logical but you don't say where the next invoice should go.
Think things thru before posting please.

Are any of the numbers results from formulae? Or were the zeros (0) entered manually?

**jolivanes** · 07-23-2019, 06:15 PM

Change attached as required

**RDD1987** · 07-24-2019, 01:14 AM

Hi, I am very sorry instead of attaching the workbook, a picture got attached. But I am also thankful for the solution that you gave me. I think I can make it work now.