Fill in blank rows with 0's in a dynamic table, to always have same number of rows

Really appreciate any help on this one.

1. My spreadsheet has a table of projects that comes in from Access. Sometimes there will be 10 rows, sometimes 42 etc, depending on how many records come from Access.

2. We have a stochastic optimization plug in that needs to have a fixed number of rows with no blanks in (otherwise gives lots of #NAME errors) - this is something that cannot be solved, so I have to make sure we always feed 50 rows to the optimizer, with some of them 'real' project data and some are 'zero' rows.

3. Since the number of rows coming from Access is dynamic, I'm trying to figure out how to add the requisite amount of 'zero' rows to make up the 50 needed rows.

Thank you for your guidance...

Hey,
May be you could add a new worksheet to your exported excel file and on A1 enter this
=IF(Sheet2!A1="",0,Sheet2!A1)

And drag it across the rows and columns...

Then use data from sheet 2

This is not fully automated, but this shudnt take much of your time, until the experts cud give u some macro for it.

Hope this helps,

Regards
Mohit