Hi All
i have 5 sheets in a workbook (Sheet1, sheet2,sheet3,sheet4, sheet5). i want to count column c in all the five sheets and store the values in sheet 6. So any suggestion to proceed further how to achieve this and if these sheets are in a different workbook can we declare array in the current workbook and get values . i Tried the following code (actually i did not know how to input the logic here)
Any suggestions please
Please Login or Register to view this content.
Last edited by grkchakri; 01-16-2019 at 05:23 PM.
Never confuse a single defeat to the final defeat.
The best way I believe is to iterate through the worksheets using the office object model, e.g.
Please Login or Register to view this content.
A more detailed example..
Please Login or Register to view this content.
Last edited by 1aaaaaaaaaaaaaaa; 01-16-2019 at 05:48 PM.
Count what in Column C.
=COUNTA(Sheet1:Sheet5!C:C) will returnt he number of filled cells in column C of all sheets between Sheet1 and Sheet5
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
Please Login or Register to view this content.
Thank you joli,mikerickson, poizhan for your help.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks