visible row

Hi can someone help with the following code? I want to filter the "HR Advice & admin" sheets to display all rows which have no data in collumn ("N") then paste all rows displayed into "Sheet1". I want to exclude the top row to be copied and pasted into the second row on "Sheet1". What I have...

I'm trying to take a list of data, and filter it (This will be done outside of a macro). Once filtered, I want the macro to grab the visible line of data and past that row into a new workbook If I break this code up, it works, but not together. Getting error code 91 Help is appreciated...

I have two pivot tables, both tables have dates in one column and other column is the % difference from the top oldest date. I added a slicer to control both pivot table dates which works fine. Say the slicer is currently on 1/1/2017 and the prices are show % difference from 1/1/2017, now when...

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 row of the visible data only and paste it to another spreadsheet, when I currently try to do this with the code below the paste does the first 10 rows including...

How can I select in column A the first visible cell in thecolumn in a filtered table. Need someVBA code that will take me to the cell of the first visible row. If the first visible row is row 5 I want toselect A5. If first visible row is row12 I want to select A12. If first visible row is…