Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Dear All
I am working with XP edition and i want to consolidate two sheets to a third one. Both sheets have a first column with code, a second column with a sort code, a third column with a description and another 12 columns, one for each month. i want to create a third sheet which will bring all the data from the other two sheets. There is any posibility to use a formula, for sort code (column b) in order to pull all the data to one sheet and at the same time for each sort code to have all aditional information? I can bring all the data by using vlookup. But how can i bring all the sort codes to the third sheet ? Any good ideas? Thanks in advance |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Copying multiple sheets from one book 2 another and undertake spec | Excel Discussion (Misc queries) | |||
Copy comments to several sheets in a workbook? | Excel Worksheet Functions | |||
PROTECTING/UNPROTECTING SHEETS | Excel Discussion (Misc queries) | |||
Multiple sheets selected | Excel Discussion (Misc queries) | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) |