Function for counting Worksheets?
Hi,
1. In the same cell in each sheet enter something (anything), say you enter
the date into cell A1 on each invoice, then
=COUNTA(Sheet1:Sheet300!A1)
Where Sheet1 is the first sheet in the workbook and Sheet300 is the last
sheet (left to right) in the spreadsheet. When you add a new sheet, insert
it between the first and last sheet. If necessary make Sheet300 a dummy with
nothing in it.
If this helps, please click the Yes button.
--
Thanks,
Shane Devenshire
"JonWardellBuilders" wrote:
I need to know a function that i can enter into a cell that will give me the
total number of worksheets i have in a specific Workbook.
it will serve as an invoice number because i create a new sheet for each
invoice i have.
thank you.
--
Jon Robershaw
Wardell Builders, Inc
|