Need some help getting this into VBA I have searched a couple of times not found exactly what I am looking for; I have a tab called "Excluded" and another called "Reconcilation", in the excluded tab I have a pivot that has been copy/pasted special. I am trying to "counta" the number of rows and then insert that number of rows into the reconcilation tab. The number of rows will change month by month however the insert point on the reconcilation tab will not. I assume I will need to count then insert the number of rows and then copy over the items into there specific columns. Any help would be greatly appreciated.
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
Insert Rows off a "counta" formula via Macro
- Thread starter CVBASIMON
- Start date
-
- Tags
- counta insert a row macro vba
Similar threads
