M
mluetkem
I'm looking for a simple way to copy a fixed size block of data to a
specified worksheet from any number of other worksheets in a workbook
based on say a drop down list of the available worksheets in the
workbook. I have an application that reads from Excel a data file
(lets say it is a constant 10 row by 10 column) data set. So the Main
sheet (call it "MAIN") needs to be populated with this same data (10x10
array) from the other date specific worksheets containing the same
10x10 data set but for specific days of the year. So in the MAIN sheet
I would like to simply select a date from a drop-down list and either
by clicking or button or simply selecting the new data from the
drop-down list the data from the DATE worksheet (10x10) would populate
the MAIN worksheets area with the 10x10 array. Any ideas?
specified worksheet from any number of other worksheets in a workbook
based on say a drop down list of the available worksheets in the
workbook. I have an application that reads from Excel a data file
(lets say it is a constant 10 row by 10 column) data set. So the Main
sheet (call it "MAIN") needs to be populated with this same data (10x10
array) from the other date specific worksheets containing the same
10x10 data set but for specific days of the year. So in the MAIN sheet
I would like to simply select a date from a drop-down list and either
by clicking or button or simply selecting the new data from the
drop-down list the data from the DATE worksheet (10x10) would populate
the MAIN worksheets area with the 10x10 array. Any ideas?