Hey Guys, is there a a simple If/then statement that can do the following? Or do I need to venture into Macros?
Basically if column A contains "text X" copy the whole row to the next available line on sheet 2. And if column A contains "text Y" copy the whole row to the next available line on sheet 3. If it helps I only have 3 text strings that I need to use (So "X", "Y", "Z").
if(A1="x", Copy to sheet2,....something something?
Thanks for any help!
Edit:It occured to me there may be a better way to get to my end goal, so I should post that too. I have rows of data that gets classified in 1 of 3 (X, Y,Z) ways. I want to be able to manipulate and graph all the data that only falls under X or Y or Z.
Bookmarks