Solved Transfer Data from Sheet to Invoice

February 3, 2014 at 23:57:52
Specs: Windows 7
Hi I need someone's help. I want to transfer data from one sheet to another (invoice) once I add a Quantity in one sheet I want it to send 4 pieces of information to the Invoice (Quantity, Description, Item ID and Price)

The Invoice will start in line 18

I would really appreciate it if someone could help me with this.
Thank you.

See More: Transfer Data from Sheet to Invoice

February 4, 2014 at 10:09:39
Is this Excel, Open office or other?

Always pop back and let us know the outcome - thanks

Report •

February 4, 2014 at 10:46:50
✔ Best Answer
Assuming Excel...

Since I don't know your level of expertise, I'll start by saying that a couple of simple formulas will accomplish your goal. Let's call your data entry sheet something creative such as Data Entry.

In your Invoice sheet you would use simple formulas such as ='Data Entry'!A1. The cell that contains that formula will always match whatever is in DataEntry!A1

If you are looking for something more sophisticated, such as a macro, then you have a couple of options:

1 - The data transfer could be triggered automatically/immediately by the entry of data into the Quantity cell on the Data Entry sheet. This method would not allow for user review, it would just transfer the data.

2 - The transfer could be triggered by a "button" once the data has been entered and reviewed by the user.

In either case, we are going to need more information before any working code could be written. Since the VBA code has to be very specific about where it is getting the data from and where the data should be placed, we will need more detail than "The Invoice will start in line 18 ".

This is an example of what the automatic code might look like. As soon as data is entered in D1, A1:D1 will be copied to Invoice!A18:D18

Private Sub Worksheet_Change(ByVal Target As Range)
'Determine if the Quantity cell (D1) has been changed
  If Target.Address = "$D$1" Then
'If Yes, Copy A1:D1 to Invoice Sheet A18:D18
    Range("$A$1:$D$1").Copy _
  End If
End Sub

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

Report •

February 5, 2014 at 13:26:43
it is for Excel
I am looking to transfer data from sheet 2 and on containing QTY, Item Description, Item # and Price to sheet 1 (invoice)

message edited by dilawneko

Report •

Related Solutions

February 5, 2014 at 20:48:58
When I said we needed more detail, I really meant detail.

Keep in mind that we can't see your workbook from where we're sitting. We don't know what cells your source data is in nor do we know what cells you want the data copied to.

Without more specific detail, there's not much we can offer.

e.g. "I need to copy Sheet2!A1:D1 to Invoice!A18:D18"

That's the kind of detail we need.

Click Here Before Posting Data or VBA Code ---> How To Post Data or Code.

message edited by DerbyDad03

Report •

Ask Question