LinkBack URL
About LinkBacks
Say you have the number 25 and you want to count its occurances on different sheets in a workbook and then display the amount that 25 occurs in a cell.
Can this be done?
Say you have the number 25 and you want to count its occurances on different sheets in a workbook and then display the amount that 25 occurs in a cell.
Can this be done?
Hi allenratta,
If the sheet number in the workbook is fixed, you can use formula, else vba macro is best fit. thanks.
Regards,
DILIPandey
<click on below 'star' if this helps>
DILIPandey, Excel rMVP
+919810929744 (India), +971528225509 (Dubai), dilipandey@gmail.com
If the sheets are called Sheet1, Sheet2 etc then you can use the formula below. Adapt the range to suit
Formula:
Please Login or Register to view this content.
If the sheet names are different create a named range (in this case named range is called "MySheets") listing the sheet names and use the formula below. Adapt the range to suit.
Formula:Please Login or Register to view this content.
If my solution worked (or not) please let me know. If your question is answered then please remember to mark it solved
Computers are like air conditioners. They work fine until you start opening windows. ~Author Unknown
RE-POSTED BECAUSE WASN'T REGISTERED AS A REPLY
If the sheets are called Sheet1, Sheet2 etc then you can use the formula below. Adapt the range to suit
Formula:Please Login or Register to view this content.
If the sheet names are different create a named range (in this case named range is called "MySheets") listing the sheet names and use the formula below. Adapt the range to suit.
Formula:Please Login or Register to view this content.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks