Help!

[eios]

Morning/ Afternoon!

I was wondering if someone here could give me a hand in either creating a formula or a bit of code to do a certain job for me.

So here's what I need!

I have created ledger cards that show issues and receipts of stock items and their current balance of that item. I have then created a separate sheet with all our items on it. What I would like for this separate sheet to do is capture the most up to date balance from G** in the Ledger Card and place it in the Ledger Check Sheet against the appropriate item.

The pictures attached will show you what I mean.

As you can see as the Ledger Cards are used the balance will move down the lines within the G column. So how to capture this balance stumps me.

Thanks for your help in advance!

Kyle.

If the images are not loading you can see both of them them from here

 

[Trevor G]

From the image you have uploaded I assume each veg type has its own ledger, and you are adding rows of data with the values going into Column G so the formula you need on the Ledger would be a SUM of column G for each sheet.

So an example would be

=SUM(Sheet1!G:G)

 

[eios]

Thanks Trevor G,

Your formula didn't work exactly but it gave me the idea and solution for what it needed to be.

The end result was this:

='QF CARROTS 2KG'!G11+SUM('QF CARROTS 2KG'!E12:'QF CARROTS 2KG'!E403)-SUM('QF CARROTS 2KG'!F12:'QF CARROTS 2KG'!F403)

 

[Trevor G]

Pleased to read you have a solution.