taylorbrewed
06-22-2017, 05:54 PM
Hi, I'm new to excel and cant figure out if I need a macro or not.I have figured out how to reference text in a cell on another sheet in a column. I'm looking for a way to move the information from one column on a sheet to a column in a different tab and to have it constantly stay up top on the sheet in order of it being found on the other sheet. I hope this makes sense. Any help is appreciated. Thanks
Attached is my excel sheet. 19576
Information being referenced is "Sheet" Column A
I need this transferred over to tab "Source"
If text in column A= "Recipe" I need to Text from column B (Same Row) to be referenced on tab "Source" in Column A
If text in column A= "Source" I need to Text from column B (Same Row) to be referenced on tab "Source" in Column B
I need it to ignore all other text that might end up in this column in difference cells.
I want to have it ignore blanks and be moved to the top of tab "Source"
Attached is my excel sheet. 19576
Information being referenced is "Sheet" Column A
I need this transferred over to tab "Source"
If text in column A= "Recipe" I need to Text from column B (Same Row) to be referenced on tab "Source" in Column A
If text in column A= "Source" I need to Text from column B (Same Row) to be referenced on tab "Source" in Column B
I need it to ignore all other text that might end up in this column in difference cells.
I want to have it ignore blanks and be moved to the top of tab "Source"