Formula required

[gomathi7]

Hi all , find enclosed the file, wherein i am looking for a consolidated ledger account in main sheet. to be more clear if i select a product it will be appearing in C4 of main sheet, below to this i would like to capture the entire transactions of this product. Anybody any idea

[:) Sixthsense :)]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

[Fotis1991]

..this i would like to capture the entire transactions of this product. Anybody any idea

There are some ideas for this but:

First you have to amend your title according to rule 1 of our forum that says:

.

.1. Use concise, accurate thread titles. Your post title should describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change the title of the thread, click EDIT on the original post, then click the Go Advanced button, then change the title. If two or more days have passed, the EDIT button will not appear, and you need to ask a moderator to change the title.

Then explain a little more from where can we capture the entire transactions of this product?

[gomathi7]

There are some ideas for this but:

First you have to amend your title according to rule 1 of our forum that says:

.

Then explain a little more from where can we capture the entire transactions of this product?

headings being constant data to be captured from Receipts sheet and Issues Sheet

[arlu1201]

Gomathi,

You need to change the title of your 1st post. Follow the instructions given in post 2.

[Fotis1991]

Thanks for the explanation. Now more the only thing that you have to do for getting some suggestions is to change your title as our request!