Data entry in one sheet and automatic goes to another as per column header name.

Dear sir,
I am having trouble that I am typing the same thing in all of my sheets and deleting rows, insert rows manually also copying and pasting is very slow process for me. Please help me to make it automatic. I need help please. I have attached my document sample here. The sheets name BOQ is the primary and I type everything there manually, I want is that what I type should go in every sheets automatic, example: BOQ Description should goes to Agreement Sheets "Description", Rate goes to Rate column of another sheets, Quantity goes to Quantity of another sheets and like that. And If there is not enough row for other sheets, automatic insert new rows there. Is there any way for this Please help.

Try:

=IF(BOQ!$A2="","",IFERROR(INDEX(BOQ!$A2:$E2,,MATCH(A$1,BOQ!$A$1:$E$1,0)),""))

copied across and dnown. Specfication will be blank, as it is not present on the source sheet.

Originally Posted by Glenn Kennedy

Try:

=IF(BOQ!$A2="","",IFERROR(INDEX(BOQ!$A2:$E2,,MATCH(A$1,BOQ!$A$1:$E$1,0)),""))

copied across and dnown. Specfication will be blank, as it is not present on the source sheet.

Dear Sir, Thanks for your support to me. But sir, In my previous excel file, I could not express my problem. Now I upload my original Sheets in this thread. I would like to request you to please suggest me again one more and last time. Please sir.

An empty sheet is not much use.

Put some values in the sheet, so that I know what you want to see, where you want to see it.

and a few rows, showing your expected results are .... where?

I know that; but there are NO RESULTS in the destination sheet.

Please amend your file.

The agreement sheet and the comparative sheet are BLANK.

What am I supposed to copy FROM where TO where.

I want to see BOTH parts.

OK.

Dark Green = change in formatting to avoid complications caused by merged cells.

Other shades, different formulae to deliver the desired result.

I inserted as few extra rows as you had not allowed enough room for the results.

The best way to do this is to set a maximum length for BOQ (say 50 rows) and extend the formula in the other two sheets also to 50 rows.

If you want the sumaries at the bottom of the destination sheets to move to align with the number of active rows in BOQ, you will need VBA.