link 2 'one to many' type spreadsheets

  • Thread starter Mitchell_Collen via OfficeKB.com
  • Start date
M

Mitchell_Collen via OfficeKB.com

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
 

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

Linking data in MS Word into Excel 5
External cell reference between two excel worksheets both in One Drive 0
SUMIF using date ranges & referencing account numbers 1
Help with an Excel formula please? 7
Linking 2 spreadsheet using data from 1st spreadsheet 1
convert column with inches to 2 columns "feet" and "inches" 2
Linking 2 spreadsheet using data from the last row of spreadsheet 13
excel: combine several spreadsheets into one workbook 6

Top