I want to set up a way for me to insert some information into a table on excel and if a certan word is input then it will copy that line of info to a another sheet within the spreadsheet have you got any ideas the help would be much appreciated

There are a myriad of ways to do this with formulas or with macros. Knowing which would be best is determined by your final workbook layout.

What does the INPUT sheet actually look like?
When does the "copy" need to occur in the input process?
Does it need to happen in realtime or just when the "other" sheet(s) are viewed?
Is VBA even an option? (not everyone allows macros to be enabled on their systems)

Click GO ADVANCED and use the paperclip icon to post up a copy of your workbook. Make sure the workbook demonstrates your desired results if possible. Use BEFORE/AFTER sheets if that helps make it clearer.

Quote:

---

Originally Posted by gazzalloyd218

i want to set up a way for me to insert some information into a table on excel and if a certan word is input then it will copy that line of info to a another sheet within the spreadsheet have you got any ideas the help would be much appreciated

---

If your "line of info" is in one column of data, you can search the column for a word using just the formulas FIND, and IF. I will attach a spreadsheet as an example. The data is on sheet 1. The searched for word and info containing the search word appears on sheet 2. You can change the search word in cell a2 to whatever you want.