I would like to fill the following worksheet based on data available in the differents file
I have sixteen months file which names as jan2005 to jun2005
i want formula or macro to be put in below workseet which will check the data in the sixteen months data and take the information from jan2005 a2 cell and put in b2 and a3 to c2 and a4 to e2 and b5 to f2 and a6 to g2 and a7 to h2 and a8 to i2 and for feb2005 the data to be filled in row 3.
thanks
I have sixteen months file which names as jan2005 to jun2005
i want formula or macro to be put in below workseet which will check the data in the sixteen months data and take the information from jan2005 a2 cell and put in b2 and a3 to c2 and a4 to e2 and b5 to f2 and a6 to g2 and a7 to h2 and a8 to i2 and for feb2005 the data to be filled in row 3.
thanks
Book1 | |||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|
A | B | C | D | E | F | G | H | I | |||
1 | MONTH | DATA1 | DATA2 | DATA3 | DATA4 | DATA5 | DATA6 | DATA7 | DATA8 | ||
2 | JAN'04 | ||||||||||
3 | FEB'04 | ||||||||||
4 | MAR'04 | ||||||||||
5 | APR'04 | ||||||||||
Sheet1 |