visible rows

I am looking to calculate the "Cst Info" data based on the filtered data available on the "Data" worksheet. I have so far tried searching the forum, but have been unable to find something similar. Example workbook uploaded here. This is how my "Data" worksheet looks like (after filtering for...

Hello Have a great day, I am very new to Macros and want to create a dynamic macro and automate my day to day task . I wrote code to copy data from other workbooks and append it on other workbook(testmac) I applied a filter and select the All amount which are greater than Zero in Column K Now...

Hi Excel Masters, I am working with a spreadsheet that does a data dump every month that is really messy, I'm trying to automate as much of the cleanup as possible. The only thing I'm stuck on with the VBA code is how to delete visible rows instead of specific rows as the number of rows with...

Hi guys, I have a simple operation which is driving me nuts! I have the following code (below) to copy my active worksheet and paste it at the end of my excel file in order to keep an archive of the report. The code works, however, this is an 8000 row report, with an auto filter - and when i...

I have a spreadsheet which each day will have a lot of hidden rows (different rows each day). I want to be able to copy the first ten rows of the visible data only for 3 columns (Column A,S,V) and paste it to another spreadsheet, when I currently try to do this with the code below the paste...

Hi everyone, I'm new to the forum and I'm really counting on your help. The problem I'm struggling with in excel is that I would like to create some kind of a filter or a drop down list for selected number of rows, which could only be made visible by entering a password. So selected rows...

I have not used arrays yet in VBA. However, I think using an array will be fast then the loop I am using now to determine the row number of the next visible row of autofiltered data. For example: I filter a set of data on specified fields and the results show the following rows as visible: 2...