Excel Macro to choose a line
 

I am trying to figure out how to clean up a workbook automatically. I
have a workbook that has a name and location in the first line. Three
to four rows down I have several columns that have a cost analysis in
them. Problem is I have a 1000 names with cost analysis and I want to
pick the names and then pull the numbers from three lines down and put
all of this into another sheet that is all cleaned up and looks good
so I can analize the data. Can someone help me? I know I want a do
until statement and will probably a if then statement but I can't
figure out how to start. Thank you for anyones help................

Excel Macro to choose a line
 

How about a sample layout and before/after desires.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"bpotter" wrote in message
ups.com...
I am trying to figure out how to clean up a workbook automatically. I
have a workbook that has a name and location in the first line. Three
to four rows down I have several columns that have a cost analysis in
them. Problem is I have a 1000 names with cost analysis and I want to
pick the names and then pull the numbers from three lines down and put
all of this into another sheet that is all cleaned up and looks good
so I can analize the data. Can someone help me? I know I want a do
until statement and will probably a if then statement but I can't
figure out how to start. Thank you for anyones help................

Excel Macro to choose a line
 

On Aug 22, 3:29 pm, "Don Guillett" wrote:
How about a sample layout and before/after desires.

I can't figure out how to paste cells. So here is what I have.

this is my initail worksheet

Name Property Gas Price Oil Price NGL Price Revenue MCFE Total LOE LOE/
MCFE Ad Val Compression Overhead R&M SWD Subsurface Utilities Workover
All Other Sev Tax Op Cash Flow Capital Cash Flow
AMERICAN HORSE 1-5 153240 $4.66 $0.00 $0.00 966,972 207,437 35,617
$0.17 0 0 11,939 4,904 972 0 0 0 17,802 56,268 875,086 17,046 858,040

Line Item Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07
Feb-07 Mar-07 Apr-07 May-07 Jun-07 Total
Cash Flow 68,064 52,562 86,331 76,175 43,437 81,001 86,359 53,142
48,517 65,995 55,346 68,337 72,773 858,041
AWTREY 1-16 156900 $5.34 $59.83 $0.00 280,832 49,406 61,312 $1.24
0 9,790 16,188 7,449 1,023 1,628 0 0 25,234 16,422 203,098 0 203,098

Line Item Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07
Feb-07 Mar-07 Apr-07 May-07 Jun-07 Total
Cash Flow 20,446 25,241 24,319 19,214 11,756 28,780 15,306 9,129
15,915 40,188 12,905 -15,129 -4,974 203,098
AWTREY 2-16 159180 $5.37 $65.07 $0.00 2,121,348 380,824 600,568
$1.58 0 1,786 16,188 11,808 2,964 46,057 0 496,930 24,835 124,755
1,396,025

Line Item Jun-06 Jul-06 Aug-06 Sep-06 Oct-06 Nov-06 Dec-06 Jan-07
Feb-07 Mar-07 Apr-07 May-07 Jun-07 Total
Cash Flow 231,433 208,885 216,316 133,400 79,612
257,359 -256,983 -76,792 137,166 166,584 112,418 77,687 96,070
1,383,154

this is what I would like to be the final.

AMERICAN HORSE 1-5 153240 $68,064 $52,562 $86,331 $76,175
$43,437 $81,001 $86,359 $53,142 $48,517 $65,995