I was hoping to create something similar, by moving data from four sheets with identical columns into one master, either by a button or when closing excel. I have looked through hundreds of forums however I have no idea on how to link all the ideas together)
I want the data from the four sheets to be cut from the original sheets and pasted into the master, each line should be placed on its own line and not over any previously entered data.
This would ideally be completed daily therefore the "on-closing" option would probably be the best
Any help would be appreciated. The sheet will be a shared document if that makes any difference.
Cheers,
Stu
Bookmarks