Duplicating data in different sheets

[Jayfaku]

Is there a possibility to duplicate cell entry in another sheet?

Say I enter columns A:H in worksheet 1
In column B I have a drop down that lets me select MTI, LTI, FAI

Based on each of this selection is there a possibility that if MTI is selected that in worksheet 2 column J is updated

The other option is doing the countif for MTI and then update number in the sheet 2

 

[LFKim2018]

Is there a possibility to duplicate cell entry in another sheet?

Say I enter columns A:H in worksheet 1
In column B I have a drop down that lets me select MTI, LTI, FAI

Based on each of this selection is there a possibility that if MTI is selected that in worksheet 2 column J is updated

The other option is doing the countif for MTI and then update number in the sheet 2

try this: (copy your work and test it there - do not test directly on your work)
say you want your worksheet 2 C3 to be equal to worksheet 1 C3
enter in worksheet 2 C3 =sheetname!C3 (sheetname = name of worksheet 1)
and so on - it might be quite tedious as you have to enter them in all of the cell you want to update on worksheet 2.
or maybe somebody can give you a VBA to automate the results..
HTH