Dear All,
Working with a workbook carrying multiple sheets for FY 14-15. Sheet names are April-14, May-14 contd......
In the Enquery sheet I have few columns like the snap:
I have mentioned desired results in the cells. But if I change the date & month it should automatically calculate. I mean if i mention 01-May data would be auto calculated from may sheet only.
Is it possible using a formula. if possible, please provide me.
thanks in advance.
Regards
RAMU
Working with a workbook carrying multiple sheets for FY 14-15. Sheet names are April-14, May-14 contd......
![wrkbook.jpg](/board/proxy.php?image=http%3A%2F%2Fs9.postimg.org%2Fs1bm8ielr%2Fwrkbook.jpg&hash=41b74195dcbd1f8118eb2c1c9556f373)
In the Enquery sheet I have few columns like the snap:
![sheet1.jpg](/board/proxy.php?image=http%3A%2F%2Fs17.postimg.org%2Fymiqgi07j%2Fsheet1.jpg&hash=4f69c79c0b2e2a5255b7af8b1be3d056)
I have mentioned desired results in the cells. But if I change the date & month it should automatically calculate. I mean if i mention 01-May data would be auto calculated from may sheet only.
Is it possible using a formula. if possible, please provide me.
thanks in advance.
Regards
RAMU