Jonathon.Taylor
New Member
- Joined
- Aug 17, 2011
- Messages
- 10
Hey everyone,
I'm organising a social club for my department, and as a result of it we're looking to create a spreadsheet to monitor cash flow and stock.
I've currently got it laid out, as shown in the below image. Let me know if the link doesn't work, it may because I'm still a new user to this Message Board.
On a separate worksheet I'm creating a Stock Take spreadsheet. I'm not sure if it's going to be possible or feasible, or wether the original sheet above would need to be modified. But I'd like the stocktake sheet to Search for all cells in Column C, 'Product', and when it finds a given text. E.g. V Cans. To add the value found in the same row, in Column D.
E.g. C4, C10 = V Cans. So add cells D4 and D 10.
This would then be modified for each line shown in the Stock Sheet to search for the relevant product.
Any ideas on the most appropriate code or formulae?
I'm organising a social club for my department, and as a result of it we're looking to create a spreadsheet to monitor cash flow and stock.
I've currently got it laid out, as shown in the below image. Let me know if the link doesn't work, it may because I'm still a new user to this Message Board.
On a separate worksheet I'm creating a Stock Take spreadsheet. I'm not sure if it's going to be possible or feasible, or wether the original sheet above would need to be modified. But I'd like the stocktake sheet to Search for all cells in Column C, 'Product', and when it finds a given text. E.g. V Cans. To add the value found in the same row, in Column D.
E.g. C4, C10 = V Cans. So add cells D4 and D 10.
This would then be modified for each line shown in the Stock Sheet to search for the relevant product.
Any ideas on the most appropriate code or formulae?
