How do you link two worksheets from one workbook with multiple variables

[mrobolie]

How do I link two worksheets together; the first worksheet which I would like to transfer the information to the second, and also seperating them when a new month is reached.

http://www.excelforum.com/excel-gene...ml#post3919832


Thanks for your help.

[mrobolie]

I've done as requested

http://www.excelforum.com/excel-gene...ml#post3919832

[FDibbins]

Thanks for the update

Could you provide a few samples of your expected outcome in your workbook?

[mrobolie]

Attached are the examples of what I want to see. Information form worksheet one, transferred into worksheet 2 and 3, just as shown.

[FDibbins]

Thanks for the file.

1st, make sure all your headings match...either use Jan or January, dont mix them.

Then use this, copied down and across for the 1st table...
=INDEX($G1:$G4,MATCH(A11&B$10,INDEX($E$1:$E$4&$A$1:$A$4,0),0))
Change the bolded range for the other columns (or, if you have matching headings for each table, use those in another MATCH() at the end of that formula)