Hello,
Need to copy rows of data based on a range of dates from multiple work sheets (Name1,Name2,Name3) and looking at dates on each row in column “M” to a predefined work sheet (Budget). Using either a calendar form or message box initiated from a button on the predefined work sheet “Budget”. The data on work sheet “budget” will be overwritten each time excluding the top row, as this will be a header. Normally I can cannibalize found code enough to make it work, but have no idea on this one.
To further complicate things the first two sheets (Dropdown,Insert) are normally hidden, work sheet (Name1,Name2,Name3) and the work book itself is protected and shared.
Hope someone can help, Thanks
Bookmarks