Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Selectively Moving Data to a Summary Sheet
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. -- John Yab |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Moving Selected Fields to Summary Sheet | Excel Discussion (Misc queries) | |||
Generate sheet names from list, assign data to summary sheet. | Excel Programming | |||
How can i copy data from a tabbed working sheet to a summary sheet | Excel Discussion (Misc queries) | |||
Multiple sheet data summary | Excel Worksheet Functions | |||
selectively copying ranges from one sheet to second sheet | Excel Programming |