Automatically copy a row to another sheet.

[StruanReid]

Hi,

I hope that you are all well!

I would like some help with a formula to automatically copy a row from one sheet to another if a specific number is entered into a cell in that row.
So based on the attached excel sheet, if the number 10 is entered into column A then the row in which it is entered, in this case row A4 to L4 will be copied to sheet 2. If the number 4 is entered into column A then the row in which it is entered, in this case row A6 to L6 will be copied into sheet 3.

Hope this makes sense.

Thanks

[BadlySpelledBuoy]

Hi and welcome to the forum

A few clarification questions:
1) You mention formulas to copy data from one sheet to another but you've posted in the VBA section. Are you looking for formulas or a macro?
2) (If a macro solution required) You say "IF a specific number is entered" rather than "WHEN a specific number is entered". Does this mean you want the data to move when you click a button rather than when you actually enter the number in A?
3) In your actual workbook is there a way of deciding which sheet data gets copied to? i.e. 10 goes to Sheet2 and 4 goes to Sheet3 is fine for your example but are there more sheets in your workbook that need taking into account? It will make a difference to the approach taken.

BSB

[Keebellah]

Hi, welcome to the forum.
If your question really is about using a formula then the answer is that this is not possible to do with formula.
You will require a macro to do this. To achieve this you could start by recording a macro and and then enter the value as you state it and carry out the actions step by step.
When the first step is completed, stop the macro recording and then you can check the recorded macro to see what it did.
This macro can then be edited to suit your needs and can be applied to all events for that worksheet.
Recording a macro is the first step every starting VBA user has taken to learn how to work with macros.
There are many tutorials and explanations on-line one link I foudn fro you https://www.excel-easy.com/vba/examp...-recorder.html but there are many more.