Macro To Add New Worksheet

I have a spreadsheet with a worksheet for each month, so as a new month begins I add a new worksheet using a macro

Each worksheet has 5 columns:

A = Vendor, B = Date, C = Debits, D = Credits, E = Balance

Row 30 contains the totals for columns C, D, & E, cell A30 contains the text Totals

The macro I use is as follows


VBA:

Please Login or Register  to view this content.

The problem I have is occaisionally extra rows are added so the totals may not be in row 30

Is there any way that the macro can be changed so that it looks for the word Total in column A and then reads the contents of the corresponding cell E? to transfer that total to cell E2 on the next worksheet

Also how can I make the clear cells part of the macro so that it clears cell down to the row immediately above the row with Totals in cell A?

Thanks in advance for any help

Paul

I hesitate to reply as my VB is not the best, but there are no other replies..

Try adding

Please Login or Register  to view this content.

and then paste into cell on the new sheet


Hope this helps
Willow

I notice a few others have replied since I started looking at this. Anyway....

I think you are saying that normally A30 contains Totals, but sometimes it is cell A31 or A32 etc. If I can assume that ONE cell in column A at or below A30, then the following code will find the cell for you.

Please Login or Register  to view this content.

Matt