ExcelBanter - How do I preset data to auto copy to a certain page

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - How do I preset data to auto copy to a certain page (https://www.excelbanter.com/excel-discussion-misc-queries/61120-how-do-i-preset-data-auto-copy-certain-page.html)

wil4d

How do I preset data to auto copy to a certain page

I have a Macro that hides and copies visible cells to worksheet 3, but, I
have a certain row that needs to wait till the next page break befor copying
so that I don't have to manually adjust them. Moving them manually takes 25
minutes 2-3 times a day, if there is a way it would really save me.

All times are GMT +1. The time now is 09:04 AM.