Urgent help with new Workbook

[visseresmeralda]

Good day,

I am new to macros on excel but I am trying to create a cash up workbook. This is what I want it to do:

First Sheet should be a summary of the month with each day. From there I want it to generate 4 worksheets for every day's cash up. (which should be Daily Cash up, Credit Card Sales, Cheque Sales & Account Sales).

The Daily Cash up Sheet must pull info from the other 3 and must allow me to input cash values manually. But the cc sales, cheques sales and account sales must be pulled from the other sheets.

After completion of cash up there should be a button on the Daily cash up sheet to say Finalise, where when it is pressed it summarises all totals on the first sheet. So when I open the workbook every morning, there should be a button on the first sheet to create a new 'cash up'.

Then there should also be a button on the first worksheet for month end, so that when you press month end it finalises the month and generates a new work book for the next month.

Only problem is, I do not know where or how to start. Even if you could email me or I you.

 

[npvrader]

Before you get concerned about writing a macro, I think you need to work through the spreadsheets and track the mechanical repetitive tasks you have to do - this will give you a design concept for the macro. I am struggling to help you because I don't know what a cash up report is, though I suspect it is a daily accounting/reconciliation of receipts. It would be helpful to post images of each of the 4 sheets so we could visualize what you are working with.

 

[visseresmeralda]

[TABLE="width: 1076"]
<colgroup><col><col span="4"><col><col span="4"><col></colgroup><tbody>[TR]
[TD="colspan: 4, align: left"]This is how the first sheet should look. From here I want to generate 4 new sheets daily, but while generating new sheets, the previous four should reconcile on this sheet.
[/TD]
[TD="colspan: 4"]Sustainable Living Concepts[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 4"][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 5"]Sales[/TD]
[TD][/TD]
[TD="colspan: 4"]Account Payments Received[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Cash Sales[/TD]
[TD]Account Sales[/TD]
[TD]C/C Sales[/TD]
[TD]Cheques Sales[/TD]
[TD][/TD]
[TD]Cash[/TD]
[TD]EFT[/TD]
[TD]C/C[/TD]
[TD]Cheques[/TD]
[TD]Balance due on Accounts[/TD]
[/TR]
[TR]
[TD]01/04/2014[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[visseresmeralda]

[TABLE="width: 495"]
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD="colspan: 2"]Date:[/TD]
[TD]01/04/2014[/TD]
[TD][/TD]
[TD]This is the main cash up sheet, where sheet one will get its info. Cash figures I need it insert manually but all the other info this sheet will get from the next 3 sheets
[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Cash Sales Total:[/TD]
[TD="align: right"]R -500.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Cashier:[/TD]
[TD="colspan: 2"]Esmeralda Visser[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 200.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 100.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 50.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 20.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 10.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 5.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 2.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 1.00[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 0.50[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 0.20[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 0.10[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD="colspan: 2"]R 0.05[/TD]
[TD="colspan: 2"]0[/TD]
[TD="colspan: 2"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Total:[/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="colspan: 2"]Cash Delcared:[/TD]
[TD="align: right"]R -500.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD]Actual[/TD]
[TD][/TD]
[TD]On POS[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Credit Card Sales Total:[/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD="align: right"]R 0.00[/TD]
[TD="align: left"]

<tbody>
</tbody>

[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Cheques Sales Total:[/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Account Sales:[/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Account Payment CC/Chq:[/TD]
[TD]R 0.00[/TD]
[TD][/TD]
[TD]R 0.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Account Payment EFT:[/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Account Payment Cash:[/TD]
[TD="align: right"]R 0.00[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="colspan: 2"]Cash Invoices:[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Inv nr[/TD]
[TD]Amount[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[visseresmeralda]

This is sheet nr 3, where sheet nr 2 will get some of its info.

[TABLE="width: 528"]
<colgroup><col span="5"><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Batch[/TD]
[TD]Visa[/TD]
[TD]Master Card[/TD]
[TD]Debit[/TD]
[TD] [/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD="align: right"]01-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]02-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]03-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]04-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]05-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]06-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]07-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]08-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]09-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]10-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]11-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]12-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]13-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]14-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]15-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]16-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]17-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]18-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]19-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]20-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]21-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]22-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]23-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]24-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]25-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]26-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]27-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]28-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]29-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]30-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[visseresmeralda]

THis is sheet nr 4, again where sheet nr 2 will get its info

[TABLE="width: 829"]
<colgroup><col><col><col><col><col><col><col><col><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 8"]Cheques to be banked[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD="colspan: 2"]Name of Cheques Holder[/TD]
[TD]Receipt Nr[/TD]
[TD]Invoice Nr[/TD]
[TD]Cheques Nr[/TD]
[TD]Amount[/TD]
[TD]Bank[/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]01 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]02 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]03 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]04 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]05 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]06 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD="align: right"]07 April 2014[/TD]
[TD="colspan: 2"] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]0[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[visseresmeralda]

This is the last sheet.

[TABLE="width: 1278"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col span="3"><col span="2"></colgroup><tbody>[TR]
[TD="colspan: 5"]Account Sale[/TD]
[TD] [/TD]
[TD="colspan: 9"]Account Payment[/TD]
[/TR]
[TR]
[TD]Date[/TD]
[TD]Name & Surname[/TD]
[TD]Receipt Nr[/TD]
[TD]Invoice Nr[/TD]
[TD]Amount[/TD]
[TD] [/TD]
[TD]Date[/TD]
[TD]Name & Surname[/TD]
[TD]Amount[/TD]
[TD]Receipt Nr[/TD]
[TD]Cash[/TD]
[TD]C/C[/TD]
[TD]Cheques[/TD]
[TD]EFT[/TD]
[TD]Total[/TD]
[/TR]
[TR]
[TD="align: right"]01-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]01-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]02-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]02-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]03-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]03-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]04-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]04-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]05-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]05-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]06-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]06-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]07-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]07-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
[TR]
[TD="align: right"]08-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]08-Apr-14[/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD] [/TD]
[TD="align: right"]R 0.00[/TD]
[/TR]
</tbody>[/TABLE]

 

[visseresmeralda]

I posted samples of how I want the work sheet to look. I want to be able to generate new Sheet 2 - 5 daily for previous days revenues. Then on last day of month I want it to generate a complete new workbook for the new month.