Cleaning Data into easy to view report
 

Hi,

I have a large set of data giving sales information by customer by
month over a period of time with each customers data held in a row.
Within each row are two calculations that define whether that customers
data needs to be put into a another report.

Im a relative macro and vba novice, and struggling to find a non manual
solution.

Really all I need is a way to assess a set of data and depending on the
contents of two cells in a row will then copy the entire row into a
separate sheet.

Thanks in advance for any advice!

RichE:confused:


--
RichE
------------------------------------------------------------------------
RichE's Profile: http://www.excelforum.com/member.php...o&userid=31539
View this thread: http://www.excelforum.com/showthread...hreadid=512312

Cleaning Data into easy to view report
 

Can you make a formula that evaluates to true/false based on those two
conditions?

If yes, then you could add that formula down the column.
filter that column (data|filter|autofilter)
show the ones you want to copy
copy the visible cells to the new location

Remove the filter, delete this helper column

If you need code, you could record a macro when you do it manually.

RichE wrote:

Hi,

I have a large set of data giving sales information by customer by
month over a period of time with each customers data held in a row.
Within each row are two calculations that define whether that customers
data needs to be put into a another report.

Im a relative macro and vba novice, and struggling to find a non manual
solution.

Really all I need is a way to assess a set of data and depending on the
contents of two cells in a row will then copy the entire row into a
separate sheet.

Thanks in advance for any advice!

RichE:confused:

--
RichE
------------------------------------------------------------------------
RichE's Profile: http://www.excelforum.com/member.php...o&userid=31539
View this thread: http://www.excelforum.com/showthread...hreadid=512312

--

Dave Peterson