yasarayhanka
08-28-2007, 09:44 AM
Here is what I am trying to do,
I have 5 cells which represent the weeks of the month that I want to be able to change to the current months weeks like 200731, 200732 ect. (also for the months which have 4 weeks I should be able to leave the last cell blank)
and I want the macro to read the data written in these designated cells and pull the data in another spreadsheet for these weeks. each week has many data. also I need to capture the data at the right side of the week column. and everyday this data changes so macro should be relavent.
I know i need to use case function, but I could not figure it out yet. Any help will be appreciated.
Thanks,
Yasar
I have 5 cells which represent the weeks of the month that I want to be able to change to the current months weeks like 200731, 200732 ect. (also for the months which have 4 weeks I should be able to leave the last cell blank)
and I want the macro to read the data written in these designated cells and pull the data in another spreadsheet for these weeks. each week has many data. also I need to capture the data at the right side of the week column. and everyday this data changes so macro should be relavent.
I know i need to use case function, but I could not figure it out yet. Any help will be appreciated.
Thanks,
Yasar