Copy a row of data from one sheet to another [Closed]

Report
-
Hello,

Trying to copy a row of data from a roster on a sheet into a new sheet when a cell states Line 1
ie When i type Line 1 etc i want excel to automatically take the row of data for Line 1 on my data sheet and insert it into the target row, cannot use VBA
Appreciate help, i am a beginner

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!