Auto populate data

**arrush** · 09-16-2013, 05:59 PM

Hi All,

Looking for some help in creating this workbook for acknowledging sales orders. Basically I input the customer/product information in a sales log and would like to be able to auto-populate the acknowledgement sheet. I dont need to generate a new workbook file, would just like to be able to select one of the lines in the order log and have the acknowledgement pull the data from that row so it can be printed.soack.xlsx

I'm a basic user and have no idea where to even begin so any help would be appriciated.

Arek

**Richard Buttrey** · 09-16-2013, 06:29 PM

Hi

The general principle is as follows.
Create a named cell somewhere on the Acknowledgment sheet called say 'DataRow'. In this cell enter the following formula

Formula:

Please Login or Register  to view this content.

This cell will then return the row number in the Sales Order log that contains the Order number that you enter in B4 of the Acknowledgement sheet.
The next thing is to ensure that all your column labels on the Sales order log match exactly the text you've entered on the Acknowledgement. Watch out for trailing spaces and other formatting that might mean the two cells look the same but which aren't. The 'Bill To Address:' is a case in point. The Sales log has a line feed character after the 'o' in 'To'. Remove this so that G12 on the Order log is exactly the same as D6 on the Acknowedgment.

Now in D7 enter the formula

Formula:

Please Login or Register  to view this content.

This will return the address for the Bill To area. Enter similar formulae in all the other cells on the acknowledgment sheet, changing D6 to wherever the label is for the value you're trying to return.

However since every row on the order log is a single order and product I don't see how you you expect to get up to three different products in the Acknowledgement rows 14:16