Hi all,
i have looked throught threads and cant seem to find what i need,
basically i need a formula to put data from one sheet into another,
basically
in audit! if Column F contains Data and Column C has -2 copy entire row into output! Column A starting at Row6
i want this to expand further down because after the end i want another formula similar to this where if Column C has 4
then insert it into a Column Below a Heading but the number will change wont it?
or is it best to have a code written where i have all the values in the output, and only show fields if Row 6 contains data and Row C has value -2.
what are your thoughts?
thanks.
i have looked throught threads and cant seem to find what i need,
basically i need a formula to put data from one sheet into another,
basically
in audit! if Column F contains Data and Column C has -2 copy entire row into output! Column A starting at Row6
i want this to expand further down because after the end i want another formula similar to this where if Column C has 4
then insert it into a Column Below a Heading but the number will change wont it?
or is it best to have a code written where i have all the values in the output, and only show fields if Row 6 contains data and Row C has value -2.
what are your thoughts?
thanks.
