Hi
I have a worksheet that has 1 column populated from another data sheet with a formula applied to the cells and a relevant date, the results are shown in c1:c12. I have created a scrollbar to click backwards and forwards through the dates hence changing the cells in the column as I click! I wanted to be able to have a macro that automatically copy and pastes the column to another sheet as I click through the dates, creating another database of the cells with my formula applied, hence different results.
so. is it possible to have a macro that... on Scroll_bar click copies and pastes column contents to another sheet , then repeats and places next set of data in the next column?
Any bit of help would be greatly appreciated.
Thanks