Hello forum..
I have multiple worksheets arranged by month Jan-20 to Mar-20 each worksheet columns are consistent - what I am aiming to do is to summarise /list each column data from each worksheet if value is <>0 into another worksheet.
Please Login or Register to view this content.
to summarise List below in another worksheet to show data if value header 7 <> 0
Any suggestions would be much appreciated.Please Login or Register to view this content.
Rez
Last edited by JBeaucaire; 03-27-2020 at 02:04 PM.
Please Login or Register to view this content.
Any code provided by me should be tested on a copy or a mock up of your original data before applying it to the original. Some events in VBA cannot be reversed with the undo facility in Excel. If your original post is satisfied, please mark the thread as "Solved". To upload a file, see the banner at top of this page.
Just when I think I am smart, I learn something new!
Thank you but I am looking for formula rather than vb codes.Originally Posted by JLGWhiz
Please Login or Register to view this content.
You will have it in case no one provides a formula for you.
Thank you JL
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks