Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
link 2 'one to many' type spreadsheets
I need to combine 2 spreadsheet but I can't find a way because the larger
'spreadsheet 2' (see below) which has a row for every subtask stops me from doing a straight sort and match copy. Do you know a way to link the 2 'one to many' type spreadsheet? I would import into an access database however i have so many columns with formulas and stuff that I would be able to export it with the needed formulas. Please help me? MC spreadsheet1 SuperTask ---------------- superTask1 superTask2 superTask3 spreadsheet 2 SubTask SuperTask ---------------------------------------- subtask1 superTask1 subtask2 superTask1 subtask10 superTask2 subtask20 superTask2 -- Misty :-) Message posted via http://www.officekb.com |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
link 2 'one to many' type spreadsheets
Your requirement is not clear...
How do you want the combined sheet? "Mitchell_Collen via OfficeKB.com" wrote: I need to combine 2 spreadsheet but I can't find a way because the larger 'spreadsheet 2' (see below) which has a row for every subtask stops me from doing a straight sort and match copy. Do you know a way to link the 2 'one to many' type spreadsheet? I would import into an access database however i have so many columns with formulas and stuff that I would be able to export it with the needed formulas. Please help me? MC spreadsheet1 SuperTask ---------------- superTask1 superTask2 superTask3 spreadsheet 2 SubTask SuperTask ---------------------------------------- subtask1 superTask1 subtask2 superTask1 subtask10 superTask2 subtask20 superTask2 -- Misty :-) Message posted via http://www.officekb.com |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
link 2 'one to many' type spreadsheets
I want to merge them straight across.
-- Misty :-) Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/200901/1 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Link spreadsheets? | Excel Discussion (Misc queries) | |||
Link spreadsheets | Excel Discussion (Misc queries) | |||
how do I link 2 spreadsheets and have the second one autosort ign. | Excel Discussion (Misc queries) | |||
How do I link cells in two different spreadsheets? | New Users to Excel | |||
link spreadsheets together to summarize | Excel Worksheet Functions |