Automatic data updation from other sheets to master sheet

Dear All,

I will enter Data by Datewise in different sheets like Purchase entries in Purchases sheet, Sale entries in Sales sheet, and so on ..

I have another sheet named Master, Now the required result/data is

If i entered a transaction in particular sheet, it will automatically be updated in Master sheet.

Notes:

1) It's not necessary to include product code coloumn values in Master sheet.

2) Receipts and Payments sheets don't have Qty and Price coloumns.

3) I have attached the screenshots and Excel file.

4) find them for better idea and please help me.

Thank you very much in advance.

can anyone solve the problem ..?

help be greatly appreciated..?

I don't know that there's an easy way to do this with a formula, but I was able to get one to work with a few minor modifications. If you add a new column "A" to each of your sub-sheets and label it with the "Type" value, then add a new column "F" to the sheet "Receipts" and fill it with zeroes, then the following formula should work:

=IFERROR(IFERROR(IFERROR(IFERROR(INDEX(PURCHASES!$A$3:$J$500,SMALL(IF(PURCHASES!$A$3:$A$500="Purchases",ROW(PURCHASES!$A$3:$A$500)-2),ROW(1:1)),MATCH(A$2,PURCHASES!$A$2:$J$2,0)),INDEX(SALES!$A$3:$J$500,SMALL(IF(SALES!$A$3:$A$500="SALES",ROW(SALES!$A$3:$A$500)-2),ROW(1:1)-COUNTIF($A2:$A$3,"<>*Sales*")),MATCH(A$2,SALES!$A$2:$J$2,0))),INDEX(RECEIPTS!$A$3:$K$500,SMALL(IF(RECEIPTS!$A$3:$A$500="RECEIPTS",ROW(RECEIPTS!$A$3:$A$500)-2),ROW(1:1)-COUNTIF($A2:$A$3,"<>*RECEIPTS*")),MATCH(A$2,RECEIPTS!$A$2:$K$2,0))),INDEX(PAYMENTS!$A$3:$J$500,SMALL(IF(PAYMENTS!$A$3:$A$500="PAYMENTS",ROW(PAYMENTS!$A$3:$A$500)-2),ROW(1:1)-COUNTIF($A2:$A$3,"<>*PAYMENTS*")),MATCH(A$2,PAYMENTS!$A$2:$J$2,0))),"")

Paste it into A3 of your "MASTER" sheet, then confirm it with Ctrl + Shift + Enter instead of the usual Enter. Fill it down through as many rows as you think you'll need, then fill right through all of your columns. Now, when you add a new, complete entry to one of your four sub-sheets, that entry should automatically be added to your MASTER sheet.

The formula is currently set to cover up to 500 entries on each of your sub-sheets, but that can be modified by changing the "500"s in the formula to something more suitable.

I've attached a sample to make things a bit clearer. Let me know how it goes...

Wow,
what a great heart.
thank you so much brother. surely Tomorrow I will inform you is that working or not.

because now i'm in mobile.

thank you so much

dear brother,

i pasted that formula in my master!a3, but it is giving only purchase and sale transactions.

please see the attachment and edit the formula.

thanking you brother

If you're looking for a non-VBA solution, I've fixed your attachment in post #5. The formula in post #5 had the ranged shifted one column to the right for receipts and payments. It should be correct in the workbook attached below.

If VBA is an option for you, it's worth experimenting with micope21's solution. VBA will generally be faster for this type of adjustment, since it won't need to recalculate everything with each new entry. The downside is that some offices won't like VBA and it operates without Excel's "Intellisense", so it can be challenging to adjust if you need to tweak things a little. Play with both options and see what works for you.

THANKS FOR ALL REPLIES.

THE PROBLEM SOLVED.

THANKS TO nfsales, cantosh, micope21