Formula taking ref from multiple sheets

[RAMU]

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

 

[Andrew Poulsom]

Have a look at the INDIRECT function in Excel Help.

 

[RAMU]

Have a look at the INDIRECT function in Excel Help.

Dear Sir,

Thanks for you reply. I was trying to do but not getting result. Can you please help me sir.
It will be a gr8 help for me.

Regards
RAMU

 

[Andrew Poulsom]

What did you try that didn't work?

 

[RAMU]

After getting your reply, I was going thru help of excel. There detail of Indirect function was only for few lines. But reference was not clear to me. I just took a small instance but was confused how would i proceed. And was not getting result from that example.

Regards
RAMU

 

[RAMU]

Pls help. I have been trying but honestly cant get any solution.

Regards
RAMU

 

[Aladin Akyurek]

Pls help. I have been trying but honestly cant get any solution.

Regards
RAMU

Images are not that helpful... Hard to read/inspect and nothing can be done with in Excel.

What is your formula just for April-14 if you have or set up one?

 

[RAMU]

Dear Mr. aladin,

I don't have any idea whether it can be possible or not in excel. I did not have any formula for any sheet. In April-14 sheet there are few basic formulas but for enquery sheet I couldn't. My sheets are just alike:

				Tue	Wed	Thu
		ITEM	RACK	01-04-14	02-04-14	03-04-14
GROUP	S. NO.	DESCRIPTION	NO	Op stk	Rcvd	Issue	Cl stk	Op stk	Rcvd	Issue	Cl stk	Op stk	Rcvd	Issue	Cl stk
		Anabond	47	5			5	5	5		10	10	5	2	13
		Loctite 406	45	6			6	6		1	5	5			5
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0
							0	0			0	0			0

<colgroup><col><col><col><col><col span="12"></colgroup><tbody>
</tbody>

For enquery sheet my desired results are mentioned below:

DATE	03-Apr				MTD	04-Apr		ITEM	Anabond
ITEM	Anabond				ITEM	Anabond
OPENING	RECEIVE	ISSUE	CLOSING STOCK		RECEIVE	ISSUE			RECEIVE	ISSUE
								Apr-14	10	5
10	5	2	13		10	5		May-14
								Jun-14
								Jul-14
								Aug-14
								Sep-14
								Oct-14
								Nov-14
								Dec-14
								Jan-15
								Feb-15
								Mar-15

<colgroup><col span="3"><col><col span="7"></colgroup><tbody>
</tbody>

I thought that it may be possible but was not sure. In case of "INDIRECT" function I am little newbie.

Regards

 

[RAMU]

Dear Mr. Aladin,

Here I am giving the sheets again:


Sheet Enquery:

DATE	03-Apr				MTD	04-Apr		ITEM	Anabond
ITEM	Anabond				ITEM	Anabond
OPENING	RECEIVE	ISSUE	CLOSING STOCK		RECEIVE	ISSUE			RECEIVE	ISSUE
								Apr-14	10	5
10	5	2	13		10	5		May-14
								Jun-14
								Jul-14
								Aug-14
								Sep-14
								Oct-14
								Nov-14
								Dec-14
								Jan-15
								Feb-15
								Mar-15

<COLGROUP><COL style="WIDTH: 48pt" span=3 width=64><COL style="WIDTH: 77pt; mso-width-source: userset; mso-width-alt: 3766" width=103><COL style="WIDTH: 48pt" span=7 width=64><TBODY>
</TBODY>

Sheet: April-14

				Tue	Wed	Thu	Fri	Sat
		ITEM	RACK	01-04-14	02-04-14	03-04-14	04-04-14	05-04-14
GROUP	S. NO.	DESCRIPTION	NO	Op stk	Rcvd	Issue	Cl stk	Op stk	Rcvd	Issue	Cl stk	Op stk	Rcvd	Issue	Cl stk	Op stk	Rcvd	Issue	Cl stk	Op stk	Rcvd	Issue	Cl stk
		Anabond	47	5			5	5	5		10	10	5	2	13	13		3	10	10			10
		Loctite 406	45	6			6	6		1	5	5			5	5			5	5			5

<COLGROUP><COL style="WIDTH: 48pt" width=64><COL style="WIDTH: 34pt; mso-width-source: userset; mso-width-alt: 1645" width=45><COL style="WIDTH: 167pt; mso-width-source: userset; mso-width-alt: 8118" width=222><COL style="WIDTH: 53pt; mso-width-source: userset; mso-width-alt: 2596" width=71><COL style="WIDTH: 30pt; mso-width-source: userset; mso-width-alt: 1462" span=20 width=40><TBODY>
</TBODY>

 

[Aladin Akyurek]

Thanks. It's hard to interpret "Enquery", showing a two part exhibit. Would you also precise the actual result you expect?