Copy a Range of Data Beginning and Ending with a Certain Value

[cranen]

I don't know if I need a macro or a simple formula. I have a table set up
where data is entered by the user. I take that data and add data to it, and
the compilation is placed in a different area. The compilation has a lot of
values that aren't needed all the time, but might be needed in other
circumstances. Below is a row out of my table.

A B C D E
1 2083.25 2383.25 2448.23 2511.02 2811.02

This data is taken and put into a column that has data before A1, data in
between A1, B1, C1, D1, E1, and data after E1. The column of new data looks
like:

2000.00
2050.00
2083.25
2100.00
2150.00
2200.00
2250.00
2300.00
2350.00
2383.25
2400.00
2448.23
2450.00
2500.00
2511.02
2550.00
2600.00
2650.00
2700.00
2750.00
2800.00
2811.02
2850.00
2900.00
2950.00
3000.00

I need a formula or macro that grabs the value before the A1 value in the
new column, the value after the E1 value in the new column, and everything in
between the A1 and E1 values in the new column. I would like for the macro
or formula to place it in an area I specify. Thanks so much for you help and
time.

 

[Don Guillett]

If desired, send your file to my address below. I will only look if:
1. You send a copy of this message on an inserted sheet
2. You give me the newsgroup and the subject line
3. You send a clear explanation of what you want
4. You send before/after examples and expected results.