summary report from all sheets as an present date

[saraf\(vsnl\)]

i have an excel sheet where i keep a record of stock of different items
under the following heads :-

1. date
2. opening balance
3. issued
4. receipt
5. closing balance

i want create a sheet where the item names will be displayed in one column
and the cell next to the relevant cell will display the closing balance of
that item as at that date.

any help will be gr8ly appreciated

thanks in advance

 

[J.E. McGimpsey]

One way:

Assume your sheet with the records of stock is Sheet1, and that the
item name will be in cell A1 of Sheet2. Then in Sheet2:

B1: =VLOOKUP(A1,Sheet1!A:E,5,FALSE)

 

[saraf\(vsnl\)]

I am sorry but this is not what i am looking for.

Actually , I got it all wrong

There are different sheets in the workbook , all of them containing details
about a particular item.
every row in a sheet displays the stock position as at a particular date.
there are about 50 items

I want to create a separate sheet which will be sort of a summary report. I
want that sheet to display the item name in one column
and the stock position of that item in the adjacent column as at today.

I cant get a formula that will relate the cell containing the stock position
,in the summary sheet , to the cell in the other sheets because that cell
has to be selected according to the date

for eg.

cell A1 contains the date and cell E5 conatins the stock position. all this
in sheet 2
i can relate a cell in sheet 1 to cell A1 in sheet 2, but i cant get the
formula to relate it to cell E5
moreover, i have to scan the entire date column to obtain the deisred date.

Please help !!!

 

[dvt]

There are different sheets in the workbook , all of them containing
details about a particular item.
every row in a sheet displays the stock position as at a particular
date. there are about 50 items

I want to create a separate sheet which will be sort of a summary
report. I want that sheet to display the item name in one column
and the stock position of that item in the adjacent column as at
today.

I cant get a formula that will relate the cell containing the stock
position ,in the summary sheet , to the cell in the other sheets
because that cell has to be selected according to the date

for eg.

cell A1 contains the date and cell E5 conatins the stock position.
all this in sheet 2
i can relate a cell in sheet 1 to cell A1 in sheet 2, but i cant get
the formula to relate it to cell E5
moreover, i have to scan the entire date column to obtain the deisred
date.

In Sheet2, enter the date of interest in cell A3. In cell A4, enter this
formula:

=VLOOKUP(A3,Sheet1!A1:E5,5)

I think it will do what you wish.

Dave
dvt at psu dot edu

 

[saraf\(vsnl\)]

Thanks a lot !!!!!

It worked gr8

In Sheet2, enter the date of interest in cell A3. In cell A4, enter this
formula:

=VLOOKUP(A3,Sheet1!A1:E5,5)

I think it will do what you wish.

Dave
dvt at psu dot edu