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.