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 [TABLE="class: cms_table"]
<TBODY>[TR]
[TD]</SPAN>[/TD]
[TD="align: right"][TABLE="class: cms_table_grid"]
<TBODY>[TR]
[TD]Installer[/TD]
[TD]April 28[/TD]
[TD]April 29[/TD]
[/TR]
[TR]
[TD][TABLE="class: cms_table"]
<TBODY>[TR]
[TD]Costello </SPAN>[/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

[/TD]
[TD]Vinyl Plank[/TD]
[TD]N/A[/TD]
[/TR]
[TR]
[TD]Dan[/TD]
[TD]Hardwood[/TD]
[TD]Tile[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</TBODY>[/TABLE]

</SPAN>[/TD]
[TD="align: right"]</SPAN>[/TD]
[/TR]
[TR]
[TD]</SPAN>[/TD]
[TD]There could be multiple jobs on any given date for the installer.
</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]</SPAN>[/TD]
[TD]</SPAN>[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]</SPAN>[/TD]
[TD][/TD]
[TD]</SPAN>[/TD]
[/TR]
</TBODY>[/TABLE]


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!​