Transferring data from one spreadsheet to another

N

novajoe

I am so new to this so please be very simple with a solution!! I am using
Microsoft Office 2007. I finally entered all my customers in an Excel
spreadsheet. I think the file type is xlsx, whatever that is. Anyway, I was
wondering if I could somehow, magically, transfer some of that information to
another Excel spreadsheet, which is my Proposal form. When I do a proposal I
have to either type in the customer info or copy and paste it from one form
to the other. Is there a way to format the "Proposal" form to automatically
access the "Customer Address book" to fill in the appropriate blanks?? Hope
I'm explaining this correctly. Thanks in advance for any help you can give
me!!
 
P

Pete_UK

Yes, you would normally use VLOOKUP to do this. Imagine you have a
sheet called customers with name and address details occupying, say, 6
columns A to F with customer name in column A, and that you have a
header row, with data occupying row 2 to row 300. In your proposal
sheet you enter a customer name in cell A5 and want the other customer
details brought across into cells B5:F5.

Put this formula in B5 of your proposals sheet:

=VLOOKUP($A5,customers!$A$2:$F$300,COLUMN(A2),0)

and then copy it into C5:F5 and the address details should appear
automatically.

Then put a different customer name in A5 and the address details
should change to suit.

Hope this helps.

Pete
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top