Automatically copying a row of data to another tab

[Patrick L]

I want to enter a value into a cell and that triggers multiple columns in that row to be copied to another tab in the same file. I have attached an example of the file so you can see which columns I need to copy and which ones I do not. The data is entered on the DMC General Data tab and if applicable, "100" is entered into column "AC". That is the trigger cell to copy the matching columns in that row to the second tab called "Service Contracts", in the next available blank row.

If there is another way of copying the data other than entering a trigger into a cell, I'll be glad to use that method, even if it is a manual button that starts a macro. As you can tell, I don't know what I am doing here so thanks in advance for your help.

Patrick L.

[Azam Ali]

Hi Patrick L

find the formula in the attatched file

[Patrick L]

Thanks very much.