populate cells with data from another sheet

P

Pepe_abu

I use 2 sheets to track some sales proposal data. My problems is that I have
to duplicate the data in both sheets.

Sheet 1 has all the data for each proposal. Each proposal is given a unique
number. If that proposal is accepted 80% of the data from sheet 1 is then
moved to sheet 2 which is used for analysis.

What I would like to do is use the unique number for each row to populate
the colums in sheet 2.

I'm not sure how to go about this. I'm hoping someone can help me work this
out or suggest how to go about this.

Thanks in advance
Pepe
 

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

Similar Threads

Creating a Chart on form from selected data in query. 0
Populating entire rows of data from a master sheet? 3
Copy entire row from another sheet onto first sheet if a unique text matches 1
Auto populate value from one task to another in MS PROJECT 0
Create an edit field 1
Need help referencing b/w sheets for school project 0
Referecing Worksheet names that are dates in a formula 2
Copy previous record into form field 0

Top