Hello
Trying to write a macro to cut up a sheet, but im not very good at visbasic. I've got a sheet full of rows of data, with a one blank row gap every so often. I want a macro that works its way down the rows and when it gets to an empty row (or the empty cell of an empty row) it cuts everything below to another sheet. Then i could run it again on that sheet and keep on doing that till all the data groups are on. Couldn't find anything like this on other posts.
Can anyone help?
Thanks
Trying to write a macro to cut up a sheet, but im not very good at visbasic. I've got a sheet full of rows of data, with a one blank row gap every so often. I want a macro that works its way down the rows and when it gets to an empty row (or the empty cell of an empty row) it cuts everything below to another sheet. Then i could run it again on that sheet and keep on doing that till all the data groups are on. Couldn't find anything like this on other posts.
Can anyone help?
Thanks