Auto generating / dynamic tables

**abender777** · 02-13-2010, 01:34 AM

Hi everyone

I have created a spreadsheet for work that is used to count money and eftpos receipts. It effectivly has a blank table to enter in eftpos ammounts, then sums that. Then it has a cash table which has the type of money (note/coin), then the count (which you put in), and then total for each line, then a grand total.

There is also a "cash sales after count" table, which is used if a customer purchases something with cash after you have done the count.

What i have done is created a seperate worksheet that summarises that information to print out on a receipt(not in the attatchment). However, at the moment the receipt colum is just 20 lines long, and if there is only 10 receipts, there will be 10 blank lines with 0$.

Is there a way I can make this table dynamically expand and contract based on how many receipts there are? (obviously if there is 10 receipts, the lines 11-40 on the origional sheet sheet will be 0$.)

Also, can you make a similar thing for the "cash after count" table, so it expands, or just does not show up at all if there is nothing in the table.

Attatched is the spreadsheet (this does not include the extra worksheet for printing, as i was working on it at work).

**teylyn** · 02-13-2010, 04:07 AM

Hi abender,

it's kinda hard to suggest a solution when you don't include the worksheet that you want the solution for. Could you try and attach a file that includes the sheet that is to be printed? After all, that is your desired end result, no?

cheers

**Palmetto** · 02-13-2010, 08:32 AM

Is there a way I can make this table dynamically expand and contract based on how many receipts there are? (obviously if there is 10 receipts, the lines 11-40 on the origional sheet sheet will be 0$.)

Apply Auto-Filter and hide rows with zero values in the Amount column