Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Copy a Range of Data Beginning and Ending with a Certain Value
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert regular Date to Week Ending or Week Beginning Dates | Excel Discussion (Misc queries) | |||
How do I set end-of-range to #rows from beginning | Charts and Charting in Excel | |||
Change the starting and ending cell of a dynamic named range | Excel Discussion (Misc queries) | |||
Find the beginning Cell of a Range | Excel Discussion (Misc queries) | |||
How do I create consecutive dates between a beginning and ending . | Excel Discussion (Misc queries) |