How to populate data from one sheet and stack/append in another sheet automatically?
How to populate data from one sheet and stack/append in another sheet automatically?
You would need a worksheet change event handler monitoring the first four columns.
When a change is made, check if all four cells in the row are complete and, if they are, transfer the data to the second sheet. If all four cells in the row are not complete, exit the subroutine.
Trevor Shuttleworth - Retired Excel/VBA Consultant
I dream of a better world where chickens can cross the road without having their motives questioned
'Being unapologetic means never having to say you're sorry' John Cooper Clarke
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks