Consolidating Workbook/Aggregated Database

[kwasi_89]

Greetings All,

I need your assistance to consolidate the attached workbook... the information I want is on a monthly basis based on transactions (Issued/Received) for each stock item.

The consolidating information should include the following information:

Stock Item

Balance at Start of Month

Amount Received During the Month

Amount Issued During the month

Actual Inventory Balance at end of Month


Happy for any assistance or guidance

[oeldere]

See the attached file.

Please Login or Register  to view this content.

[kwasi_89]

Thanks for your help. However, that is not what i had in mind.

Please see attached file which indicates what exactly I am hoping to achieve.

[oeldere]

This is a totaly differant fie.

There are no data in it.

[kwasi_89]

I know but this new file is showing you what i want the consolidation file to look like...

Maybe might have to consider linking both Stores Record template file to the monthly report file

[kwasi_89]

I know but this new file is showing you what i want the consolidation file to look like...

Maybe might have to consider linking both Stores Record template file to the monthly report file

[oeldere]

I eave this one for other forummembers.