I have a problem. I have button that copies a row from one sheet and pastes it on another sheets first empty row. It works just fine, untill autofilter is used on page. When some of the parts are filtered the table gets shorter and when that button described above is used it leaves empty space...
I have a problem with Excel. Ive made a button that copies pre-made information from row and adds it on first empty row at end of a table on another sheet. Problem is that when a row is removed or cleared the first empty row is actually row after the row where data was last time copied.
Like...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.