Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
collate data Vlookup?
I have my data entered on my accounts spreadheet each item being allocated a
job number , format 09/11, the first 2 digits being year and the second 2 digits being the job number that year. I then have a separate workbook with a spreadsheet for each job number for costing purposes. I already collate other data ie pay from 2 different sources to these job number spreadsheets but wish to bring in the invoice data as stored on my accounts spreadsheet to each individual job costing spreadsheet. Using VLOOKUP i can get the first entry for each job number to be read from the accounts spreadsheet to the costing spreadsheet - I don't want to just show a total value, I wish to see the same data as input into the accounts spreadsheet to be used in a different way on the costing spreadsheet - how can I "Lookup" more than one entry and get it transferred to the costing spreadsheet or use another function. I currently use copying and pasting at the moment. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
collate data Vlookup?
Checkout:
http://office.microsoft.com/en-us/ex...260381033.aspx and see if this can help you. -- Gary''s Student - gsnu200859 "BimboUK" wrote: I have my data entered on my accounts spreadheet each item being allocated a job number , format 09/11, the first 2 digits being year and the second 2 digits being the job number that year. I then have a separate workbook with a spreadsheet for each job number for costing purposes. I already collate other data ie pay from 2 different sources to these job number spreadsheets but wish to bring in the invoice data as stored on my accounts spreadsheet to each individual job costing spreadsheet. Using VLOOKUP i can get the first entry for each job number to be read from the accounts spreadsheet to the costing spreadsheet - I don't want to just show a total value, I wish to see the same data as input into the accounts spreadsheet to be used in a different way on the costing spreadsheet - how can I "Lookup" more than one entry and get it transferred to the costing spreadsheet or use another function. I currently use copying and pasting at the moment. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Collate data | Excel Discussion (Misc queries) | |||
How do i collate data from different sheets in one sheet? | Excel Discussion (Misc queries) | |||
Search Formula to collate BOM Data | Excel Worksheet Functions | |||
Collate data from many workbooks | Excel Discussion (Misc queries) | |||
How do I search a data range for a particular value then collate . | Excel Discussion (Misc queries) |