Macro should bring the values from the master file without changing the previous months.

[hamad.fatima]

Help Please.

I have a master file with the monthly forecast data - JAN to DEC
I have a file B which is the same fromat......
there is reffernce cell in FILE B= A1= (current month )
I want the macro to bring me the forecast numbsers from the master
file.
in a way IFF

Current month = Aug
then macro should only bring back the data from SEPT- DEC

without changing the previous months

if Current month = SEPT
then macro should only bring back the data from OCT- DEC
wihtout changing the previous months

I would greatly appreciate someones' help

Thanks

 

[Cindy M.]

I have a master file with the monthly forecast data - JAN to DEC

I have a file B which is the same fromat......
there is reffernce cell in FILE B= A1= (current month )
I want the macro to bring me the forecast numbsers from the master
file.
in a way IFF

Current month = Aug
then macro should only bring back the data from SEPT- DEC

without changing the previous months

if Current month = SEPT
then macro should only bring back the data from OCT- DEC
wihtout changing the previous months

Well... If you don't tell us which application these files are in,
no one can help.

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17
2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow
question or reply in the newsgroup and not by e-mail

 

[hamad.fatima]

These files are in excel format .....sorry for not mentioning before

 

[Cindy M.]

These files are in excel format .....In that case, since you haven't gotten any response here, I recommend
you try in the excel.programming newsgroup. That's where the specialists
congregate

Cindy Meister
INTER-Solutions, Switzerland
http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005)
http://www.word.mvps.org

This reply is posted in the Newsgroup; please post any follow question
or reply in the newsgroup and not by e-mail