J
John Yab
Would someone please help me with a macro? I have data on a sheet that I am
trying to selectively move to a summary sheet; below is an example:
Revenue Net
$1,296.00 $24.00
Revenue Net
$964.00 ($28.00)
Revenue Net
$416.00 ($40.00)
$416.00 ($40.00)
$416.00 ($40.00)
There are blocks of data on a sheet. Each block has a different number of
rows. Each block is seperated by one blank row.
In column P is the heading "Net" in each block. Under "Net" can be blanks or
a dollar amount or the blank between blocks of data or a new heading of "Net"
for a new block of data. I am trying to move the dollar amount to a summary
sheet. Sometimes there is more than one dollar amount in each block... I only
want the first instance of the dollar amount then I need to skip to the next
block and get the first instance of the dollar amount in that next block.
Sometimes there is no dollar amount and then I would have to skip to the next
block of data. When/if I find the dollar amount I need to copy and paste it
to the summary sheet and also copy and past the values in that same row from
column A (an ID) and column B (the end date). The value 2nd from the top of
the column B in that block of data is the "start" date. I need to capture the
start date too and move it to the summary sheet. In summary the macro would
grab 4 bits of data and move it to the summary sheet and then move on to the
next block of data a grab and move 4 bits of data from that block, etc.
I have been working hard with loops and cases and if's for a week and can't
quite get it so any help is very appreciated with big thanks.
trying to selectively move to a summary sheet; below is an example:
Revenue Net
$1,296.00 $24.00
Revenue Net
$964.00 ($28.00)
Revenue Net
$416.00 ($40.00)
$416.00 ($40.00)
$416.00 ($40.00)
There are blocks of data on a sheet. Each block has a different number of
rows. Each block is seperated by one blank row.
In column P is the heading "Net" in each block. Under "Net" can be blanks or
a dollar amount or the blank between blocks of data or a new heading of "Net"
for a new block of data. I am trying to move the dollar amount to a summary
sheet. Sometimes there is more than one dollar amount in each block... I only
want the first instance of the dollar amount then I need to skip to the next
block and get the first instance of the dollar amount in that next block.
Sometimes there is no dollar amount and then I would have to skip to the next
block of data. When/if I find the dollar amount I need to copy and paste it
to the summary sheet and also copy and past the values in that same row from
column A (an ID) and column B (the end date). The value 2nd from the top of
the column B in that block of data is the "start" date. I need to capture the
start date too and move it to the summary sheet. In summary the macro would
grab 4 bits of data and move it to the summary sheet and then move on to the
next block of data a grab and move 4 bits of data from that block, etc.
I have been working hard with loops and cases and if's for a week and can't
quite get it so any help is very appreciated with big thanks.