multi dimensional array to create weekly schedule

[lover_of_coffee]

Using Excel2010 and WIN7, I am trying to make use of a multi dimensional array to pull data from a data entry worksheet and display it on another worksheet as a weekly calendar. There are multiple rows in the data entry sheet with the name of a person (Installer), a date and a job description.

The target worksheet must combine all entries for that installer onto a single row with the jobs listed on the specific dates. This sheet should look like a weekly calendar with the date at the top, the installer name at the left Monday job info on square one, Tuesday job info on square two etc.

When I try to use the following array formula {=IFERROR(INDEX(tblData,MATCH(C$5+$B7&ShowName,tblData[DATE]&tblData[WHO],0),3),"")} it errors out with a “Multicell array formulas are not allowed in tables”. How can I do this without a table? </SPAN></SPAN>

Any help you can give is greatly appreciated!

 

[iliace]

You can convert it from a Table to regular range by using Table Tools->Design->Tools->Convert to Range

If you want to preserve the Table, you will probably need to use an "shadow" range that links to the data table information.

 

[lover_of_coffee]

[h=2]I accidentally created my reply as a second posting "Help creating a graphic calendar from a data entry sheet "[/h]

Hello,
I have a data entry sheet with the following columns
Installer - Date - Job Details
Dan - April 28 - Hardwood
Costello - April 28 - Vinyl Plank
Dan - April 29 - Tile
etc. . .

There are multiple rows for the same installers.

On another sheet I need to display

Date1 - Date 2 - Date 3 etc as columns with a single row for each installer listed in sheet 1 showing the appropriate job details based on the combination of installer and date.
The end result with the above data would be

</SPAN>	Installer April 28 April 29 Costello </SPAN> <TBODY> </TBODY> Vinyl Plank N/A Dan Hardwood Tile <TBODY> </TBODY> </SPAN>	</SPAN>
</SPAN>	There could be multiple jobs on any given date for the installer. </SPAN>
</SPAN>	</SPAN>
</SPAN>		</SPAN>

<TBODY>
</TBODY>

Can anyone help me create this formula? Or help me to write the <ACRONYM title="visual basic for applications">vba</ACRONYM> code?
Any help is greatly appreciated!​