Need Help !! How to Copy a data from one spreadsheet to another

S

Suyog

I'm in product sales.. we have several products and these products go to
several customers. I'm tracking product qualifications at each customer but I
get two different spreadsheets. One which track software availability
(Product, SW Available, Date, Customer) for each customer & product and Other
one tracks HW availability (Prod., Samples Available date etc..). I want to
have following data in my spreadsheet.

Prod., Customer, Samples Available Date, Software Name, Software available
dates.

Prod and Customer are columns are in my spreasheet
Prod. & Sample Available Dates are in HW Availabilty Matrix
Prod and other SW data comes from Software availablilty.

I'm not a excel guru.... I know few things..

Please help..

Thanks,
Suyog
 
P

PJFry

To copy, simply select that column or row or whatever data you need and push
Ctrl-C. Then move the sheet where you want the data to be, select the first
cell that the data will be in and push Ctrl-V.

One thing you need to be careful about is making sure all of your data lines
up correctly.

Is that what you were looking for?
 
N

NikkiB

Argh. I just tried to post this and it was lost so I will re-type.

OK. Check out:
Insert
Formula
Vlookup

For example.
You have one spreadsheet called SW.xls with the following columns:
A: Product
B: SW Available
C: Date
D: Customer

You also have a spreadsheet called HW.xls with the following columns:
A: Product
B: Sample Availability Date

You can link the data by Product assuming product is the same on each
spreadsheet and only listed once on HW.xls.

To add Sample Availlability date for a product from HW.xls to column E in
SW.xls you would type the following in cell E2 of SW.xls:
=VLOOKUP(A2,[HW.xls]Sheet1!$A:$B,2,)
You should be able to copy the formula down column E. Cell E3 should look
like this:
=VLOOKUP(A3,[HW.xls]Sheet1!$A:$B,2,)

FYI- When you open the workbook you may be prompted to update the linked
information. Click update if YOU created the links. Just remember. If you are
storing historical information in this file all dates would be updated.

Be creative and let me know if you need any more direction. :)

NikkiB
 

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